Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Master schedules view |
Implementation/DBA Data: | APPS.MRP_SCHEDULE_DESIGNATORS_V |
SELECT MSD.ROWID ROW_ID
, MSD.SCHEDULE_DESIGNATOR
, NVL(MO.PLANNED_ORGANIZATION
, MSD.ORGANIZATION_ID) ORGANIZATION_ID
, MSD.ORGANIZATION_ID OWNING_ORGANIZATION_ID
, MSD.SCHEDULE_TYPE
, MSD.MPS_RELIEF
, MSD.INVENTORY_ATP_FLAG
, MSD.DESCRIPTION
, MSD.DISABLE_DATE
, MSD.DEMAND_CLASS
, MSD.USE_NEW_PLANNER
, MSD.PRODUCTION
, MSD.ORGANIZATION_SELECTION
FROM MRP_SCHEDULE_DESIGNATORS MSD
, MRP_ORGANIZATIONS_V MO
WHERE MSD.ORGANIZATION_ID = MO.ORGANIZATION_ID(+)
AND MSD.SCHEDULE_DESIGNATOR = MO.COMPILE_DESIGNATOR(+)