1394: SELECT 1
1395: FROM sys.dual
1396: WHERE NOT EXISTS
1397: ( SELECT bill_sequence_id
1398: FROM bom_bill_of_materials
1399: WHERE assembly_item_id =
1400: l_rev_comp_unexp_rec.revised_item_id
1401: AND organization_id =
1402: l_rev_comp_unexp_rec.organization_id
1797: Error_handler.Write_debug('Rev_Comps: defaulted effectivity control: ' || l_effectivity_control);
1798: END IF;
1799: -- End fix of bug 4550996
1800:
1801: INSERT INTO Bom_Bill_Of_Materials
1802: ( assembly_item_id
1803: , organization_id
1804: , pending_from_ecn
1805: , bill_sequence_id