VIEW: APPS.PA_ADW_SRVC_TYPES_B_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'