APPS.BOM_BOM_COMPONENT_UTIL dependencies on BOM_STRUCTURES_B

Line 592: FROM bom_structures_b

588: BEGIN
589:
590: SELECT source_bill_sequence_id
591: INTO l_src_bill_seq_id
592: FROM bom_structures_b
593: WHERE bill_sequence_id = p_bill_sequence_id
594: and bill_sequence_id <> source_bill_sequence_id;
595:
596: select component_sequence_id into l_src_comp_seq_id from bom_components_b

Line 945: l1_src_bill_seq_id, l1_com_bill_seq_id from bom_structures_b

941: -- and does not expect the program to automatically create the record
942:
943: IF Bom_Globals.Get_Caller_Type = 'MIGRATION' THEN
944: select source_bill_sequence_id, common_bill_sequence_id into
945: l1_src_bill_seq_id, l1_com_bill_seq_id from bom_structures_b
946: where bill_sequence_id = p_rev_comp_Unexp_rec.bill_sequence_id;
947: --if the following condition is true and you are here it means you have an updatable common bill
948: IF p_rev_comp_Unexp_rec.bill_sequence_id <> l1_src_bill_seq_id THEN
949: --you may already have assigned bill sequence id to common bill sequence id

Line 952: update bom_structures_b set common_bill_sequence_id = p_rev_comp_Unexp_rec.bill_sequence_id

948: IF p_rev_comp_Unexp_rec.bill_sequence_id <> l1_src_bill_seq_id THEN
949: --you may already have assigned bill sequence id to common bill sequence id
950: -- in that case no update is needed, otherwise it is required
951: IF p_rev_comp_Unexp_rec.bill_sequence_id <> l1_com_bill_seq_id THEN
952: update bom_structures_b set common_bill_sequence_id = p_rev_comp_Unexp_rec.bill_sequence_id
953: where bill_sequence_id = p_rev_comp_Unexp_rec.bill_sequence_id;
954: END IF;
955: END IF;
956: END IF;

Line 1137: from bom_structures_b

1133: END IF;
1134:
1135: -- bug 5199643
1136: select assembly_type into l_assembly_type
1137: from bom_structures_b
1138: where bill_sequence_id = l_rev_comp_unexp_rec.bill_sequence_id;
1139:
1140: l_dg_sequence_id :=
1141: MODAL_DELETE.DELETE_MANAGER

Line 1642: BOM_STRUCTURES_B BOM_STRUCT

1638: l_Assembly_Item_Id,
1639: l_Organization_Id,
1640: l_Structure_Name
1641: FROM BOM_STRUCTURE_TYPES_B STRUCT_TYPE,
1642: BOM_STRUCTURES_B BOM_STRUCT
1643: -- Added the below NVL condition for bug 14202819
1644: WHERE NVL(BOM_STRUCT.STRUCTURE_TYPE_ID, 1) = STRUCT_TYPE.STRUCTURE_TYPE_ID
1645: AND BOM_STRUCT.BILL_SEQUENCE_ID = l_Rev_Comp_Unexp_Rec.BILL_SEQUENCE_ID;
1646: