View: MRP_SCHEDULE_DESIGNATORS_V

Product:	MRP - Master Scheduling/MRP
Description:	Master schedules view
Implementation/DBA Data:	APPS.MRP_SCHEDULE_DESIGNATORS_V

View Text

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(+)

Columns