[Home] [Help]
VIEW: APPS.PJM_TASK_RULES_PROJECTS_V
Source
View Text - Preformatted
SELECT DISTINCT PDT.PROJECT_ID , PPA.SEGMENT1 , PPA.NAME FROM PJM_DEFAULT_TASKS PDT , PA_PROJECTS_ALL PPA WHERE PPA.PROJECT_ID = PDT.PROJECT_ID
View Text - HTML Formatted
SELECT DISTINCT PDT.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
FROM PJM_DEFAULT_TASKS PDT
, PA_PROJECTS_ALL PPA
WHERE PPA.PROJECT_ID = PDT.PROJECT_ID