eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XTR_CE_DEAL_DATE_AMOUNTS_V

Product:	XTR - Treasury
Description:	To find available treasury transactions for reconciliation.
Implementation/DBA Data:	APPS.XTR_CE_DEAL_DATE_AMOUNTS_V

View Text

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

Columns

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