View: PA_ADW_SRVC_TYPES_B_V

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

View Text

SELECT PL.LOOKUP_CODE
, PL.LOOKUP_CODE
, PLA.MEANING
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM PA_LOOKUPS PL
, PA_LOOKUP_TYPES PLT
, PA_LOOKUPS PLA
WHERE PLT.LOOKUP_TYPE = 'SERVICE TYPE'
AND PLT.LOOKUP_TYPE = PL.LOOKUP_TYPE
AND PLA.LOOKUP_TYPE = 'ADW DIM LEVEL NAME'
AND PLA.LOOKUP_CODE = 'ALL_SRVC_TYPES' UNION SELECT PLU.MEANING
, PLU.MEANING
, PLA.MEANING
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM PA_LOOKUPS PLA
, PA_LOOKUPS PLU
WHERE PLA.LOOKUP_TYPE = 'ADW DIM LEVEL NAME'
AND PLA.LOOKUP_CODE = 'ALL_SRVC_TYPES'
AND PLU.LOOKUP_TYPE = 'ADW RESOURCE NAME'
AND PLU.LOOKUP_CODE = 'UNKNOWN'

Columns