APPS.ENGECOBO dependencies on BOM_STRUCTURES_B

Line 1143: FROM eng_revised_items eri, bom_structures_b bsb

1139: IS
1140: SELECT eri.revised_item_id, eri.revised_item_sequence_id, eri.alternate_bom_designator
1141: , eri.change_notice, eri.from_end_item_rev_id, eri.from_end_item_strc_rev_id
1142: , bsb.source_bill_sequence_id, eri.bill_sequence_id
1143: FROM eng_revised_items eri, bom_structures_b bsb
1144: WHERE eri.bill_sequence_id = bsb.bill_sequence_id
1145: AND ((eri.revised_item_sequence_id = v_rev_item_seq_id
1146: AND eri.bill_sequence_id IS NOT NULL
1147: AND (eri.transfer_or_copy IS NULL

Line 3028: bom_structures_b bom

3024: BEGIN
3025: SELECT bom.alternate_bom_designator
3026: INTO l_alternate_bom
3027: FROM bom_inventory_components bic,
3028: bom_structures_b bom
3029: WHERE bic.component_sequence_id = sc.component_sequence_id
3030: AND bic.bill_sequence_id = bom.bill_sequence_id;
3031:
3032: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 3153: bom_structures_b bom

3149: BEGIN
3150: SELECT bom.alternate_bom_designator
3151: INTO l_alternate_bom
3152: FROM bom_inventory_components bic,
3153: bom_structures_b bom
3154: WHERE bic.component_sequence_id = rd.component_sequence_id
3155: AND bic.bill_sequence_id = bom.bill_sequence_id;
3156:
3157: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 5280: FROM bom_structures_b BSB,

5276: l_structure_type_name := NULL;
5277: BEGIN
5278: SELECT BSTV.structure_type_name
5279: INTO l_structure_type_name
5280: FROM bom_structures_b BSB,
5281: bom_structure_types_vl BSTV
5282: WHERE BSB.structure_type_id = BSTV.structure_type_id
5283: AND BSB.bill_sequence_id = ri.bill_sequence_id;
5284: