View: MRP_AP_SYS_ITEMS_V

View Text

SELECT /*+ ORDERED */ MSIK.ORGANIZATION_ID
, MSIK.INVENTORY_ITEM_ID
, MSIK.ITEM_NAME
, MSIK.LOTS_EXPIRATION
, MSIK.LOT_CONTROL_CODE
, MSIK.SHRINKAGE_RATE
, MSIK.FIXED_DAYS_SUPPLY
, MSIK.FIXED_ORDER_QUANTITY
, MSIK.FIXED_LOT_MULTIPLIER
, MSIK.MINIMUM_ORDER_QUANTITY
, MSIK.MAXIMUM_ORDER_QUANTITY
, MSIK.ROUNDING_CONTROL_TYPE
, MSIK.PLANNING_TIME_FENCE_CODE
, MSIK.PLANNING_TIME_FENCE_DAYS
, MSIK.DEMAND_TIME_FENCE_DAYS
, MSIK.DESCRIPTION
, DIC.CATEGORY_ID
, DIC.CATEGORY_NAME
, MSIK.MRP_PLANNING_CODE
, MSIK.FIXED_LEAD_TIME
, MSIK.VARIABLE_LEAD_TIME
, MSIK.PREPROCESSING_LEAD_TIME
, MSIK.POSTPROCESSING_LEAD_TIME
, MSIK.FULL_LEAD_TIME
, MSIK.CUMULATIVE_TOTAL_LEAD_TIME
, MSIK.CUM_MANUFACTURING_LEAD_TIME
, MSIK.UOM_CODE
, MSIK.BUILT_IN_WIP_FLAG
, MSIK.PURCHASING_ENABLED_FLAG
, MSIK.PLANNING_MAKE_BUY_CODE
, MSIK.CARRYING_COST
, MSIK.MRP_CALCULATE_ATP_FLAG
, MSIK.END_ASSEMBLY_PEGGING_FLAG
, MSIK.ENG_ITEM_FLAG
, MSIK.WIP_SUPPLY_TYPE
, MSIK.MRP_SAFETY_STOCK_CODE
, MSIK.MRP_SAFETY_STOCK_PERCENT
, MSIK.SAFETY_STOCK_BUCKET_DAYS
, MSIK.ACCEPTABLE_EARLY_DELIVERY
, MSIK.BUYER_ID
, MSIK.PLANNER_CODE
, MSIK.PLANNING_EXCEPTION_SET
, MSIK.BASE_ITEM_ID
, MSIK.BOM_ITEM_TYPE
, MSIK.ATO_FORECAST_CONTROL
, MSIK.EFFECTIVITY_CONTROL
, MSIK.INVENTORY_PLANNING_CODE
, MSIK.UNIT_WEIGHT
, MSIK.UNIT_VOLUME
, MSIK.WEIGHT_UOM
, MSIK.VOLUME_UOM
, MSIK.PRODUCT_FAMILY_ID
, MSIK.RELEASE_TIME_FENCE_CODE
, MSIK.RELEASE_TIME_FENCE_DAYS
, MSIK.ATP_RULE_ID
, MSIK.ORDER_COST
, MSIK.ATP_COMPONENTS_FLAG
, MSIK.REPETITIVE_TYPE
, MSIK.LIST_PRICE
, MP.ORGANIZATION_CODE
, 1 INVENTORY_TYPE
, MRPP.DEFAULT_ABC_ASSIGNMENT_GROUP
, MP.COST_ORGANIZATION_ID
, MP.PRIMARY_COST_METHOD
, DECODE( DECODE( HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, HAOU.ORGANIZATION_ID))
, 'TRUE'
, HAOU.BUSINESS_GROUP_ID
, NULL) BUSINESS_GROUP_ID
, NVL(DIC.RN
, 0) RN4
, NVL(HAOU.RN
, 0) RN3
, MRPP.RN RN2
, MSIK.RN RN1
FROM MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_MRP_PARAS_SN MRPP
, MRP_AP_MTL_PARAS_SN MP
, MTL_SYSTEM_ITEMS MSI
, MRP_AP_ORG_UNITS_SN HAOU
, MRP_AP_DEFAULT_ITEM_CATEGORY_V DIC
WHERE MSI.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MP.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MRPP.ORGANIZATION_ID= MSIK.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID= MSIK.ORGANIZATION_ID
AND DIC.INVENTORY_ITEM_ID(+)= MSIK.INVENTORY_ITEM_ID
AND DIC.ORGANIZATION_ID(+)= MSIK.ORGANIZATION_ID

Columns