DBA Data[Home] [Help]

VIEW: APPS.PA_ADW_PRJ_CLASSES_B_V

Source

View Text - Preformatted

SELECT PPC.PROJECT_ID , PPC.CLASS_CATEGORY , PPC.CLASS_CODE , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , PPC.ADW_NOTIFY_FLAG FROM PA_PROJECT_CLASSES PPC, PA_ADW_PROJECTS_B_V PP WHERE PPC.PROJECT_ID = PP.PROJECT_ID
View Text - HTML Formatted

SELECT PPC.PROJECT_ID
, PPC.CLASS_CATEGORY
, PPC.CLASS_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PPC.ADW_NOTIFY_FLAG
FROM PA_PROJECT_CLASSES PPC
, PA_ADW_PROJECTS_B_V PP
WHERE PPC.PROJECT_ID = PP.PROJECT_ID