SYSTEM@myriad1> set lines 120 SYSTEM@myriad1> select dbms_metadata.get_ddl ('VIEW','DH_CNP','RISKIDS') from dual; DBMS_METADATA.GET_DDL('VIEW','DH_CNP','RISKIDS') -------------------------------------------------------------------------------- CREATE OR REPLACE FORCE VIEW "RISKIDS"."DH_CNP" ("TXN_ID" , "RELATIONSHIP_ID", "ACCOUNT_ID", "APPL ICATION_ID", "CREATED_DATE", "FRAUD_DISP OSITION", "DISPUTE_DISPOSITION", "BIN_NU MBER", "CREDIT_CARD_ISSUER", "IP_ADDRESS ", "IP_COUNTRY_CODE", "CREDIT_CARD_TYPE" , "COUNTRY_CARD_ISSUE_CODE", "CURRENCY_C ODE", "TRX_AMT", "TOKEN_NUMBER_PAN", "PA YMENT_SOLUTION", "CUSTOMER_ID", "TXN_TYP E", "CHANNEL", "KYC_AUTH_RESPONSE", "KYC _AUTH_PROVIDER", "EMAIL", "ADDRESS_NAME" , "ADDRESS_NUMBER", "ADDRESS_STREET", "A DDRESS_DISTRICT", "ADDRESS_TOWN", "ADDRE SS_COUNTRY_CODE", "ADDRESS_POSTCODE", "R ESPONSE_CODE", "FRAUD_SCORE", "ACCOUNT_O PEN_AGE", "ACCOUNT_EFFECTIVE_AGE", "BASE _ACCOUNTING_AMT") AS SELECT DISTINCT txn_id, p.relationship_id, a.account_id, p.application_id, t.created_date, T.FRAUD_DISPOSITION_ID AS FRAUD_DISPOSIT ION, T.DISPUTE_DISPOSITION_ID AS DISPUTE_DISPOSITION, BIN_6 AS BIN_NUMB ER, BIN_ISSUER AS CREDIT_CARD_ISSUER, IP AS IP_ADDRESS , ipc.alpha_country_code AS IP_COUNTRY_CODE, BIN_ISSUER_CARD_TYPE_ID AS CREDIT_CARD_TYPE , BCC.ALPHA_COUNTRY_CODE AS COUNTRY_CARD_ISSUE_CODE, tcc.alpha_currency_code AS CURRENCY_CODE, t.AMT_TXN AS TRX_AMT, t.PAN AS TOKEN_NUMBER_ PAN, T.MERCHANT_SOLUTION_ID AS PAYMENT_SOLUTION, t.ACCOUNT_REF AS CUSTOMER_ID, t.TXN_TYPE_ID AS TXN_TYPE, T.CHANNEL_ID AS CHANNEL, T.AUTHENTICATION_RESPONSE_ID AS KYC_AUTH_RESPONSE, T.AUTHENTICATION_PROVIDER_ID AS KYC_A UTH_PROVIDER, t.EMAIL, t.ADDRESS_NAME, t.ADDRESS_NUMBER, t.ADDRESS_STREET, t.ADDRESS_DISTRICT, t.ADDRESS_TOWN, acc.alpha_country_code AS ADDRESS_COUNTRY_CODE, t.ADDRESS_POSTCODE, t.RESPONSE_CODE, t.FRAUD_SCORE, t.ACCOUNT_OPEN_AGE, t.ACCOUNT_EFFECTIVE_AGE, T.BASE_ACCOUNTING_AMT FROM lt_txn t, lt_country ipc, lt_country bcc, lt_country acc, lt_currency tcc, lt_accounts a, lt_applications p WHERE ipc.numeric_country_code(+) = t.ip_ country AND bcc.numeric_country_code(+) = t.bin_issu er_country AND acc.numeric_country_code(+) = t.addre ss_country AND tcc.numeric_currency_code(+) = t.curre ncy_code_txn AND t.account_id = a.a ccount_id AND a.application_id = p.applic ation_id SYSTEM@myriad1> spool off