VIEW: XTR.XTR_CONFIRMATION_DETAILS#

Source

View Text - Preformatted

select ACTION_TYPE ACTION_TYPE, AMOUNT AMOUNT, AMOUNT_TYPE AMOUNT_TYPE, CLIENT_CODE CLIENT_CODE, COMPANY_CODE COMPANY_CODE, CONFIRMATION_VALIDATED_BY CONFIRMATION_VALIDATED_BY, CONFIRMATION_VALIDATED_ON CONFIRMATION_VALIDATED_ON, CONFO_PARTY_CODE CONFO_PARTY_CODE, CONFO_VALIDATION_BOTH CONFO_VALIDATION_BOTH, CPARTY_CODE CPARTY_CODE, CURRENCY CURRENCY, DATE_ACTION_INITIATED DATE_ACTION_INITIATED, DEAL_NO DEAL_NO, DEAL_SUBTYPE DEAL_SUBTYPE, DEAL_TYPE DEAL_TYPE, DEAL_UPDATED_YN DEAL_UPDATED_YN, FILE_NAME FILE_NAME, INITIALLY_PRINTED_ON INITIALLY_PRINTED_ON, PARTY_CONFO_CHECKED PARTY_CONFO_CHECKED, PARTY_CONFO_CHECKED_BY PARTY_CONFO_CHECKED_BY, PARTY_CONFO_CHECKED_ON PARTY_CONFO_CHECKED_ON, PARTY_CONFO_FILE_NAME PARTY_CONFO_FILE_NAME, REPRINTED_ON REPRINTED_ON, REPRINT_REQUESTED_BY REPRINT_REQUESTED_BY, SETTLE_DATE SETTLE_DATE, STATUS_CODE STATUS_CODE, TRANSACTION_NO TRANSACTION_NO from "XTR"."XTR_CONFIRMATION_DETAILS"

View Text - HTML Formatted

SELECT ACTION_TYPE ACTION_TYPE
, AMOUNT AMOUNT
, AMOUNT_TYPE AMOUNT_TYPE
, CLIENT_CODE CLIENT_CODE
, COMPANY_CODE COMPANY_CODE
, CONFIRMATION_VALIDATED_BY CONFIRMATION_VALIDATED_BY
, CONFIRMATION_VALIDATED_ON CONFIRMATION_VALIDATED_ON
, CONFO_PARTY_CODE CONFO_PARTY_CODE
, CONFO_VALIDATION_BOTH CONFO_VALIDATION_BOTH
, CPARTY_CODE CPARTY_CODE
, CURRENCY CURRENCY
, DATE_ACTION_INITIATED DATE_ACTION_INITIATED
, DEAL_NO DEAL_NO
, DEAL_SUBTYPE DEAL_SUBTYPE
, DEAL_TYPE DEAL_TYPE
, DEAL_UPDATED_YN DEAL_UPDATED_YN
, FILE_NAME FILE_NAME
, INITIALLY_PRINTED_ON INITIALLY_PRINTED_ON
, PARTY_CONFO_CHECKED PARTY_CONFO_CHECKED
, PARTY_CONFO_CHECKED_BY PARTY_CONFO_CHECKED_BY
, PARTY_CONFO_CHECKED_ON PARTY_CONFO_CHECKED_ON
, PARTY_CONFO_FILE_NAME PARTY_CONFO_FILE_NAME
, REPRINTED_ON REPRINTED_ON
, REPRINT_REQUESTED_BY REPRINT_REQUESTED_BY
, SETTLE_DATE SETTLE_DATE
, STATUS_CODE STATUS_CODE
, TRANSACTION_NO TRANSACTION_NO
FROM "XTR"."XTR_CONFIRMATION_DETAILS"