[Home] [Help]
View: MRP_ORGANIZATIONS_V
Product: | MRP - Master Scheduling/MRP |
Description: | MPS/MRP plans for an organization |
Implementation/DBA Data: |
APPS.MRP_ORGANIZATIONS_V
|
View Text
SELECT PLANS.ORGANIZATION_ID
, PLANS.COMPILE_DESIGNATOR
, NVL(MPO.PLANNED_ORGANIZATION
, PLANS.ORGANIZATION_ID)
, PLANS.CURR_CUTOFF_DATE
, PLANS.PLAN_COMPLETION_DATE
FROM MRP_PLAN_ORGANIZATIONS MPO
, MRP_PLANS PLANS
WHERE MPO.ORGANIZATION_ID (+) = PLANS.ORGANIZATION_ID
AND MPO.COMPILE_DESIGNATOR(+) = PLANS.COMPILE_DESIGNATOR
AND MPO.PLAN_LEVEL (+) = 2 UNION SELECT PLANS.ORGANIZATION_ID
, PLANS.COMPILE_DESIGNATOR
, PLANS.ORGANIZATION_ID
, PLANS.CURR_CUTOFF_DATE
, PLANS.PLAN_COMPLETION_DATE
FROM MRP_PLANS PLANS
Columns
Name |
ORGANIZATION_ID |
COMPILE_DESIGNATOR |
PLANNED_ORGANIZATION |
CUTOFF_DATE |
PLAN_COMPLETION_DATE |