[Home] [Help]
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
Name |
INV_SOURCE_PK |
ALL_FK |
INSTANCE |
NAME |
INV_SOURCE |
LAST_UPDATE_DATE |
CREATION_DATE |
DELETION_DATE |
INV_SOURCE_DP |
"_DF:FND:_EDW" |
"_DF:INV:_EDW" |
"_DF:GOV:_EDW" |
"_DF:JGI:_EDW" |