BOM

select distinct msic.segment1,
msic.description,
msib.segment1,
msib.description ,
bic.COMPONENT_QUANTITY
from
bom_bill_of_materials  bom,
bom_inventory_components bic,
mtl_system_items msic,
mtl_system_items msib
   where  bom.common_bill_sequence_id=bic.bill_sequence_id
               and  bom.assembly_item_id=msic.inventory_item_id
               and  bic.component_item_id=msib.inventory_item_id
        and BOM.ASSEMBLY_item_id=20 AND
BOM.bill_sequence_id=427702

rounding:
select
  msi.INVENTORY_ITEM_ID,
  msi.segment1 item,
  msi.description
from
  INV.MTL_SYSTEM_ITEMS msi,
  INV.MTL_ITEM_CATEGORIES MIC
where
  MSI.ORGANIZATION_ID=MIC.ORGANIZATION_ID AND
  MSI.INVENTORY_ITEM_ID=MIC.INVENTORY_ITEM_ID AND
  msi.ORGANIZATION_ID=255 and
  msi.segment1='2D35-0100091' and
  msi.PLANNING_MAKE_BUY_CODE=1 and
  mic.CATEGORY_ID=4
--------------------------------------------------

select * from INV.MTL_ITEM_CATEGORIES

select
  bor.ASSEMBLY_ITEM_ID,
  BOS.OPERATION_SEQUENCE_ID,
  bos.OPERATION_SEQ_NUM,
  bos.DEPARTMENT_ID,
  bos.EFFECTIVITY_DATE,
  bos.OPERATION_DESCRIPTION,
  NVL(bos.operation_type, 1) operation_type
  --bors.RESOURCE_SEQ_NUM,
  --bors.RESOURCE_ID

from
  bom.BOM_OPERATIONAL_ROUTINGS BOR,
  bom.BOM_OPERATION_SEQUENCES BOS
  --bom.BOM_OPERATION_RESOURCES BORS
where
  bor.ROUTING_SEQUENCE_ID=bos.ROUTING_SEQUENCE_ID and
  --BORS.OPERATION_SEQUENCE_ID(+) = BOS.OPERATION_SEQUENCE_ID AND
  bor.ORGANIZATION_ID=255 and
  bor.ASSEMBLY_ITEM_ID=268972
order by
  OPERATION_SEQ_NUM

 

 

-----------------------
select * from mtl_system_items where inventory_item_id=341210 and organization_id=255   2KD0-0000000
select * from BOM_OPERATIONAL_ROUTINGS where assembly_item_id=341210
select * from BOM_OPERATION_SEQUENCES  where routing_sequence_id=279801
select * from bom_operation_resources  where operation_sequence_id=643727
select * from bom_resources where resource_id in (937,941,941,939,942,943,936,938,940)
select * from bom_standard_operations where standard_operation_id=643727
--------------------------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12122734/viewspace-329665/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12122734/viewspace-329665/