View: EDW_PA_EXP_TYPE_MPV

Product:	FII - Financial Intelligence
Description:	EDW_PA_EXP_TYPE_MPV is the view for data validity on source side.
Implementation/DBA Data:	APPS.EDW_PA_EXP_TYPE_MPV

View Text

SELECT PET.EXPENDITURE_TYPE || '-' || SUBSTRB(ELI.INSTANCE_CODE
, 1
, 40)
, PET.LAST_UPDATE_DATE
FROM PA_EXPENDITURE_TYPES PET
, EDW_LOCAL_INSTANCE ELI UNION SELECT PLU.MEANING || '-' || SUBSTRB(ELI.INSTANCE_CODE
, 1
, 40)
, SYSDATE -1
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