本文共 1993 字，大约阅读时间需要 6 分钟。
????????????????????????
???????????????????????????????????????????????????????????????????????????????
??????????????????
inv.mtl_system_items_b ? msi1 ? msi2apps.BOM_BILL_OF_MATERIALS ? bombomapps.BOM_INVENTORY_COMPONENTS ? bic?????????
????????????
SELECT distinct b.lvl, b.OPERATION_SEQ_NUM, msi1.segment1, msi1.description, msi1.item_type, msi1.inventory_item_status_code, msi2.segment1, msi2.description, msi2.item_type, b.component_quantity, b.COMPONENT_YIELD_FACTOR, b.COMPONENT_SEQUENCE_ID, b.item_num, b.wip_supply_type, b.supply_subinventory, b.effectivity_dateFROM inv.mtl_system_items_b msi1, inv.mtl_system_items_b msi2, apps.BOM_BILL_OF_MATERIALS bom, apps.BOM_INVENTORY_COMPONENTS bicWHERE bom.ORGANIZATION_ID IN (1, 157) AND bom.ASSEMBLY_ITEM_ID = msi1.INVENTORY_ITEM_ID AND msi1.ORGANIZATION_ID = bom.ORGANIZATION_ID AND msi2.ORGANIZATION_ID = bom.ORGANIZATION_ID AND b.component_item_id = msi2.INVENTORY_ITEM_ID AND msi2.inventory_item_status_code > 'Inactive' AND disable_date IS NULL AND bic.IMPLEMENTATION_DATE IS NOT NULL AND bom.alternate_bom_designator IS NULLCONNECT BY bill_sequence_id IN ( SELECT distinct nvl(common_bill_sequence_id, bill_sequence_id) FROM apps.BOM_BILL_OF_MATERIALS bom2, inv.mtl_system_items_b msi WHERE bom2.assembly_item_id = msi.INVENTORY_ITEM_ID AND bom2.ORGANIZATION_ID = msi.ORGANIZATION_ID AND msi.ORGANIZATION_ID IN (1, 157) AND bom2.alternate_bom_designator IS NULL )ORDER BY b.lvl
distinct??????????????CONNECT BY??????????????????NULL?IS NOT NULL?????????????????????????????????????????????????????????????????????30%?
???????????????????????????????????????????????????????????????????????????????
转载地址：http://eppfk.baihongyu.com/