APPS.BOM_CALC_OP_TIMES_PK dependencies on BOM_INVENTORY_COMPONENTS

Line 44: FROM bom_inventory_components bic, bom_bill_of_materials bom

40: AND nvl(disable_date, sysdate + 1) > sysdate;
41:
42: CURSOR opt_class_comps_cur(v_bill_seq_id NUMBER) IS
43: SELECT component_item_id, planning_factor
44: FROM bom_inventory_components bic, bom_bill_of_materials bom
45: WHERE bom.bill_sequence_id = v_bill_seq_id
46: AND bom.common_bill_sequence_id = bic.bill_sequence_id
47: AND NVL(bic.eco_for_production,2) = 2
48: AND bic.bom_item_type = 2;

Line 257: FROM bom_inventory_components

253: assoc_flag := 1;
254: BEGIN
255: SELECT NVL(planning_factor, 100)
256: INTO v_planning_factor
257: FROM bom_inventory_components
258: WHERE bill_sequence_id = x_bom_id
259: AND operation_seq_num = All_Events_cur_rec.operation_seq_num
260: AND NVL(eco_for_production,2) = 2
261: AND effectivity_date <= sysdate

Line 272: FROM bom_inventory_components bic,

268: -- the planning factor for that component.
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 =

Line 309: FROM bom_bill_of_materials bom, bom_inventory_components bic

305:
306: SELECT (NVL(planning_factor, 100)
307: * NVL(opt_class_comps_rec.planning_factor, 100))/100
308: INTO v_planning_factor
309: FROM bom_bill_of_materials bom, bom_inventory_components bic
310: WHERE bom.common_bill_sequence_id = opt_bill_id
311: AND bom.common_bill_sequence_id = bic.bill_sequence_id
312: AND bic.operation_seq_num = All_Events_cur_rec.operation_seq_num
313: AND NVL(bic.eco_for_production,2) = 2

Line 322: bom_inventory_components bic,

318: SELECT (NVL(planning_factor, 100)
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

Line 414: FROM bom_inventory_components

410: assoc_flag := 1;
411: BEGIN
412: SELECT nvl(planning_factor, 100)
413: INTO v_planning_factor
414: FROM bom_inventory_components
415: WHERE bill_sequence_id = x_bom_id
416: AND operation_seq_num = All_Events_cur_rec.operation_seq_num
417: AND effectivity_date <= sysdate
418: AND nvl(disable_date, sysdate + 1) > sysdate

Line 426: FROM bom_inventory_components bic,

422: -- 1-many enhancement as for the process
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 =

Line 463: FROM bom_bill_of_materials bom, bom_inventory_components bic

459:
460: SELECT (nvl(planning_factor, 100)
461: * nvl(opt_class_comps_rec.planning_factor, 100))/100
462: INTO v_planning_factor
463: FROM bom_bill_of_materials bom, bom_inventory_components bic
464: WHERE bom.common_bill_sequence_id = opt_bill_id
465: AND bom.common_bill_sequence_id = bic.bill_sequence_id
466: AND bic.operation_seq_num = All_Events_cur_rec.operation_seq_num
467: AND NVL(bic.eco_for_production,2) = 2

Line 477: bom_inventory_components bic,

473: SELECT (NVL(planning_factor, 100)
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