APPS.BOM_CALC_OP_TIMES_PK dependencies on BOM_BILL_OF_MATERIALS

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 208: from bom_bill_of_materials bom, bom_operational_routings bor

204: -- get the BOM to see if there are any option class comps.
205: BEGIN
206: select bill_sequence_id, alternate_bom_designator
207: into x_bom_id, x_alt_bom_desg
208: from bom_bill_of_materials bom, bom_operational_routings bor
209: where routing_sequence_id = arg_routing_sequence_id
210: and bor.assembly_item_id = bom.assembly_item_id
211: and bor.organization_id = bom.organization_id
212: and nvl(bor.alternate_routing_designator, 'NONE')

Line 300: FROM bom_bill_of_materials bom

296: FOR opt_class_comps_rec IN opt_class_comps_cur(x_bom_id) LOOP
297: BEGIN
298: SELECT bill_sequence_id
299: INTO opt_bill_id
300: FROM bom_bill_of_materials bom
301: WHERE bom.assembly_item_id = opt_class_comps_rec.component_item_id
302: AND bom.organization_id = arg_org_id
303: AND NVL(bom.alternate_bom_designator, 'NONE')
304: = NVL(x_alt_bom_desg, 'NONE');

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 321: FROM bom_bill_of_materials bom,

317: begin
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

Line 454: FROM bom_bill_of_materials bom

450: FOR opt_class_comps_rec IN opt_class_comps_cur(x_bom_id) LOOP
451: BEGIN
452: SELECT bill_sequence_id
453: INTO opt_bill_id
454: FROM bom_bill_of_materials bom
455: WHERE bom.assembly_item_id = opt_class_comps_rec.component_item_id
456: AND bom.organization_id = arg_org_id
457: AND NVL(bom.alternate_bom_designator, 'NONE')
458: = NVL(x_alt_bom_desg, 'NONE');

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 476: FROM bom_bill_of_materials bom,

472: begin
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