[Home] [Help]
View: MRP_PLAN_SCHEDULES_V
Product: | MRP - Master Scheduling/MRP |
Description: | Supply/Demand Schedule information for planner. |
Implementation/DBA Data: |
APPS.MRP_PLAN_SCHEDULES_V
|
View Text
SELECT PLANS.ORGANIZATION_ID
, COMPILE_DESIGNATOR
, CURR_SCHEDULE_TYPE
, PLANS.ORGANIZATION_ID
, CURR_SCHEDULE_DESIGNATOR
FROM MRP_PLANS PLANS
WHERE NVL(PLANS.ORGANIZATION_SELECTION
, 1) = 1 UNION ALL SELECT ORGANIZATION_ID
, COMPILE_DESIGNATOR
, INPUT_TYPE
, INPUT_ORGANIZATION_ID
, INPUT_NAME
FROM MRP_PLAN_SCHEDULES
WHERE PLAN_LEVEL = 2 UNION ALL SELECT PLANS1.ORGANIZATION_ID
, PLANS1.COMPILE_DESIGNATOR
, PLANS2.CURR_SCHEDULE_TYPE
, PLANS2.ORGANIZATION_ID
, PLANS2.CURR_SCHEDULE_DESIGNATOR
FROM MRP_PLANS PLANS1
, MRP_PLANS PLANS2
WHERE PLANS1.ORGANIZATION_ID = PLANS2.ORGANIZATION_ID
AND PLANS1.CURR_SCHEDULE_DESIGNATOR = PLANS2.COMPILE_DESIGNATOR
AND NVL(PLANS1.ORGANIZATION_SELECTION
, 1) = 1
Columns
Name |
ORGANIZATION_ID |
COMPILE_DESIGNATOR |
INPUT_DESIGNATOR_TYPE |
INPUT_ORGANIZATION_ID |
INPUT_DESIGNATOR_NAME |