[Home] [Help]
1258: THEN
1259: BEGIN
1260: SELECT Nvl(ALTERNATE_BOM_DESIGNATOR,bom_globals.retrieve_message('BOM','BOM_PRIMARY'))
1261: into l_structure_name
1262: FROM BOM_BILL_OF_MATERIALS
1263: WHERE bill_sequence_id = l_csd.pk1_value;
1264: if (l_structure_name IS NOT NULL) THEN
1265: OPEN c_item_rev_details;
1266: FETCH c_item_rev_details INTO l_structure_url_part;