Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XTR_R_DEAL_DATE_AMOUNTS_V |
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