[Home] [Help]
View: EDW_INV_TYPE_MPV
Product: | FII - Financial Intelligence |
Description: | EDW_INV_TYPE_MPV is the view for data validity on source side. |
Implementation/DBA Data: |
APPS.EDW_INV_TYPE_MPV
|
View Text
SELECT TO_CHAR(INVOICE_ID)||'-'||TO_CHAR(ORG_ID)|| '-'||SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, LAST_UPDATE_DATE
FROM AP_INVOICES_ALL AI
WHERE INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
Columns