Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | An Integration Toolkit view supporting information regarding all planned items. |
Implementation/DBA Data: | Not implemented in this database |
SELECT MIF.CONCATENATED_SEGMENTS
, MIF.INVENTORY_ITEM_ID
, MIF.DESCRIPTION
, MIF.ORGANIZATION_ID
, MRP_RHX_UTILITIES.GET_CAT_ID(MIF.INVENTORY_ITEM_ID
, MIF.ORGANIZATION_ID)
, MRP_RHX_UTILITIES.GET_CAT_NAME(MIF.INVENTORY_ITEM_ID
, MIF.ORGANIZATION_ID)
, MIF.PLANNING_MAKE_BUY_CODE
, MIF.WIP_SUPPLY_TYPE
, MIF.BOM_ITEM_TYPE
, MIF.BASE_ITEM_ID
, MIF.ATO_FORECAST_CONTROL
, MIF.SHRINKAGE_RATE
, NVL(DECODE(MIF.WIP_SUPPLY_TYPE
, 6
, 0
, DECODE(MIF.PLANNING_TIME_FENCE_CODE
, 4
, MIF.PLANNING_TIME_FENCE_DAYS
, 1
, MIF.CUMULATIVE_TOTAL_LEAD_TIME
, 2
, MIF.CUM_MANUFACTURING_LEAD_TIME
, 3
, MIF.FULL_LEAD_TIME))
, 0)
, NVL(DECODE(MIF.WIP_SUPPLY_TYPE
, 6
, 0
, DECODE(MIF.DEMAND_TIME_FENCE_CODE
, 4
, MIF.DEMAND_TIME_FENCE_DAYS
, 1
, MIF.CUMULATIVE_TOTAL_LEAD_TIME
, 2
, MIF.CUM_MANUFACTURING_LEAD_TIME
, 3
, MIF.FULL_LEAD_TIME))
, 0)
, MIF.MRP_PLANNING_CODE
, MIF.INVENTORY_PLANNING_CODE
, MIF.ACCEPTABLE_EARLY_DAYS
, MIF.MRP_SAFETY_STOCK_CODE
, MIF.MRP_SAFETY_STOCK_PERCENT
, MIF.SAFETY_STOCK_BUCKET_DAYS
, MIF.LOT_CONTROL_CODE
, MIF.RELEASE_TIME_FENCE_CODE
, MIF.RELEASE_TIME_FENCE_DAYS
, MIF.PREPROCESSING_LEAD_TIME
, MIF.POSTPROCESSING_LEAD_TIME
, MIF.FULL_LEAD_TIME
, MIF.CUMULATIVE_TOTAL_LEAD_TIME
, MIF.CUM_MANUFACTURING_LEAD_TIME
, MIF.FIXED_LEAD_TIME
, MIF.VARIABLE_LEAD_TIME
, MIF.FIXED_ORDER_QUANTITY
, MIF.MINIMUM_ORDER_QUANTITY
, MIF.MAXIMUM_ORDER_QUANTITY
, MIF.FIXED_DAYS_SUPPLY
, MIF.FIXED_LOT_MULTIPLIER
, MIF.ROUNDING_CONTROL_TYPE
, MIF.PLANNER_CODE
, MIF.BUYER_ID
, MIF.CUSTOMER_ORDER_FLAG
, MIF.PURCHASING_ENABLED_FLAG
, MIF.BUILD_IN_WIP_FLAG
, MIF.PRIMARY_UOM_CODE
, MIF.REPLENISH_TO_ORDER_FLAG
, MIF.INVENTORY_ITEM_STATUS_CODE
, MIF.LEAD_TIME_LOT_SIZE
, MIF.STD_LOT_SIZE
, MIF.AUTO_LOT_ALPHA_PREFIX
, MIF.START_AUTO_LOT_NUMBER
, MIF.MTL_TRANSACTIONS_ENABLED_FLAG
, MIF.ATTRIBUTE_CATEGORY
, MIF.ATTRIBUTE1
, MIF.ATTRIBUTE2
, MIF.ATTRIBUTE3
, MIF.ATTRIBUTE4
, MIF.ATTRIBUTE5
, MIF.ATTRIBUTE6
, MIF.ATTRIBUTE7
, MIF.ATTRIBUTE8
, MIF.ATTRIBUTE9
, MIF.ATTRIBUTE10
, MIF.ATTRIBUTE11
, MIF.ATTRIBUTE12
, MIF.ATTRIBUTE13
, MIF.ATTRIBUTE14
, MIF.ATTRIBUTE15
FROM MTL_SYSTEM_ITEMS_KFV MIF
WHERE MIF.REPETITIVE_PLANNING_FLAG = 'N'
AND MIF.MRP_PLANNING_CODE IS NOT NULL
AND (MIF.INVENTORY_ITEM_FLAG = 'Y' OR MIF.ENG_ITEM_FLAG = 'Y')
AND MIF.BOM_ITEM_TYPE <> 3
AND MIF.PLANNING_MAKE_BUY_CODE IN (1
, 2)
AND MIF.MRP_PLANNING_CODE <> 6
AND MIF.PRIMARY_UOM_CODE IS NOT NULL