VIEW: APPS.FV_TREAS_PMTS_TRANSACTION_V

Source

View Text - Preformatted

SELECT FTC.Treasury_confirmation_id, FTC.Treasury_doc_date, CPD.payment_document_name, IPI.pay_admin_assigned_ref_code, FTC.payment_instruction_id FROM fv_treasury_confirmations_all FTC INNER JOIN ap_checks_all AC ON FTC.payment_instruction_id = AC.payment_instruction_id INNER JOIN iby_pay_instructions_all IPI ON FTC.payment_instruction_id = IPI.payment_instruction_id LEFT OUTER JOIN ce_payment_documents CPD ON AC.payment_document_id = CPD.payment_document_id GROUP BY FTC.payment_instruction_id, FTC.Treasury_confirmation_id, FTC.Treasury_doc_date, IPI.pay_admin_assigned_ref_code, CPD.payment_document_name

View Text - HTML Formatted

SELECT FTC.TREASURY_CONFIRMATION_ID
, FTC.TREASURY_DOC_DATE
, CPD.PAYMENT_DOCUMENT_NAME
, IPI.PAY_ADMIN_ASSIGNED_REF_CODE
, FTC.PAYMENT_INSTRUCTION_ID
FROM FV_TREASURY_CONFIRMATIONS_ALL FTC INNER JOIN AP_CHECKS_ALL AC ON FTC.PAYMENT_INSTRUCTION_ID = AC.PAYMENT_INSTRUCTION_ID INNER JOIN IBY_PAY_INSTRUCTIONS_ALL IPI ON FTC.PAYMENT_INSTRUCTION_ID = IPI.PAYMENT_INSTRUCTION_ID LEFT OUTER JOIN CE_PAYMENT_DOCUMENTS CPD ON AC.PAYMENT_DOCUMENT_ID = CPD.PAYMENT_DOCUMENT_ID GROUP BY FTC.PAYMENT_INSTRUCTION_ID
, FTC.TREASURY_CONFIRMATION_ID
, FTC.TREASURY_DOC_DATE
, IPI.PAY_ADMIN_ASSIGNED_REF_CODE
, CPD.PAYMENT_DOCUMENT_NAME