eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PJM_PROJECT_MFG_PLAN_V

Source

View Text - Preformatted


SELECT DISTINCT SD.PROJECT_ID , SD.TASK_ID , MD.COMPILE_DESIGNATOR , MD.DESCRIPTION , MP.CURR_PLAN_TYPE , L.MEANING , SD.ORGANIZATION_ID , ORG.NAME , MP.PLAN_START_DATE , MP.PLAN_COMPLETION_DATE , MP.CURR_CUTOFF_DATE FROM MRP_DESIGNATORS MD , MRP_PLANS MP , HR_ALL_ORGANIZATION_UNITS_TL ORG , MFG_LOOKUPS L , ( SELECT ORGANIZATION_ID , COMPILE_DESIGNATOR , PLANNED_ORGANIZATION FROM MRP_PLAN_ORGANIZATIONS WHERE PLAN_LEVEL = 2 UNION ALL SELECT ORGANIZATION_ID , COMPILE_DESIGNATOR , ORGANIZATION_ID FROM MRP_PLANS ) PORG , ( SELECT PROJECT_ID , TASK_ID , ORGANIZATION_ID , COMPILE_DESIGNATOR FROM MRP_GROSS_REQUIREMENTS UNION ALL SELECT PROJECT_ID , TASK_ID , ORGANIZATION_ID , COMPILE_DESIGNATOR FROM MRP_RECOMMENDATIONS ) SD WHERE ORG.ORGANIZATION_ID = SD.ORGANIZATION_ID AND ORG.LANGUAGE = USERENV('LANG') AND PORG.PLANNED_ORGANIZATION = SD.ORGANIZATION_ID AND PORG.COMPILE_DESIGNATOR = SD.COMPILE_DESIGNATOR AND MP.ORGANIZATION_ID = PORG.ORGANIZATION_ID AND MP.COMPILE_DESIGNATOR = PORG.COMPILE_DESIGNATOR AND MD.COMPILE_DESIGNATOR = MP.COMPILE_DESIGNATOR AND MD.ORGANIZATION_ID = MP.ORGANIZATION_ID AND L.LOOKUP_TYPE (+) = 'MRP_PLAN_TYPE' AND L.LOOKUP_CODE (+) = MP.CURR_PLAN_TYPE

View Text - HTML Formatted

SELECT DISTINCT SD.PROJECT_ID
, SD.TASK_ID
, MD.COMPILE_DESIGNATOR
, MD.DESCRIPTION
, MP.CURR_PLAN_TYPE
, L.MEANING
, SD.ORGANIZATION_ID
, ORG.NAME
, MP.PLAN_START_DATE
, MP.PLAN_COMPLETION_DATE
, MP.CURR_CUTOFF_DATE
FROM MRP_DESIGNATORS MD
, MRP_PLANS MP
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, MFG_LOOKUPS L
, ( SELECT ORGANIZATION_ID
, COMPILE_DESIGNATOR
, PLANNED_ORGANIZATION
FROM MRP_PLAN_ORGANIZATIONS
WHERE PLAN_LEVEL = 2 UNION ALL SELECT ORGANIZATION_ID
, COMPILE_DESIGNATOR
, ORGANIZATION_ID
FROM MRP_PLANS ) PORG
, ( SELECT PROJECT_ID
, TASK_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
FROM MRP_GROSS_REQUIREMENTS UNION ALL SELECT PROJECT_ID
, TASK_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
FROM MRP_RECOMMENDATIONS ) SD
WHERE ORG.ORGANIZATION_ID = SD.ORGANIZATION_ID
AND ORG.LANGUAGE = USERENV('LANG')
AND PORG.PLANNED_ORGANIZATION = SD.ORGANIZATION_ID
AND PORG.COMPILE_DESIGNATOR = SD.COMPILE_DESIGNATOR
AND MP.ORGANIZATION_ID = PORG.ORGANIZATION_ID
AND MP.COMPILE_DESIGNATOR = PORG.COMPILE_DESIGNATOR
AND MD.COMPILE_DESIGNATOR = MP.COMPILE_DESIGNATOR
AND MD.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND L.LOOKUP_TYPE (+) = 'MRP_PLAN_TYPE'
AND L.LOOKUP_CODE (+) = MP.CURR_PLAN_TYPE