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_OE_EXPLODER_PKG dependencies on BOM_EXPLOSIONS

Line 13: | for the given item in the BOM_EXPLOSIONS table.

Line 264: from bom_explosions

260: pragma AUTONOMOUS_TRANSACTION;
261:
262: CURSOR c_rows_to_delete IS
263: select sort_order
264: from bom_explosions
265: where top_bill_sequence_id = top_bill_id
266: and explosion_type = arg_expl_type
267: and rexplode_flag = 1;
268: BEGIN

Line 272: DELETE from bom_explosions

268: BEGIN
269:
270: for parent in c_rows_to_delete
271: loop
272: DELETE from bom_explosions
273: WHERE top_bill_sequence_id = top_bill_id
274: AND explosion_type = arg_expl_type
275: AND sort_order like parent.sort_order || '%'
276: AND sort_order <> parent.sort_order;

Line 304: FROM bom_explosions

300: This is because the fetch size is 1000 and the sort_order should be unique.
301: */
302: SELECT count(bill_sequence_id)
303: INTO x_sort_counter
304: FROM bom_explosions
305: WHERE top_bill_sequence_id = OB_TOP_BILL_SEQUENCE_ID(1)
306: AND bill_sequence_id = OB_BILL_SEQUENCE_ID(1)
307: AND ( sort_order like OB_SORT_ORDER(1)||'%' AND
308: sort_order <> OB_SORT_ORDER(1)

Line 380: FROM BOM_EXPLOSIONS

376: AND NVL(alternate_bom_designator,'NONE') = NVL(arg_alt_bom_desig,'NONE');
377:
378: CURSOR bom_expl(top_bill_id Number) IS
379: Select REQUEST_ID
380: FROM BOM_EXPLOSIONS
381: WHERE top_bill_sequence_id = top_bill_id
382: AND explosion_type = arg_expl_type
383: AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode;
384:

Line 389: From bom_explosions

385: Cursor GetExplodeFlags is
386: Select rowid,
387: plan_level,
388: sort_order
389: From bom_explosions
390: Where rexplode_flag = 1
391: And top_bill_sequence_id = x_top_bill_id
392: And explosion_type = arg_expl_type
393: Order by plan_level;

Line 482: BOM_EXPLOSIONS BE

478: MTL_SYSTEM_ITEMS MSI,
479: MTL_SYSTEM_ITEMS_TL MSITL,
480: BOM_COMPONENTS_B BIC,
481: BOM_STRUCTURES_B BOM,
482: BOM_EXPLOSIONS BE
483: -- FP bug fix for 12.1.1. The bug # is 7307613.
484: -- Fixed by Minling on 10/15/08.
485: -- Changed the WHERE condition to improve performance of the query.
486: WHERE ( ( BBOM_C.obj_name IS NULL AND fnd_global.RESP_APPL_ID = 431 )

Line 609: X_ParentCode bom_explosions.component_code%type;

605: decode(arg_order_by,1,bic.operation_seq_num, bic.item_num),
606: decode(arg_order_by,1,bic.item_num, bic.operation_seq_num);
607:
608:
609: X_ParentCode bom_explosions.component_code%type;
610: X_Ancestor number; -- component item id within component code
611:
612: Loop_Count_Val Number := 0;
613: L_Bulk_Count Number := 0;

Line 647: x_delete_bom_expl := fnd_profile.value('BOM:DELETE_BOM_EXPLOSIONS');

643: END IF;
644:
645: --Added for bug 2700606
646:
647: x_delete_bom_expl := fnd_profile.value('BOM:DELETE_BOM_EXPLOSIONS');
648:
649: stmt_num := 15;
650:
651: IF (x_delete_bom_expl = 1) THEN

Line 664: -- Insert a record for the assembly in BOM_EXPLOSIONS. This will serve as the

660: END IF;
661:
662: stmt_num := 20;
663:
664: -- Insert a record for the assembly in BOM_EXPLOSIONS. This will serve as the
665: -- parent (plan_level = 0) for the rest of the explosion.
666: /*Bug 6407303 Added the attribute parent_sort_order and set its value to null*/
667: insert into bom_explosions
668: (TOP_BILL_SEQUENCE_ID ,

Line 667: insert into bom_explosions

663:
664: -- Insert a record for the assembly in BOM_EXPLOSIONS. This will serve as the
665: -- parent (plan_level = 0) for the rest of the explosion.
666: /*Bug 6407303 Added the attribute parent_sort_order and set its value to null*/
667: insert into bom_explosions
668: (TOP_BILL_SEQUENCE_ID ,
669: BILL_SEQUENCE_ID ,
670: ORGANIZATION_ID ,
671: EXPLOSION_TYPE ,

Line 768: from bom_explosions be

764: AND msitl.inventory_item_id = msi.inventory_item_id
765: AND msitl.language = userenv('LANG')
766: and not exists (
767: select null
768: from bom_explosions be
769: where be.top_bill_sequence_id = x_top_bill_id
770: and be.explosion_type = arg_expl_type
771: );
772:

Line 777: update BOM_EXPLOSIONS be

773: -- Moved code for Performance from the while loop to the outer loop
774: -- Do not execute the update statement if the insert statement just inserted
775: --the record, bug: 3809420
776: If (sql%rowcount = 0) then
777: update BOM_EXPLOSIONS be
778: SET (BOM_ITEM_TYPE ,
779: DESCRIPTION ,
780: PRIMARY_UOM_CODE ,
781: PRIMARY_UNIT_OF_MEASURE ,

Line 825: Delete from bom_explosions be

821: End If;
822: -- delete the subtree needing re-explosion
823:
824: /*stmt_num := 40;
825: Delete from bom_explosions be
826: Where be.top_bill_sequence_id = x_top_bill_id
827: And be.explosion_type = arg_expl_type
828: and be.rexplode_flag = 1;
829: and be.sort_order like be.sort_order||'%'

Line 834: /*Delete from bom_explosions be

830: and be.sort_order <> be.sort_order
831: */
832:
833: Delete_Expl_Bill(x_top_bill_id,arg_expl_type);
834: /*Delete from bom_explosions be
835: Where be.top_bill_sequence_id = x_top_bill_id
836: and be.explosion_type = arg_expl_type
837: and exists (select 'X'
838: from bom_explosions be1

Line 838: from bom_explosions be1

834: /*Delete from bom_explosions be
835: Where be.top_bill_sequence_id = x_top_bill_id
836: and be.explosion_type = arg_expl_type
837: and exists (select 'X'
838: from bom_explosions be1
839: where be1.top_bill_sequence_id = x_top_bill_id
840: and be1.explosion_type = arg_expl_type
841: and be1.sort_order <> be.sort_order
842: and be.sort_order like be1.sort_order || '%'

Line 881: UPDATE bom_explosions be

877: the existing BOM's sort_order will go wrong during re_explosion
878: */
879: IF l_plan_level = 0
880: THEN
881: UPDATE bom_explosions be
882: SET sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode
883: WHERE be.plan_level = 0
884: AND be.top_bill_sequence_id = x_top_bill_id
885: AND be.explosion_type = arg_expl_type

Line 1045: -- Removed append hint for bug 6065696 INSERT /+ append / INTO bom_explosions(

1041:
1042: -- Insert the pl/sql table using FORALL.
1043: stmt_num := 70;
1044: FORALL i IN 1..loop_Count_Val
1045: -- Removed append hint for bug 6065696 INSERT /*+ append */ INTO bom_explosions(
1046: INSERT INTO bom_explosions(
1047: TOP_BILL_SEQUENCE_ID,
1048: BILL_SEQUENCE_ID,
1049: ORGANIZATION_ID,

Line 1046: INSERT INTO bom_explosions(

1042: -- Insert the pl/sql table using FORALL.
1043: stmt_num := 70;
1044: FORALL i IN 1..loop_Count_Val
1045: -- Removed append hint for bug 6065696 INSERT /*+ append */ INTO bom_explosions(
1046: INSERT INTO bom_explosions(
1047: TOP_BILL_SEQUENCE_ID,
1048: BILL_SEQUENCE_ID,
1049: ORGANIZATION_ID,
1050: EXPLOSION_TYPE,

Line 1218: UPDATE bom_explosions be

1214: stmt_num := 80;
1215: /* Update the current level level so that the next iteration does not pick the
1216: the rows
1217: */
1218: UPDATE bom_explosions be
1219: SET be.rexplode_flag = 0
1220: WHERE be.plan_level = l_plan_level
1221: AND be.top_bill_sequence_id = x_top_bill_id
1222: AND be.explosion_type = arg_expl_type