View: MRP_I2_PART_MASTER_V

View Text

SELECT I.ITEM_NUMBER
, I.INVENTORY_ITEM_ID
, I.DESCRIPTION
, I.ORGANIZATION_ID
, I.PLANNING_MAKE_BUY_CODE
, LU.MEANING
, DECODE(I.PLANNING_TIME_FENCE_DAYS
, 0
, MRP_I2_ERP.GET_PARAMETER( 'DEFAULT_PLANNING_TF_OFFSET'
, I.ORGANIZATION_ID) + NVL(I.POSTPROCESSING_LEAD_TIME
, 0) + NVL(I.FULL_LEAD_TIME
, 0)
, I.PLANNING_TIME_FENCE_DAYS)
, DECODE(MRP_I2_ERP.GET_PARAMETER('CONSIDER_DEMAND_TF'
, I.ORGANIZATION_ID)
, 'Y'
, I.DEMAND_TIME_FENCE_DAYS
, 0)
, I.RELEASE_TIME_FENCE_CODE
, NVL(I.RELEASE_TIME_FENCE_DAYS
, 0)
, NVL(I.PREPROCESSING_LEAD_TIME
, 0) + NVL(I.FULL_LEAD_TIME
, 0)
, NVL(I.POSTPROCESSING_LEAD_TIME
, 0)
, NVL(I.MINIMUM_ORDER_QUANTITY
, NVL(I.FIXED_LOT_MULTIPLIER
, 0))
, NVL(I.MAXIMUM_ORDER_QUANTITY
, 999999999)
, DECODE(I.ROUNDING_CONTROL_TYPE
, 1
, CEIL(NVL(I.FIXED_LOT_MULTIPLIER
, 1))
, NVL(I.FIXED_LOT_MULTIPLIER
, 0.00001))
, NVL(I.FIXED_DAYS_SUPPLY
, 1)
, I.PLANNER_CODE
, I.PRIMARY_UOM_CODE
, I.CUSTOMER_ORDER_FLAG
, SUBSTR( I.CATEGORY_NAME
, 1
, 240)
, I.BUYER_ID
, NVL(I.REPLENISH_TO_ORDER_FLAG
, 'N')
, DECODE(I.WIP_SUPPLY_TYPE
, 6
, 'Y'
, 'N')
, DECODE(TO_NUMBER(MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_BUF_STYLE_ATTR_NUM'
, I.ORGANIZATION_ID))
, 1
, I.ITEM_ATTRIBUTE1
, 2
, I.ITEM_ATTRIBUTE2
, 3
, I.ITEM_ATTRIBUTE3
, 4
, I.ITEM_ATTRIBUTE4
, 5
, I.ITEM_ATTRIBUTE5
, 6
, I.ITEM_ATTRIBUTE6
, 7
, I.ITEM_ATTRIBUTE7
, 8
, I.ITEM_ATTRIBUTE8
, 9
, I.ITEM_ATTRIBUTE9
, 10
, I.ITEM_ATTRIBUTE10
, 11
, I.ITEM_ATTRIBUTE11
, 12
, I.ITEM_ATTRIBUTE12
, 13
, I.ITEM_ATTRIBUTE13
, 14
, I.ITEM_ATTRIBUTE14
, 15
, I.ITEM_ATTRIBUTE15)
FROM MFG_LOOKUPS LU
, MRP_RHX_PLANNED_ITEMS_V I
WHERE LU.LOOKUP_TYPE='MTL_PLANNING_MAKE_BUY'
AND LU.LOOKUP_CODE=I.PLANNING_MAKE_BUY_CODE
AND I.MRP_PLANNING_CODE IN (3
, 4
, 7
, 8)

Columns