VIEW: APPS.PA_PROJECT_DRIVERS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'