VIEW: APPS.FIIBV_AP_AP_APPY_PAYMENT_LCV

Source

View Text - Preformatted

SELECT to_char(aip.invoice_payment_id)||'-'||to_char(aip.org_id)||'-'|| substrb(edw_instance.get_code,1,40) PAYMENT_PK, to_char(aip.check_id)||'-'||to_char(aip.org_id)||'-'|| substrb(edw_instance.get_code,1,40) CHECK_FK, substrb(edw_instance.get_code,1,40) INSTANCE, ai.invoice_num||'-'||to_char(aip.payment_num) NAME, ai.invoice_num||'-'||to_char(aip.payment_num) PAYMENT, to_char(aip.invoice_payment_id) INVOICE_PAYMENT_ID, aip.last_update_date LAST_UPDATE_DATE, aip.creation_date CREATION_DATE, decode(ac.status_lookup_code,'VOIDED',sysdate,NULL) DELETION_DATE, NULL PAYMENT_DP, '_df:JG:JG_AP_INVOICE_PAYMENTS:aip', '_df:SQLAP:AP_CHECKS:ac', '_df:SQLAP:Check Address:ac', '_df:SQLAP:ap_gov_detail_checks:ac', '_df:JG:JG_AP_CHECKS:ac', '_df:SQLAP:AP_INVOICES:ai', '_df:SQLAP:ap_gov_detail_invoices:ai', '_df:JG:JG_AP_INVOICES:ai' from ap_invoice_payments_all aip, ap_checks_all ac, ap_invoices_all ai WHERE aip.invoice_id = ai.invoice_id and aip.check_id = ac.check_id and ac.status_lookup_code NOT IN ('OVERFLOW','SET UP','SPOILED','UNCONFIRMED SET UP')

View Text - HTML Formatted

SELECT TO_CHAR(AIP.INVOICE_PAYMENT_ID)||'-'||TO_CHAR(AIP.ORG_ID)||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) PAYMENT_PK
, TO_CHAR(AIP.CHECK_ID)||'-'||TO_CHAR(AIP.ORG_ID)||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) CHECK_FK
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, AI.INVOICE_NUM||'-'||TO_CHAR(AIP.PAYMENT_NUM) NAME
, AI.INVOICE_NUM||'-'||TO_CHAR(AIP.PAYMENT_NUM) PAYMENT
, TO_CHAR(AIP.INVOICE_PAYMENT_ID) INVOICE_PAYMENT_ID
, AIP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AIP.CREATION_DATE CREATION_DATE
, DECODE(AC.STATUS_LOOKUP_CODE
, 'VOIDED'
, SYSDATE
, NULL) DELETION_DATE
, NULL PAYMENT_DP
, '_DF:JG:JG_AP_INVOICE_PAYMENTS:AIP'
, '_DF:SQLAP:AP_CHECKS:AC'
, '_DF:SQLAP:CHECK ADDRESS:AC'
, '_DF:SQLAP:AP_GOV_DETAIL_CHECKS:AC'
, '_DF:JG:JG_AP_CHECKS:AC'
, '_DF:SQLAP:AP_INVOICES:AI'
, '_DF:SQLAP:AP_GOV_DETAIL_INVOICES:AI'
, '_DF:JG:JG_AP_INVOICES:AI'
FROM AP_INVOICE_PAYMENTS_ALL AIP
, AP_CHECKS_ALL AC
, AP_INVOICES_ALL AI
WHERE AIP.INVOICE_ID = AI.INVOICE_ID
AND AIP.CHECK_ID = AC.CHECK_ID
AND AC.STATUS_LOOKUP_CODE NOT IN ('OVERFLOW'
, 'SET UP'
, 'SPOILED'
, 'UNCONFIRMED SET UP')