VIEW: APPS.XTR_DEAL_DATE_AMOUNTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'