VIEW: APPS.EDW_AP_PAYMENT_MPV

Source

View Text - Preformatted

SELECT to_char(aip.invoice_payment_id)||'-'||to_char(aip.org_id)||'-'|| substrb(edw_instance.get_code,1,40) , aip.last_update_date from ap_invoice_payments_all aip, ap_checks_all ac, ap_invoices_all ai WHERE aip.invoice_id = ai.invoice_id and aip.org_id = ai.org_id and aip.check_id = ac.check_id and aip.org_id = ac.org_id and ac.status_lookup_code NOT IN ('OVERFLOW','SET UP','SPOILED','UNCONFIRMED SET UP','VOIDED')

View Text - HTML Formatted

SELECT TO_CHAR(AIP.INVOICE_PAYMENT_ID)||'-'||TO_CHAR(AIP.ORG_ID)||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, AIP.LAST_UPDATE_DATE
FROM AP_INVOICE_PAYMENTS_ALL AIP
, AP_CHECKS_ALL AC
, AP_INVOICES_ALL AI
WHERE AIP.INVOICE_ID = AI.INVOICE_ID
AND AIP.ORG_ID = AI.ORG_ID
AND AIP.CHECK_ID = AC.CHECK_ID
AND AIP.ORG_ID = AC.ORG_ID
AND AC.STATUS_LOOKUP_CODE NOT IN ('OVERFLOW'
, 'SET UP'
, 'SPOILED'
, 'UNCONFIRMED SET UP'
, 'VOIDED')