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