View: MRPBV_MDS_ITEMS

Product:	MRP - Master Scheduling/MRP
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MRPBV_MDS_ITEMS

View Text

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, SCIT.SCHEDULE_DESIGNATOR
, '_KF:INV:MSTK:SY'
, SCIT.ORGANIZATION_ID
, SCIT.INVENTORY_ITEM_ID
, SCIT.LAST_UPDATE_DATE
, SCIT.LAST_UPDATED_BY
, SCIT.CREATION_DATE
, SCIT.CREATED_BY
FROM BOM_CALENDAR_DATES CAL1
, BOM_CALENDAR_DATES CAL2
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, MRP_SCHEDULE_DESIGNATORS SC
, MRP_SCHEDULE_ITEMS SCIT
WHERE SCIT.ORGANIZATION_ID = SC.ORGANIZATION_ID
AND SCIT.SCHEDULE_DESIGNATOR = SC.SCHEDULE_DESIGNATOR
AND SC.SCHEDULE_TYPE = 1
AND SCIT.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND SCIT.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND SCIT.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SCIT.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND CAL2.EXCEPTION_SET_ID = PA.CALENDAR_EXCEPTION_SET_ID
AND CAL2.CALENDAR_CODE = PA.CALENDAR_CODE
AND CAL1.EXCEPTION_SET_ID = PA.CALENDAR_EXCEPTION_SET_ID
AND CAL1.CALENDAR_CODE = PA.CALENDAR_CODE
AND CAL1.CALENDAR_DATE = TRUNC(SYSDATE)
AND CAL2.SEQ_NUM = CAL1.PRIOR_SEQ_NUM + DECODE(SY.DEMAND_TIME_FENCE_CODE
, 1
, NVL(SY.CUMULATIVE_TOTAL_LEAD_TIME
, 0)
, 2
, NVL(SY.CUM_MANUFACTURING_LEAD_TIME
, 0)
, 3
, NVL(SY.FULL_LEAD_TIME
, 0)
, 4
, NVL(SY.PLANNING_TIME_FENCE_DAYS
, 0))
AND '_SEC:SCIT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns