[Home] [Help]
View: EDW_INV_TYPE_MPV
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | EDW_INV_TYPE_MPV is the view for data validity on source side. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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