VIEW: APPS.XTR_A_EXPOSURE_TRANSACTIONS_V

Source

View Text - Preformatted

SELECT TRANSACTION_NUMBER, COMPANY_CODE, DEAL_TYPE, DEAL_SUBTYPE, EXPOSURE_TYPE, CURRENCY, VALUE_DATE, AMOUNT, SETTLE_ACTION_REQD, AMOUNT_HCE, CREATED_BY, CREATED_ON, UPDATED_BY, UPDATED_ON, THIRDPARTY_CODE, ACTION_CODE, AMOUNT_TYPE, ACCOUNT_NO, COMMENTS, CPARTY_REF, PORTFOLIO_CODE, TAX_BROKERAGE_TYPE, ARCHIVE_DATE, ARCHIVE_BY, PURCHASING_MODULE, BENEFICIARY_CODE, NZD_AMOUNT, FIS_FOB, SUBSIDIARY_REF, INTERMEDIARY_BANK_DETAILS, DEAL_STATUS, WHOLESALE_REFERENCE, SELECT_REFERENCE, PROFIT_LOSS, SELECT_ACTION, PAYMENT_AMOUNT, BALANCE, AVG_RATE, CONTRA_NZD_AMOUNT, CPARTY_CODE, PAYMENT_STATUS, ESTIMATE_DATE, ESTIMATE_AMOUNT, COVERED_BY_FX_CONTRACT, STATUS_CODE, AUDIT_INDICATOR, AUDIT_DATE_STORED from XTR_A_EXPOSURE_TRANSACTIONS

View Text - HTML Formatted

SELECT TRANSACTION_NUMBER
, COMPANY_CODE
, DEAL_TYPE
, DEAL_SUBTYPE
, EXPOSURE_TYPE
, CURRENCY
, VALUE_DATE
, AMOUNT
, SETTLE_ACTION_REQD
, AMOUNT_HCE
, CREATED_BY
, CREATED_ON
, UPDATED_BY
, UPDATED_ON
, THIRDPARTY_CODE
, ACTION_CODE
, AMOUNT_TYPE
, ACCOUNT_NO
, COMMENTS
, CPARTY_REF
, PORTFOLIO_CODE
, TAX_BROKERAGE_TYPE
, ARCHIVE_DATE
, ARCHIVE_BY
, PURCHASING_MODULE
, BENEFICIARY_CODE
, NZD_AMOUNT
, FIS_FOB
, SUBSIDIARY_REF
, INTERMEDIARY_BANK_DETAILS
, DEAL_STATUS
, WHOLESALE_REFERENCE
, SELECT_REFERENCE
, PROFIT_LOSS
, SELECT_ACTION
, PAYMENT_AMOUNT
, BALANCE
, AVG_RATE
, CONTRA_NZD_AMOUNT
, CPARTY_CODE
, PAYMENT_STATUS
, ESTIMATE_DATE
, ESTIMATE_AMOUNT
, COVERED_BY_FX_CONTRACT
, STATUS_CODE
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
FROM XTR_A_EXPOSURE_TRANSACTIONS