[Home] [Help]
| Product: | FII - Financial Intelligence (Obsolete) |
|---|---|
| Description: | FIIBV_AP_AP_APPY_PAYMENT_LCV is the base view for Payment level of AP Payment dimension |
| Implementation/DBA Data: | Not implemented in this database |
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')