VIEW: APPS.FIIBV_AP_IVTY_INV_LCV

Source

View Text - Preformatted

SELECT to_char(invoice_id)||'-'||to_char(org_id)|| '-'||substrb(edw_instance.get_code,1,40) INV_PK, invoice_type_lookup_code INV_TYPE_FK, to_char(invoice_id) INV_ID, invoice_num NAME, invoice_num INV_NAME, substrb(edw_instance.get_code,1,40) INSTANCE, source INV_SOURCE, cancelled_date CANCELLED_DATE, last_update_date LAST_UPDATE_DATE, creation_date CREATION_DATE, NULL DELETION_DATE, NULL INV_DP, '_df:SQLAP:AP_INVOICES:ai', '_df:SQLAP:ap_gov_detail_invoices:ai', '_df:JG:JG_AP_INVOICES:ai' from ap_invoices_all ai

View Text - HTML Formatted

SELECT TO_CHAR(INVOICE_ID)||'-'||TO_CHAR(ORG_ID)|| '-'||SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INV_PK
, INVOICE_TYPE_LOOKUP_CODE INV_TYPE_FK
, TO_CHAR(INVOICE_ID) INV_ID
, INVOICE_NUM NAME
, INVOICE_NUM INV_NAME
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, SOURCE INV_SOURCE
, CANCELLED_DATE CANCELLED_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, NULL DELETION_DATE
, NULL INV_DP
, '_DF:SQLAP:AP_INVOICES:AI'
, '_DF:SQLAP:AP_GOV_DETAIL_INVOICES:AI'
, '_DF:JG:JG_AP_INVOICES:AI'
FROM AP_INVOICES_ALL AI