View: PA_ADW_EXP_TYPES_B_V

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PA_ADW_EXP_TYPES_B_V

View Text

SELECT PET.EXPENDITURE_TYPE
, PL.MEANING
, PET.EXPENDITURE_CATEGORY
, PET.REVENUE_CATEGORY_CODE
, PET.UNIT_OF_MEASURE
, PET.DESCRIPTION
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PET.ADW_NOTIFY_FLAG
FROM PA_EXPENDITURE_TYPES PET
, PA_LOOKUPS PL
WHERE PL.LOOKUP_TYPE = 'ADW DIM LEVEL NAME'
AND PL.LOOKUP_CODE = 'ALL_EXP_TYPES' UNION SELECT PLU.MEANING
, PL.MEANING
, PLU.MEANING
, PLU.MEANING
, PLU.MEANING
, PLU.MEANING
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'Y'
FROM PA_LOOKUPS PL
, PA_LOOKUPS PLU
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