View: MRP_SCHEDULE_ITEMS_V

Product:	MRP - Master Scheduling/MRP
Description:	Master schedule items view
Implementation/DBA Data:	APPS.MRP_SCHEDULE_ITEMS_V

View Text

SELECT MRSIT.ROWID ROW_ID
, MRSIT.INVENTORY_ITEM_ID
, MIF.CONCATENATED_SEGMENTS ITEM_NUMBER
, MIF.DESCRIPTION ITEM_DESCRIPTION
, MIF.PRIMARY_UOM_CODE
, NVL(MIF.DEMAND_TIME_FENCE_DAYS
, 0) DEMAND_TIME_FENCE_DAYS
, NVL(MIF.PLANNING_TIME_FENCE_DAYS
, 0) PLANNING_TIME_FENCE_DAYS
, TO_DATE(DECODE(MRSDE.SCHEDULE_TYPE
, 2
, NULL
, 1
, DECODE(MIF.DEMAND_TIME_FENCE_CODE
, 1
, DECODE(MIF.CUMULATIVE_TOTAL_LEAD_TIME
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, 2
, DECODE(MIF.CUM_MANUFACTURING_LEAD_TIME
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, 3
, DECODE(MIF.FULL_LEAD_TIME
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, 4
, DECODE(MIF.DEMAND_TIME_FENCE_DAYS
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, NULL))) DEMAND_TIME_FENCE_DATE
, TO_DATE(DECODE(MRSDE.SCHEDULE_TYPE
, 1
, NULL
, 2
, DECODE(MIF.PLANNING_TIME_FENCE_CODE
, 1
, DECODE(MIF.CUMULATIVE_TOTAL_LEAD_TIME
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, 2
, DECODE(MIF.CUM_MANUFACTURING_LEAD_TIME
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, 3
, DECODE(MIF.FULL_LEAD_TIME
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, 4
, DECODE(MIF.PLANNING_TIME_FENCE_DAYS
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, NULL))) PLANNING_TIME_FENCE_DATE
, NVL(MIF.REPETITIVE_PLANNING_FLAG
, 'N') REPETITIVE_PLANNING_FLAG
, MRSIT.ORGANIZATION_ID
, MRSIT.SCHEDULE_DESIGNATOR
, MRSDE.SCHEDULE_TYPE
, MRSIT.LAST_UPDATE_DATE
, MRSIT.LAST_UPDATED_BY
, MRSIT.CREATION_DATE
, MRSIT.CREATED_BY
, MRSIT.LAST_UPDATE_LOGIN
, MRSIT.MPS_EXPLOSION_LEVEL
, MRSIT.CAPACITY_MODEL_ID
, MIF.BOM_ITEM_TYPE
, L1.MEANING BOM_ITEM_TYPE_TEXT
, MIF.MRP_PLANNING_CODE
, L2.MEANING MRP_PLANNING_CODE_TEXT
, NVL(RSI.IN_SOURCE_PLAN
, 2) IN_SOURCE_PLAN
, MRSIT.PROGRAM_APPLICATION_ID
, MRSIT.PROGRAM_ID
, MRSIT.PROGRAM_UPDATE_DATE
, MRSIT.REQUEST_ID
, MRSIT.ATTRIBUTE_CATEGORY
, MRSIT.ATTRIBUTE1
, MRSIT.ATTRIBUTE2
, MRSIT.ATTRIBUTE3
, MRSIT.ATTRIBUTE4
, MRSIT.ATTRIBUTE5
, MRSIT.ATTRIBUTE6
, MRSIT.ATTRIBUTE7
, MRSIT.ATTRIBUTE8
, MRSIT.ATTRIBUTE9
, MRSIT.ATTRIBUTE10
, MRSIT.ATTRIBUTE11
, MRSIT.ATTRIBUTE12
, MRSIT.ATTRIBUTE13
, MRSIT.ATTRIBUTE14
, MRSIT.ATTRIBUTE15
FROM MFG_LOOKUPS L2
, MFG_LOOKUPS L1
, BOM_CALENDAR_DATES CAL1
, BOM_CALENDAR_DATES CAL2
, MRP_SYSTEM_ITEMS RSI
, MRP_ORGANIZATIONS_V MO
, MRP_SCHEDULE_DESIGNATORS MRSDE
, MTL_PARAMETERS PARAM
, MTL_SYSTEM_ITEMS_VL MIF
, MRP_SCHEDULE_ITEMS MRSIT
WHERE MIF.ORGANIZATION_ID = MRSIT.ORGANIZATION_ID
AND MIF.INVENTORY_ITEM_ID = MRSIT.INVENTORY_ITEM_ID
AND L1.LOOKUP_TYPE = 'BOM_ITEM_TYPE'
AND L1.LOOKUP_CODE = MIF.BOM_ITEM_TYPE
AND L2.LOOKUP_TYPE(+) = 'MRP_PLANNING_CODE'
AND L2.LOOKUP_CODE(+) = MIF.MRP_PLANNING_CODE
AND PARAM.ORGANIZATION_ID = MRSIT.ORGANIZATION_ID
AND CAL2.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND CAL2.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND MRSDE.SCHEDULE_DESIGNATOR = MO.COMPILE_DESIGNATOR(+)
AND MRSDE.ORGANIZATION_ID = MO.ORGANIZATION_ID(+)
AND NVL(MO.PLANNED_ORGANIZATION
, MRSDE.ORGANIZATION_ID) = MRSIT.ORGANIZATION_ID
AND MRSDE.SCHEDULE_DESIGNATOR = MRSIT.SCHEDULE_DESIGNATOR
AND MRSIT.ORGANIZATION_ID = RSI.ORGANIZATION_ID(+)
AND MRSIT.SCHEDULE_DESIGNATOR = RSI.COMPILE_DESIGNATOR(+)
AND MRSIT.INVENTORY_ITEM_ID = RSI.INVENTORY_ITEM_ID(+)
AND CAL2.SEQ_NUM = CAL1.PRIOR_SEQ_NUM + ROUND( DECODE(MRSDE.SCHEDULE_TYPE
, 1
, DECODE(MIF.DEMAND_TIME_FENCE_CODE
, 1
, NVL(MIF.CUMULATIVE_TOTAL_LEAD_TIME
, 0)
, 2
, NVL(MIF.CUM_MANUFACTURING_LEAD_TIME
, 0)
, 3
, NVL(MIF.FULL_LEAD_TIME
, 0)
, 4
, NVL(MIF.DEMAND_TIME_FENCE_DAYS
, 0)
, 0)
, 2
, DECODE(MIF.PLANNING_TIME_FENCE_CODE
, 1
, NVL(MIF.CUMULATIVE_TOTAL_LEAD_TIME
, 0)
, 2
, NVL(MIF.CUM_MANUFACTURING_LEAD_TIME
, 0)
, 3
, NVL(MIF.FULL_LEAD_TIME
, 0)
, 4
, NVL(MIF.PLANNING_TIME_FENCE_DAYS
, 0)
, 0)))
AND CAL1.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND CAL1.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND CAL1.CALENDAR_DATE = TRUNC(SYSDATE)

Columns