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