[Home] [Help]
262: AND nvl(disable_date, sysdate + 1) > sysdate
263: AND rownum = 1;
264: EXCEPTION WHEN NO_DATA_FOUND THEN
265: -- If there are no rows in the main table then, it means that there are rows
266: -- in the bom_component_operations table(1-many enhancement).
267: -- So we go there to get the component for the current operation and then
268: -- the planning factor for that component.
269: begin
270: SELECT NVL(bic.planning_factor, 100)
269: begin
270: SELECT NVL(bic.planning_factor, 100)
271: INTO v_planning_factor
272: FROM bom_inventory_components bic,
273: bom_component_operations bco
274: WHERE
275: bco.bill_sequence_id = x_bom_id
276: AND bco.operation_sequence_id =
277: All_Events_cur_rec.operation_sequence_id
319: * NVL(opt_class_comps_rec.planning_factor, 100))/100
320: INTO v_planning_factor
321: FROM bom_bill_of_materials bom,
322: bom_inventory_components bic,
323: bom_component_operations bco
324: --WHERE bom.common_bill_sequence_id = opt_bill_id -- BUG 5199596
325: WHERE bom.bill_sequence_id = opt_bill_id
326: AND bom.common_bill_sequence_id = bco.bill_sequence_id
327: AND bco.operation_sequence_id =
423: begin
424: SELECT NVL(bic.planning_factor, 100)
425: INTO v_planning_factor
426: FROM bom_inventory_components bic,
427: bom_component_operations bco
428: WHERE
429: bco.bill_sequence_id = x_bom_id
430: AND bco.operation_sequence_id =
431: All_Events_cur_rec.operation_sequence_id
474: * NVL(opt_class_comps_rec.planning_factor, 100))/100
475: INTO v_planning_factor
476: FROM bom_bill_of_materials bom,
477: bom_inventory_components bic,
478: bom_component_operations bco
479: --WHERE bom.common_bill_sequence_id = opt_bill_id -- BUG 5199596
480: WHERE bom.bill_sequence_id = opt_bill_id
481: AND bom.common_bill_sequence_id = bco.bill_sequence_id
482: AND bco.operation_sequence_id =