Query to find BOM and Routings data

Query to find BOM and Routings data
Oracle apps sql query to get BOM and Routings details

Query to find Routings data

SELECT segment1,
       bos.OPERATION_SEQ_NUM,
       RESOURCE_SEQ_NUM,
       effectivity_date
  FROM apps.bom_operation_sequences bos,
       bom_operational_routings     bor,
       mtl_system_items_b           msib,
       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 = msib.organization_id
       AND assembly_item_id = inventory_item_id
       AND msib.organization_id = 1234

Query to find BOM Data

SELECT a.assembly_item_id,
       a.organization_id,
       a.bill_sequence_id,
       a.alternate_bom_designator,
       b.operation_seq_num,
       b.bill_sequence_id,
       b.component_item_id,
       b.item_num,
       b.component_quantity,
       b.wip_supply_type,
       c.segment1,
       c.description
  FROM bom_bill_of_materials    a,
       bom_inventory_components b,
       mtl_system_items         c
 WHERE     a.bill_sequence_id = b.bill_sequence_id
       AND a.assembly_item_id = c.inventory_item_id
       AND a.organization_id = c.organization_id
       AND c.organization_id = 1234

Related posts:

• Query to find all APIs of Oracle Apps modules
• Query to find serial number material transactions details
• Query to get details of WIP discrete jobs
• Query to find BOM and Routings data

Upload your own post and refer it anywhere anytime: