Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XTR_DEAL_DATE_AMOUNTS_V |
SELECT XDDA.DEAL_TYPE
, XDDA.BATCH_ID
, XDDA.AMOUNT_TYPE
, XDDA.DATE_TYPE
, XDDA.DEAL_NUMBER
, XDDA.TRANSACTION_DATE
, XDDA.CURRENCY
, XDDA.AMOUNT
, XDDA.HCE_AMOUNT
, XDDA.AMOUNT_DATE
, XDDA.TRANSACTION_RATE
, XDDA.CASHFLOW_AMOUNT
, XDDA.COMPANY_CODE
, XDDA.ACCOUNT_NO
, XDDA.CPARTY_ACCOUNT_NO
, XDDA.CHQ_REQD
, XDDA.ACTION_CODE
, XDDA.TRANSACTION_NUMBER
, XDDA.DIARY_NOTE
, XDDA.AUTHORISED
, XDDA.DIRECT_DEBIT
, XDDA.TRANS_MTS
, XDDA.SETTLE
, XDDA.DEAL_SUBTYPE
, XDDA.PRODUCT_TYPE
, XDDA.LIMIT_CODE
, XDDA.STATUS_CODE
, XDDA.CLIENT_CODE
, XDDA.CPARTY_CODE
, XDDA.PORTFOLIO_CODE
, XDDA.DIARY_CREATED_BY
, XDDA.DEAL_ORDERS
, XDDA.DEALER_CODE
, XDDA.DUAL_AUTHORISATION_BY
, XDDA.MULTIPLE_SETTLEMENTS
, XDDA.MULTIPLE_REFERENCE_NUMBER
, XDDA.SETTLEMENT_NUMBER
, XDDA.SETTLEMENT_AUTHORISED_BY
, XDDA.SETTLEMENT_PARTY
, XDDA.COMMENTS
, XDDA.CODE_COMBINATION_ID
, XDDA.CLIENT_BROKER_CLRACCT
, XDDA.EXP_SETTLE_REQD
, XDDA.LIMIT_PARTY
, XDDA.DUAL_AUTHORISATION_ON
, XDDA.ARCHIVE_DATE
, XDDA.ARCHIVE_BY
, XDDA.CONTRACT_CODE
, XDDA.NETOFF_NUMBER
, XDDA.BENEFICIARY_PARTY
, XDDA.UPDATED_BY
, XDDA.UPDATED_ON
, XDDA.AUDIT_INDICATOR
, XDDA.RECONCILED_PASS_CODE
, XDDA.RECONCILED_REFERENCE
, XDDA.RECONCILED_DAYS_ADJUST
, XDDA.SERIAL_REFERENCE
, XDDA.BENEFICIARY_ACCOUNT_NO
, XDDA.FIRST_ACCRUAL
, XDDA.ACCRUAL_FROM
, XDDA.ACCRUAL_TO
, XDDA.FRA_DESCRIPTION
, XDDA.GENERAL_OR_PRIVATE_ACCESS
, XDDA.CURRENCY_COMBINATION
, XDDA.ACTUAL_SETTLEMENT_DATE
, XDDA.GOOD_VALUE_CLAIM
, XDDA.NETOFF_GROUP_FLAG
, XDDA.SETTLEMENT_ACTIONED
, XDDA.SETTLEMENT_ACTIONED_FILE
, XDDA.QUICK_INPUT
, XDDA.EXTERNAL_COMMENTS
, XDDA.EXPOSURE_REF_DATE
, XDDA.ATTACHMENT_EXISTS
, XDDA.COMMENCE_DATE
, XDDA.PRINTED_MATURITY_YN
, XDDA.BALANCE_SHEET_EXPOSURE
, XDDA.ACTION_COMPLETED
, XDDA.ORIGINAL_SETTLEMENT_CURRENCY
, XDDA.ORIGINAL_SETTLEMENT_AMOUNT
, XDDA.COMPANY_HCE_AMOUNT
, XDDA.CREATED_BY
, XDDA.CREATED_ON
FROM XTR_DEAL_DATE_AMOUNTS XDDA
WHERE XDDA.COMPANY_CODE IN (SELECT XCA.PARTY_CODE
FROM XTR_COMPANY_AUTHORITIES XCA
WHERE XCA.DEALER_CODE = XTR_USER_ACCESS.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y' ) OR XDDA.DEAL_TYPE = 'DN'