DBA Data[Home] [Help]

VIEW: APPS.EDW_INV_TYPE_MPV

Source

View Text - Preformatted

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'
View Text - HTML Formatted

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'