[Home] [Help]
View: PA_PROJECT_DRIVERS_V
View Text
SELECT PPA.PROJECT_ID
, PL.MEANING
, 'PROJECT_TYPE:' || PPT.PROJECT_TYPE_ID
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_TYPES_ALL PPT
, PA_LOOKUPS PL
WHERE PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PPA.ORG_ID = PPT.ORG_ID
AND PL.LOOKUP_TYPE = 'PA_EXT_DRIVER_TYPE'
AND PL.LOOKUP_CODE = 'PROJECT_TYPE' UNION ALL SELECT DISTINCT PPA.PROJECT_ID
, PL.MEANING
, 'CLASS_CATEGORY:' || PCC.CLASS_CATEGORY_ID
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_CLASSES PPC
, PA_CLASS_CATEGORIES PCC
, PA_LOOKUPS PL
WHERE PPA.PROJECT_ID = PPC.PROJECT_ID
AND PPC.CLASS_CATEGORY = PCC.CLASS_CATEGORY
AND PL.LOOKUP_TYPE = 'PA_EXT_DRIVER_TYPE'
AND PL.LOOKUP_CODE = 'CLASS_CATEGORY' UNION ALL SELECT PPA.PROJECT_ID
, PL.MEANING
, 'CLASS_CODE:' || PCC.CLASS_CODE_ID
FROM PA_PROJECTS_ALL PPA
, PA_PROJECT_CLASSES PPC
, PA_CLASS_CODES PCC
, PA_LOOKUPS PL
WHERE PPA.PROJECT_ID = PPC.PROJECT_ID
AND PPC.CLASS_CATEGORY = PCC.CLASS_CATEGORY
AND PPC.CLASS_CODE = PCC.CLASS_CODE
AND PL.LOOKUP_TYPE = 'PA_EXT_DRIVER_TYPE'
AND PL.LOOKUP_CODE = 'CLASS_CODE'
Columns
Name |
PROJECT_ID |
DRIVER_TYPE_NAME |
DRIVER_CODE |