DBA Data[Home] [Help]

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 5153: FROM bom_structures_b BSB,

5149: l_structure_type_name := NULL;
5150: BEGIN
5151: SELECT BSTV.structure_type_name
5152: INTO l_structure_type_name
5153: FROM bom_structures_b BSB,
5154: bom_structure_types_vl BSTV
5155: WHERE BSB.structure_type_id = BSTV.structure_type_id
5156: AND BSB.bill_sequence_id = ri.bill_sequence_id;
5157: