[Home] [Help]
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
Name |
PROJECT_ID |
TASK_ID |
PLAN_NAME |
PLAN_DESCRIPTION |
PLAN_TYPE_CODE |
PLAN_TYPE |
ORGANIZATION_ID |
ORGANIZATION_NAME |
START_DATE |
COMPLETION_DATE |
PLAN_HORIZON |