eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_DELETE_ENTITY dependencies on BOM_BILL_OF_MATERIALS

Line 163: FROM bom_bill_of_materials

159: RETURN NUMBER
160: IS
161: CURSOR billseq is
162: select bill_sequence_id
163: FROM bom_bill_of_materials
164: where assembly_item_id = assembly_id and
165: organization_id = org_id and
166: nvl(alternate_bom_designator,'none') = nvl(alternate_bom,'none');
167: BEGIN

Line 315: common_bill bom_bill_of_materials.common_bill_sequence_id%type;

311: IS
312: l_index number := 0;
313: current_org number;
314: temp varchar2(1);
315: common_bill bom_bill_of_materials.common_bill_sequence_id%type;
316: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
317: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
318: del_ent_type bom_delete_entities.delete_entity_type%type;
319: inv_item_id bom_delete_entities.inventory_item_id%type;

Line 316: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;

312: l_index number := 0;
313: current_org number;
314: temp varchar2(1);
315: common_bill bom_bill_of_materials.common_bill_sequence_id%type;
316: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
317: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
318: del_ent_type bom_delete_entities.delete_entity_type%type;
319: inv_item_id bom_delete_entities.inventory_item_id%type;
320: alt_desg bom_delete_entities.alternate_designator%type;

Line 317: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;

313: current_org number;
314: temp varchar2(1);
315: common_bill bom_bill_of_materials.common_bill_sequence_id%type;
316: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
317: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
318: del_ent_type bom_delete_entities.delete_entity_type%type;
319: inv_item_id bom_delete_entities.inventory_item_id%type;
320: alt_desg bom_delete_entities.alternate_designator%type;
321: item_concat_seg bom_delete_entities.item_concat_segments%type;

Line 338: FROM bom_bill_of_materials

334:
335: CURSOR common_bills IS
336: SELECT common_bill_sequence_id,assembly_item_id,
337: alternate_bom_designator,bill_sequence_id
338: FROM bom_bill_of_materials
339: WHERE common_bill_sequence_id in (
340: select BOM2.bill_sequence_id
341: from bom_bill_of_materials BOM2
342: where BOM2.assembly_item_id = inv_item_id) and

Line 341: from bom_bill_of_materials BOM2

337: alternate_bom_designator,bill_sequence_id
338: FROM bom_bill_of_materials
339: WHERE common_bill_sequence_id in (
340: select BOM2.bill_sequence_id
341: from bom_bill_of_materials BOM2
342: where BOM2.assembly_item_id = inv_item_id) and
343: bill_sequence_id <> common_bill_sequence_id and
344: organization_id = current_org;
345:

Line 367: from bom_bill_of_materials

363: IF (current_bill_seq is not NULL) then -- BILLS
364: begin
365: select common_bill_sequence_id
366: into common_bill
367: from bom_bill_of_materials
368: where bill_sequence_id = current_bill_seq;
369: IF (current_bill_seq <> common_bill) then
370: exit;
371: END IF;

Line 438: from bom_bill_of_materials

434: null,
435: null,
436: null,
437: null
438: from bom_bill_of_materials
439: where organization_id = current_org and
440: common_bill_sequence_id = current_bill_seq and
441: bill_sequence_id <> current_bill_seq and
442: common_organization_id = original_org and

Line 496: common_bill bom_bill_of_materials.common_bill_sequence_id%type;

492: IS
493: l_index number := 0;
494: current_org number;
495: temp varchar2(1);
496: common_bill bom_bill_of_materials.common_bill_sequence_id%type;
497: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
498: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
499: current_rtg_seq bom_delete_entities.routing_sequence_id%type;
500: del_status bom_delete_entities.delete_status_type%type;

Line 497: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;

493: l_index number := 0;
494: current_org number;
495: temp varchar2(1);
496: common_bill bom_bill_of_materials.common_bill_sequence_id%type;
497: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
498: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
499: current_rtg_seq bom_delete_entities.routing_sequence_id%type;
500: del_status bom_delete_entities.delete_status_type%type;
501: del_ent_type bom_delete_entities.delete_entity_type%type;

Line 498: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;

494: current_org number;
495: temp varchar2(1);
496: common_bill bom_bill_of_materials.common_bill_sequence_id%type;
497: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
498: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
499: current_rtg_seq bom_delete_entities.routing_sequence_id%type;
500: del_status bom_delete_entities.delete_status_type%type;
501: del_ent_type bom_delete_entities.delete_entity_type%type;
502: inv_item_id bom_delete_entities.inventory_item_id%type;

Line 511: new_bill_seq bom_bill_of_materials.bill_sequence_id%type;

507: current_del_seq bom_delete_entities.delete_entity_sequence_id%type;
508: new_del_seq bom_delete_entities.delete_entity_sequence_id%type;
509: new_comp_seq bom_delete_sub_entities.component_sequence_id%type := NULL;
510: new_operation_seq bom_delete_sub_entities.operation_sequence_id%type;
511: new_bill_seq bom_bill_of_materials.bill_sequence_id%type;
512: new_rtg_seq bom_operational_routings.routing_sequence_id%type;
513: new_item_id bom_delete_entities.inventory_item_id%type;
514: component_id bom_inventory_components.component_item_id%type;
515: oper_seq_num bom_inventory_components.operation_seq_num%type;

Line 566: from bom_bill_of_materials

562: if (current_bill_seq is not null) then
563: begin
564: select common_bill_sequence_id
565: into common_bill
566: from bom_bill_of_materials
567: where bill_sequence_id = current_bill_seq;
568: exception
569: when no_data_found then
570: null;