VIEW: APPS.EDW_PA_EXP_TYPE_MPV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'