View: MRPFV_MPS_ITEMS

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

View Text

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, SCIT.SCHEDULE_DESIGNATOR
, '_KF:INV:MSTK:SY'
, SY.DESCRIPTION
, SY.PRIMARY_UOM_CODE
, TO_DATE(DECODE(SC.SCHEDULE_TYPE
, 1
, NULL
, 2
, DECODE(SY.PLANNING_TIME_FENCE_CODE
, 1
, DECODE(SY.CUMULATIVE_TOTAL_LEAD_TIME
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, 2
, DECODE(SY.CUM_MANUFACTURING_LEAD_TIME
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, 3
, DECODE(SY.FULL_LEAD_TIME
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, 4
, DECODE(SY.PLANNING_TIME_FENCE_DAYS
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE ))))
, '_LA:SY.BOM_ITEM_TYPE:MFG_LOOKUPS:BOM_ITEM_TYPE:MEANING'
, '_LA:SY.MRP_PLANNING_CODE:MFG_LOOKUPS:MRP_PLANNING_CODE:MEANING'
, '_LA:SY.REPETITIVE_PLANNING_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:MRP:MRP_SCHEDULE_ITEMS:SCIT'
, 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 = 2
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.PLANNING_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