VIEW: APPS.XTR_CE_DEAL_DATE_AMOUNTS_V

Source

View Text - Preformatted

SELECT DDA.ACCOUNT_NO, DDA.ACCRUAL_FROM, DDA.ACCRUAL_TO, DDA.ACTION_CODE, DDA.ACTION_COMPLETED, DDA.ACTUAL_SETTLEMENT_DATE, DDA.AMOUNT, DDA.AMOUNT_DATE, DDA.AMOUNT_TYPE, DDA.ARCHIVE_BY, DDA.ARCHIVE_DATE, DDA.ATTACHMENT_EXISTS, DDA.AUDIT_INDICATOR, DDA.AUTHORISED, DDA.BALANCE_SHEET_EXPOSURE, DDA.BENEFICIARY_ACCOUNT_NO, DDA.BENEFICIARY_PARTY, DDA.CASHFLOW_AMOUNT, DDA.CHQ_REQD, DDA.CLIENT_BROKER_CLRACCT, DDA.CLIENT_CODE, DDA.COMMENCE_DATE, DDA.COMMENTS, DDA.COMPANY_CODE, DDA.CONTRACT_CODE, DDA.CPARTY_ACCOUNT_NO, DDA.CPARTY_CODE, DDA.CURRENCY, DDA.CURRENCY_COMBINATION, DDA.DATE_TYPE, DDA.DEALER_CODE, DDA.DEAL_NUMBER, DDA.DEAL_ORDERS, DDA.DEAL_SUBTYPE, DDA.DEAL_TYPE, DDA.DIARY_CREATED_BY, DDA.DIARY_NOTE, DDA.DIRECT_DEBIT, DDA.DUAL_AUTHORISATION_BY, DDA.DUAL_AUTHORISATION_ON, DDA.EXPOSURE_REF_DATE, DDA.EXP_SETTLE_REQD, DDA.EXTERNAL_COMMENTS, DDA.FIRST_ACCRUAL, DDA.FRA_DESCRIPTION, DDA.GENERAL_OR_PRIVATE_ACCESS, DDA.CODE_COMBINATION_ID, DDA.GOOD_VALUE_CLAIM, DDA.HCE_AMOUNT, DDA.JOURNAL_CREATED, DDA.LIMIT_CODE, DDA.LIMIT_PARTY, DDA.MULTIPLE_REFERENCE_NUMBER, DDA.MULTIPLE_SETTLEMENTS, DDA.NETOFF_GROUP_FLAG, DDA.NETOFF_NUMBER, DDA.PORTFOLIO_CODE, DDA.PRINTED_MATURITY_YN, DDA.PRODUCT_TYPE, DDA.QUICK_INPUT, DDA.RECONCILED_DAYS_ADJUST, DDA.RECONCILED_PASS_CODE, DDA.RECONCILED_REFERENCE, DDA.SERIAL_REFERENCE, DDA.SETTLE, DDA.SETTLEMENT_ACTIONED, DDA.SETTLEMENT_ACTIONED_FILE, DDA.SETTLEMENT_AUTHORISED_BY, DDA.SETTLEMENT_NUMBER, DDA.SETTLEMENT_PARTY, DDA.STATUS_CODE, DDA.TRANSACTION_DATE, DDA.TRANSACTION_NUMBER, DDA.TRANSACTION_RATE, DDA.TRANS_MTS, DDA.UPDATED_BY, DDA.UPDATED_ON, DDA.ORIGINAL_SETTLEMENT_CURRENCY, DDA.ORIGINAL_SETTLEMENT_AMOUNT, DDA.COMPANY_HCE_AMOUNT, DDA.CREATED_BY, DDA.CREATED_ON, DDA.BATCH_ID, DDA.DEAL_DATE_AMOUNT_ID, DDA.COMPANY_ACCT_USE_ID, DDA.CPARTY_ACCT_USE_ID, DDA.BENEFECIARY_ACCT_USE_ID, XPI.LEGAL_ENTITY_ID From xtr_deal_date_amounts dda, xtr_party_info xpi WHERE dda.company_code = xpi.party_code

View Text - HTML Formatted

SELECT DDA.ACCOUNT_NO
, DDA.ACCRUAL_FROM
, DDA.ACCRUAL_TO
, DDA.ACTION_CODE
, DDA.ACTION_COMPLETED
, DDA.ACTUAL_SETTLEMENT_DATE
, DDA.AMOUNT
, DDA.AMOUNT_DATE
, DDA.AMOUNT_TYPE
, DDA.ARCHIVE_BY
, DDA.ARCHIVE_DATE
, DDA.ATTACHMENT_EXISTS
, DDA.AUDIT_INDICATOR
, DDA.AUTHORISED
, DDA.BALANCE_SHEET_EXPOSURE
, DDA.BENEFICIARY_ACCOUNT_NO
, DDA.BENEFICIARY_PARTY
, DDA.CASHFLOW_AMOUNT
, DDA.CHQ_REQD
, DDA.CLIENT_BROKER_CLRACCT
, DDA.CLIENT_CODE
, DDA.COMMENCE_DATE
, DDA.COMMENTS
, DDA.COMPANY_CODE
, DDA.CONTRACT_CODE
, DDA.CPARTY_ACCOUNT_NO
, DDA.CPARTY_CODE
, DDA.CURRENCY
, DDA.CURRENCY_COMBINATION
, DDA.DATE_TYPE
, DDA.DEALER_CODE
, DDA.DEAL_NUMBER
, DDA.DEAL_ORDERS
, DDA.DEAL_SUBTYPE
, DDA.DEAL_TYPE
, DDA.DIARY_CREATED_BY
, DDA.DIARY_NOTE
, DDA.DIRECT_DEBIT
, DDA.DUAL_AUTHORISATION_BY
, DDA.DUAL_AUTHORISATION_ON
, DDA.EXPOSURE_REF_DATE
, DDA.EXP_SETTLE_REQD
, DDA.EXTERNAL_COMMENTS
, DDA.FIRST_ACCRUAL
, DDA.FRA_DESCRIPTION
, DDA.GENERAL_OR_PRIVATE_ACCESS
, DDA.CODE_COMBINATION_ID
, DDA.GOOD_VALUE_CLAIM
, DDA.HCE_AMOUNT
, DDA.JOURNAL_CREATED
, DDA.LIMIT_CODE
, DDA.LIMIT_PARTY
, DDA.MULTIPLE_REFERENCE_NUMBER
, DDA.MULTIPLE_SETTLEMENTS
, DDA.NETOFF_GROUP_FLAG
, DDA.NETOFF_NUMBER
, DDA.PORTFOLIO_CODE
, DDA.PRINTED_MATURITY_YN
, DDA.PRODUCT_TYPE
, DDA.QUICK_INPUT
, DDA.RECONCILED_DAYS_ADJUST
, DDA.RECONCILED_PASS_CODE
, DDA.RECONCILED_REFERENCE
, DDA.SERIAL_REFERENCE
, DDA.SETTLE
, DDA.SETTLEMENT_ACTIONED
, DDA.SETTLEMENT_ACTIONED_FILE
, DDA.SETTLEMENT_AUTHORISED_BY
, DDA.SETTLEMENT_NUMBER
, DDA.SETTLEMENT_PARTY
, DDA.STATUS_CODE
, DDA.TRANSACTION_DATE
, DDA.TRANSACTION_NUMBER
, DDA.TRANSACTION_RATE
, DDA.TRANS_MTS
, DDA.UPDATED_BY
, DDA.UPDATED_ON
, DDA.ORIGINAL_SETTLEMENT_CURRENCY
, DDA.ORIGINAL_SETTLEMENT_AMOUNT
, DDA.COMPANY_HCE_AMOUNT
, DDA.CREATED_BY
, DDA.CREATED_ON
, DDA.BATCH_ID
, DDA.DEAL_DATE_AMOUNT_ID
, DDA.COMPANY_ACCT_USE_ID
, DDA.CPARTY_ACCT_USE_ID
, DDA.BENEFECIARY_ACCT_USE_ID
, XPI.LEGAL_ENTITY_ID
FROM XTR_DEAL_DATE_AMOUNTS DDA
, XTR_PARTY_INFO XPI
WHERE DDA.COMPANY_CODE = XPI.PARTY_CODE