Item attribute
SELECT MSI.SEGMENT1, FCL.MEANING "User Item Type",
ML.MEANING "Planning Method", MSI.MRP_PLANNING_CODE,
MSI.PLANNER_CODE PLANNER,
MSI.PREPROCESSING_LEAD_TIME "Preprocessing",
MSI.FULL_LEAD_TIME "Processing",
MSI.POSTPROCESSING_LEAD_TIME "Postprocessing",
MSI.FIXED_LEAD_TIME,
MSI.VARIABLE_LEAD_TIME,
MSI.CUM_MANUFACTURING_LEAD_TIME,
MSI.CUMULATIVE_TOTAL_LEAD_TIME
MSI.ALLOW_ITEM_DESC_UPDATE_FLAG "Allow Description update",
MSI.LIST_PRICE_PER_UNIT "List Price",
DECODE (MSI.SOURCE_TYPE,
1, 'Inventory',
2, 'Supplier'
) "Source Type", MSI.BUILD_IN_WIP_FLAG "Bulid in WIP",
MSI.INTERNAL_ORDER_ENABLED_FLAG "Internal ordered",
MSI.STD_LOT_SIZE "Standard Lot Size",
MSI.LEAD_TIME_LOT_SIZE "Lead time Lot Size"
FROM MTL_SYSTEM_ITEMS_B MSI, FND_COMMON_LOOKUPS FCL, MFG_LOOKUPS ML
WHERE MSI.ORGANIZATION_ID = 12
AND MSI.INVENTORY_ITEM_STATUS_CODE NOT LIKE 'Inactive'
AND MSI.ITEM_TYPE IN
('P', 'IR') -- IN('AI','FG','P','IR','OP','SA','CI','')
AND FCL.LOOKUP_TYPE = 'ITEM_TYPE'
AND FCL.LOOKUP_CODE = MSI.ITEM_TYPE
AND ML.LOOKUP_TYPE = 'MRP_PLANNING_CODE'
AND ML.LOOKUP_CODE = MSI.MRP_PLANNING_CODE
AND MSI.PLANNER_CODE IS NULL
ORDER BY FCL.MEANING
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/41594/viewspace-50524/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/41594/viewspace-50524/