343: IF nvl(l_make_buy,1) <> 2 THEN
344: BEGIN
345: SELECT BILL_SEQUENCE_ID
346: INTO l_bill_seq_id
347: FROM BOM_BILL_OF_MATERIALS
348: WHERE ORGANIZATION_ID = l_org_id
349: AND ASSEMBLY_ITEM_ID = p_line_rec.inventory_item_id(p_index)
350: AND ALTERNATE_BOM_DESIGNATOR IS NULL;
351: