View: EDW_AP_PAYMENT_MPV

Product:	FII - Financial Intelligence
Description:	EDW_AP_PAYMENT_MPV is the view for data validity on source side.
Implementation/DBA Data:	APPS.EDW_AP_PAYMENT_MPV

View Text

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')

Columns