Query to find BOM and Routings data

1SELECT segment1,
2       bos.OPERATION_SEQ_NUM,
3       RESOURCE_SEQ_NUM,
4       effectivity_date
5  FROM apps.bom_operation_sequences bos,
6       bom_operational_routings     bor,
7       mtl_system_items_b           msib,
8       bom_operation_resources      bors
9 WHERE     bor.routing_sequence_id = bos.routing_sequence_id
10       AND bors.OPERATION_SEQUENCE_ID = bos.OPERATION_SEQUENCE_ID
11       AND bor.organization_id = msib.organization_id
12       AND assembly_item_id = inventory_item_id
13       AND msib.organization_id = 1234

1SELECT a.assembly_item_id,
2       a.organization_id,
3       a.bill_sequence_id,
4       a.alternate_bom_designator,
5       b.operation_seq_num,
6       b.bill_sequence_id,
7       b.component_item_id,
8       b.item_num,
9       b.component_quantity,
10       b.wip_supply_type,
11       c.segment1,
12       c.description
13  FROM bom_bill_of_materials    a,
14       bom_inventory_components b,
15       mtl_system_items         c
16 WHERE     a.bill_sequence_id = b.bill_sequence_id
17       AND a.assembly_item_id = c.inventory_item_id
18       AND a.organization_id = c.organization_id
19       AND c.organization_id = 1234