VIEW: APPS.XTR_R_DEAL_DATE_AMOUNTS_V

Source

View Text - Preformatted

SELECT DEAL_TYPE, AMOUNT_TYPE, DATE_TYPE, DEAL_NUMBER , TRANSACTION_DATE, CURRENCY, AMOUNT, HCE_AMOUNT, AMOUNT_DATE, TRANSACTION_RATE, CASHFLOW_AMOUNT, COMPANY_CODE, ACCOUNT_NO, CPARTY_ACCOUNT_NO, CHQ_REQD, ACTION_CODE, TRANSACTION_NUMBER, JOURNAL_CREATED, DIARY_NOTE, AUTHORISED, DIRECT_DEBIT, TRANS_MTS, SETTLE, DEAL_SUBTYPE, PRODUCT_TYPE, LIMIT_CODE, STATUS_CODE, CLIENT_CODE, CPARTY_CODE, PORTFOLIO_CODE, DIARY_CREATED_BY, DEAL_ORDERS, DEALER_CODE, DUAL_AUTHORISATION_BY, MULTIPLE_SETTLEMENTS, MULTIPLE_REFERENCE_NUMBER, SETTLEMENT_NUMBER, SETTLEMENT_AUTHORISED_BY, SETTLEMENT_PARTY, COMMENTS, CODE_COMBINATION_ID, CLIENT_BROKER_CLRACCT, EXP_SETTLE_REQD, LIMIT_PARTY, DUAL_AUTHORISATION_ON, ARCHIVE_DATE, ARCHIVE_BY, CONTRACT_CODE, NETOFF_NUMBER, BENEFICIARY_PARTY, UPDATED_BY, UPDATED_ON, AUDIT_INDICATOR, RECONCILED_PASS_CODE, RECONCILED_REFERENCE, RECONCILED_DAYS_ADJUST, SERIAL_REFERENCE, BENEFICIARY_ACCOUNT_NO, FIRST_ACCRUAL, ACCRUAL_FROM, ACCRUAL_TO, FRA_DESCRIPTION, GENERAL_OR_PRIVATE_ACCESS, CURRENCY_COMBINATION, ACTUAL_SETTLEMENT_DATE, GOOD_VALUE_CLAIM, NETOFF_GROUP_FLAG, SETTLEMENT_ACTIONED, SETTLEMENT_ACTIONED_FILE, QUICK_INPUT, EXTERNAL_COMMENTS, EXPOSURE_REF_DATE, ATTACHMENT_EXISTS, COMMENCE_DATE, PRINTED_MATURITY_YN, BALANCE_SHEET_EXPOSURE, ACTION_COMPLETED from XTR_R_DEAL_DATE_AMOUNTS

View Text - HTML Formatted

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