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
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
|
|
|