FV_TREASURY_CONFIRM_PAYMENTS_V

Details

• Schema: FUSION

• Object owner: FV

• Object type: VIEW

Columns

Name
PAYMENT_PROCESS_REQUEST TREASURY_CONFIRMATION_ID CHECK_ID PAYMENT_INSTRUCTION_ID SUPPLIER_NAME SUPPLIER_SITE PAYMENT_NUMBER TREASURY_PAYMENT_NUMBER AMOUNT CONFIRMATION_DATE PAYMENT_VOIDED PAYMENT_ACCOUNTED CHECK_NUMBER_UPDATED OFFSET

Query

SQL_Statement

SELECT A.CHECKRUN_NAME PAYMENT_PROCESS_REQUEST, B.TREASURY_CONFIRMATION_ID TREASURY_CONFIRMATION_ID, A.CHECK_ID CHECK_ID, B.PAYMENT_INSTRUCTION_ID PAYMENT_INSTRUCTION_ID, A.VENDOR_NAME SUPPLIER_NAME, A.VENDOR_SITE_CODE SUPPLIER_SITE, A.CHECK_NUMBER PAYMENT_NUMBER, A.TREASURY_PAY_NUMBER TREASURY_PAYMENT_NUMBER, A.AMOUNT AMOUNT, B.TREASURY_CONFIRM_DATE CONFIRMATION_DATE, DECODE(A.VOID_DATE,NULL,'No', 'Yes') PAYMENT_VOIDED, DECODE((SELECT COUNT(1) FROM AP_INVOICE_PAYMENTS_ALL D WHERE D.CHECK_ID = A.CHECK_ID AND D.POSTED_FLAG = 'Y'), 0, 'No', 'Yes') PAYMENT_ACCOUNTED, DECODE((SELECT COUNT(1) FROM FV_TREASURY_OFFSET_AMOUNTS E WHERE E.TREASURY_CONFIRMATION_ID =B.TREASURY_CONFIRMATION_ID AND E.ORIGINAL_TREASURY_PAY_NUM = A.TREASURY_PAY_NUMBER AND E.OFFSET_TREASURY_PAY_NUM <> A.TREASURY_PAY_NUMBER),0,'No', 'Yes') CHECK_NUMBER_UPDATED, DECODE((SELECT COUNT(1) FROM FV_TREASURY_OFFSET_AMOUNTS F WHERE F.TREASURY_CONFIRMATION_ID = B.TREASURY_CONFIRMATION_ID AND F.ORIGINAL_TREASURY_PAY_NUM = A.TREASURY_PAY_NUMBER), 0, 'No', 'Yes') OFFSET FROM AP_CHECKS_ALL A, FV_TREASURY_CONFIRM_ALL B WHERE A.PAYMENT_INSTRUCTION_ID = B.PAYMENT_INSTRUCTION_ID