DBA Data[Home] [Help]

VIEW: APPS.PJM_TASK_RULES_ORG_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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