View: PJM_PROJECT_MFG_PLAN_V

Product:	PJM - Project Manufacturing
Description:	Project related manufacturing plan information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_MFG_PLAN_V

View Text

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

Columns