[Home] [Help]
| Product: | MRP - Master Scheduling/MRP |
|---|---|
| Description: | An Integration Toolkit view supporting information regarding the safety stock of planned items. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ITEMS.INVENTORY_ITEM_ID
, ITEMS.ORGANIZATION_ID
, ITEMS.ITEM_NUMBER
, SAFETY.EFFECTIVITY_DATE
, DECODE(NVL(ITEMS.ROUNDING_CONTROL_TYPE
, 2)
, 1
, CEIL(NVL(SAFETY.SAFETY_STOCK_QUANTITY
, 0))
, NVL(SAFETY.SAFETY_STOCK_QUANTITY
, 0))
, ITEMS.PREPROCESSING_LEAD_TIME
, ITEMS.POSTPROCESSING_LEAD_TIME
, ITEMS.FULL_LEAD_TIME
, ITEMS.CUMULATIVE_TOTAL_LEAD_TIME
, ITEMS.CUM_MANUFACTURING_LEAD_TIME
, ITEMS.FIXED_LEAD_TIME
, ITEMS.VARIABLE_LEAD_TIME
FROM MTL_SAFETY_STOCKS SAFETY
, MRP_RHX_PLANNED_ITEMS_V ITEMS
WHERE TRUNC(SAFETY.EFFECTIVITY_DATE) >= (SELECT NVL(TRUNC(MAX(EFFECTIVITY_DATE))
, (TRUNC(SYSDATE)-MRP_RHX_EXT_APS.GET_CONSTANT))
FROM MTL_SAFETY_STOCKS
WHERE ORGANIZATION_ID = ITEMS.ORGANIZATION_ID
AND EFFECTIVITY_DATE <= (TRUNC(SYSDATE) - MRP_RHX_EXT_APS.GET_CONSTANT)
AND INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID)
AND SAFETY.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID
AND SAFETY.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND ITEMS.MRP_SAFETY_STOCK_CODE = 1