VIEW: APPS.PA_ADW_EXP_TYPES_B_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'