DBA Data[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