順展BOM實用SQL
依網上貼略有整理.[@more@]SELECT distinct bb.BOMcc, bb.zhpeijian, bb.zhpeijiandesc, bb.SUB_SEQUENCE, bb.SUB_ITEM, bb.SUB_ITEMDESC, bb.component_quantity, bb.UOM, bb.LYL_RATE, bb.SUBINV, bb.LOCATION, bb.ITEM_TYPE, bb.BOMtimes, BOR.COMPLETION_SUBINVENTORY ,--入庫, MSI.WIP_SUPPLY_SUBINVENTORY,-- 沖減, MSI.MAXIMUM_ORDER_QUANTITY ,-- 最大批量, MSI.LEAD_TIME_LOT_SIZE ,-- 提前期, MSI.FULL_LEAD