View: FIIBV_AP_IVSR_INV_SOURCE_LCV

Product:	FII - Financial Intelligence
Description:	FIIBV_AP_IVSR_INV_SOURCE_LCV is the base view for Invoice Source level of Invoice Source dimension
Implementation/DBA Data:	APPS.FIIBV_AP_IVSR_INV_SOURCE_LCV

View Text

SELECT L.LOOKUP_CODE INV_SOURCE_PK
, 'ALL' ALL_FK
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, L.DISPLAYED_FIELD NAME
, L.DISPLAYED_FIELD INV_SOURCE
, NVL(L.START_DATE_ACTIVE
, TRUNC(SYSDATE)-1) LAST_UPDATE_DATE
, NVL(L.START_DATE_ACTIVE
, TRUNC(SYSDATE)-1) CREATION_DATE
, NULL DELETION_DATE
, NULL INV_SOURCE_DP
, '_DF:_DUMMY:FND:FND_COMMON_LOOKUPS:FND'
, '_DF:_DUMMY:SQLAP:AP_INVOICES:AI'
, '_DF:_DUMMY:SQLAP:AP_GOV_DETAIL_INVOICES:AI'
, '_DF:_DUMMY:JG:JG_AP_INVOICES:AI'
FROM AP_LOOKUP_CODES L
WHERE L.LOOKUP_TYPE = 'SOURCE' UNION SELECT DISTINCT AI.SOURCE INV_SOURCE_PK
, 'ALL' ALL_FK
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, AI.SOURCE NAME
, AI.SOURCE INV_SOURCE
, TRUNC(SYSDATE)-1 LAST_UPDATE_DATE
, TRUNC(SYSDATE)-1 CREATION_DATE
, NULL DELETION_DATE
, NULL INV_SOURCE_DP
, '_DF:_DUMMY:FND:FND_COMMON_LOOKUPS:FND'
, '_DF:SQLAP:AP_INVOICES:AI'
, '_DF:SQLAP:AP_GOV_DETAIL_INVOICES:AI'
, '_DF:JG:JG_AP_INVOICES:AI'
FROM AP_INVOICES_ALL AI
WHERE AI.SOURCE NOT IN (SELECT L.LOOKUP_CODE
FROM AP_LOOKUP_CODES L
WHERE L.LOOKUP_TYPE = 'SOURCE')

Columns