[Home] [Help]
View: PJM_TASK_RULES_ORG_V
View Text
SELECT DISTINCT PDT.PROJECT_ID
, PDT.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HR.NAME
FROM PJM_DEFAULT_TASKS PDT
, MTL_PARAMETERS MP
, HR_ORGANIZATION_UNITS HR
WHERE PDT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND PDT.ORGANIZATION_ID = HR.ORGANIZATION_ID
Columns
Name |
PROJECT_ID |
ORGANIZATION_ID |
ORGANIZATION_CODE |
ORGANIZATION_NAME |