[Home] [Help]
View: FIIBV_PA_EXP_TYPES_V
Product: | FII - Financial Intelligence |
Description: | FIIBV_PA_EXP_TYPES_V is the Project Expenditure Type level base view for the Project Expenditure Type dimension in EDW |
Implementation/DBA Data: |
APPS.FIIBV_PA_EXP_TYPES_V
|
View Text
SELECT PET.EXPENDITURE_TYPE || '-' || SUBSTRB(ELI.INSTANCE_CODE
, 1
, 40)
, 'ALL'
, PET.CREATION_DATE
, PET.EXPENDITURE_TYPE
, SUBSTRB(ELI.INSTANCE_CODE
, 1
, 40)
, PET.EXPENDITURE_TYPE
, PET.LAST_UPDATE_DATE
, '_DF:PA:PA_EXPENDITURE_TYPES_DESC_FLEX:PET'
FROM PA_EXPENDITURE_TYPES PET
, EDW_LOCAL_INSTANCE ELI UNION SELECT PLU.MEANING || '-' || SUBSTRB(ELI.INSTANCE_CODE
, 1
, 40)
, 'ALL'
, PLU.CREATION_DATE
, PLU.MEANING
, SUBSTRB(ELI.INSTANCE_CODE
, 1
, 40)
, PLU.MEANING
, SYSDATE -1
, '_DF:_DUMMY:PA:PA_EXPENDITURE_TYPES_DESC_FLEX:PET'
FROM PA_LOOKUPS PL
, PA_LOOKUPS PLU
, EDW_LOCAL_INSTANCE ELI
WHERE PL.LOOKUP_TYPE = 'ADW DIM LEVEL NAME'
AND PL.LOOKUP_CODE = 'ALL_EXP_TYPES'
AND PLU.LOOKUP_TYPE = 'ADW RESOURCE NAME'
AND PLU.LOOKUP_CODE = 'UNKNOWN'
Columns
Name |
EXP_TYPE_PK |
ALL_FK |
CREATION_DATE |
EXP_TYPE_NAME |
INSTANCE |
NAME |
LAST_UPDATE_DATE |
"_DF:EXT:_EDW" |