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 383: FROM BOM_EXPLOSIONS

379: AND NVL(alternate_bom_designator,'NONE') = NVL(arg_alt_bom_desig,'NONE');
380:
381: CURSOR bom_expl(top_bill_id Number) IS
382: Select REQUEST_ID
383: FROM BOM_EXPLOSIONS
384: WHERE top_bill_sequence_id = top_bill_id
385: AND explosion_type = arg_expl_type;
386: -- bug 15961704
387: --AND sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode;

Line 393: From bom_explosions

389: Cursor GetExplodeFlags is
390: Select rowid,
391: plan_level,
392: sort_order
393: From bom_explosions
394: Where rexplode_flag = 1
395: And top_bill_sequence_id = x_top_bill_id
396: And explosion_type = arg_expl_type
397: Order by plan_level;

Line 486: BOM_EXPLOSIONS BE

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

Line 613: X_ParentCode bom_explosions.component_code%type;

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

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

647: END IF;
648:
649: --Added for bug 2700606
650:
651: x_delete_bom_expl := fnd_profile.value('BOM:DELETE_BOM_EXPLOSIONS');
652:
653: stmt_num := 15;
654:
655: IF (x_delete_bom_expl = 1) THEN

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

675: End Loop;
676:
677: stmt_num := 20;
678:
679: -- Insert a record for the assembly in BOM_EXPLOSIONS. This will serve as the
680: -- parent (plan_level = 0) for the rest of the explosion.
681: /*Bug 6407303 Added the attribute parent_sort_order and set its value to null*/
682: insert into bom_explosions
683: (TOP_BILL_SEQUENCE_ID ,

Line 682: insert into bom_explosions

678:
679: -- Insert a record for the assembly in BOM_EXPLOSIONS. This will serve as the
680: -- parent (plan_level = 0) for the rest of the explosion.
681: /*Bug 6407303 Added the attribute parent_sort_order and set its value to null*/
682: insert into bom_explosions
683: (TOP_BILL_SEQUENCE_ID ,
684: BILL_SEQUENCE_ID ,
685: ORGANIZATION_ID ,
686: EXPLOSION_TYPE ,

Line 783: from bom_explosions be

779: AND msitl.inventory_item_id = msi.inventory_item_id
780: AND msitl.language = userenv('LANG')
781: and not exists (
782: select null
783: from bom_explosions be
784: where be.top_bill_sequence_id = x_top_bill_id
785: and be.explosion_type = arg_expl_type
786: );
787:

Line 807: from BOM_EXPLOSIONS be

803: /* Start : Additions to fix bug #8496032 */
804:
805: select count(*)
806: into l_count
807: from BOM_EXPLOSIONS be
808: where be.rexplode_flag = 1
809: And be.top_bill_sequence_id = x_top_bill_id
810: And be.explosion_type = arg_expl_type
811: and exists (select *

Line 822: update BOM_EXPLOSIONS be

818: BEGIN
819: /* End : Additions to fix bug #8479442
820: Also see exception below */
821:
822: update BOM_EXPLOSIONS be
823: SET (BOM_ITEM_TYPE ,
824: DESCRIPTION ,
825: PRIMARY_UOM_CODE ,
826: PRIMARY_UNIT_OF_MEASURE ,

Line 876: UPDATE BOM_EXPLOSIONS

872:
873: /* Fix for bug 9198518 - Populate the request_id for top model as - 999 signifying
874: that the explosion is in process. Commit it so as to be visible for other explosion runs. */
875:
876: UPDATE BOM_EXPLOSIONS
877: SET request_id= -999
878: WHERE top_bill_sequence_id = x_top_bill_id
879: AND explosion_type = arg_expl_type
880: -- Bug 15961704

Line 894: Delete from bom_explosions be

890: End If;
891: -- delete the subtree needing re-explosion
892:
893: /*stmt_num := 40;
894: Delete from bom_explosions be
895: Where be.top_bill_sequence_id = x_top_bill_id
896: And be.explosion_type = arg_expl_type
897: and be.rexplode_flag = 1;
898: and be.sort_order like be.sort_order||'%'

Line 903: /*Delete from bom_explosions be

899: and be.sort_order <> be.sort_order
900: */
901:
902: Delete_Expl_Bill(x_top_bill_id,arg_expl_type);
903: /*Delete from bom_explosions be
904: Where be.top_bill_sequence_id = x_top_bill_id
905: and be.explosion_type = arg_expl_type
906: and exists (select 'X'
907: from bom_explosions be1

Line 907: from bom_explosions be1

903: /*Delete from bom_explosions be
904: Where be.top_bill_sequence_id = x_top_bill_id
905: and be.explosion_type = arg_expl_type
906: and exists (select 'X'
907: from bom_explosions be1
908: where be1.top_bill_sequence_id = x_top_bill_id
909: and be1.explosion_type = arg_expl_type
910: and be1.sort_order <> be.sort_order
911: and be.sort_order like be1.sort_order || '%'

Line 950: UPDATE bom_explosions be

946: the existing BOM's sort_order will go wrong during re_explosion
947: */
948: IF l_plan_level = 0
949: THEN
950: UPDATE bom_explosions be
951: SET sort_order = Bom_Common_Definitions.G_Bom_Init_SortCode
952: WHERE be.plan_level = 0
953: AND be.top_bill_sequence_id = x_top_bill_id
954: AND be.explosion_type = arg_expl_type

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

1110:
1111: -- Insert the pl/sql table using FORALL.
1112: stmt_num := 70;
1113: FORALL i IN 1..loop_Count_Val
1114: -- Removed append hint for bug 6065696 INSERT /*+ append */ INTO bom_explosions(
1115: INSERT INTO bom_explosions(
1116: TOP_BILL_SEQUENCE_ID,
1117: BILL_SEQUENCE_ID,
1118: ORGANIZATION_ID,

Line 1115: INSERT INTO bom_explosions(

1111: -- Insert the pl/sql table using FORALL.
1112: stmt_num := 70;
1113: FORALL i IN 1..loop_Count_Val
1114: -- Removed append hint for bug 6065696 INSERT /*+ append */ INTO bom_explosions(
1115: INSERT INTO bom_explosions(
1116: TOP_BILL_SEQUENCE_ID,
1117: BILL_SEQUENCE_ID,
1118: ORGANIZATION_ID,
1119: EXPLOSION_TYPE,

Line 1287: UPDATE bom_explosions be

1283: stmt_num := 80;
1284: /* Update the current level level so that the next iteration does not pick the
1285: the rows
1286: */
1287: UPDATE bom_explosions be
1288: SET be.rexplode_flag = 0
1289: WHERE be.plan_level = l_plan_level
1290: AND be.top_bill_sequence_id = x_top_bill_id
1291: AND be.explosion_type = arg_expl_type

Line 1310: UPDATE BOM_EXPLOSIONS

1306:
1307: /* Fix for bug 9198518 - After successful explosion of the entire top model,
1308: reset the request_id for top model back to NULL. */
1309:
1310: UPDATE BOM_EXPLOSIONS
1311: SET request_id= NULL
1312: WHERE top_bill_sequence_id = x_top_bill_id
1313: AND explosion_type = arg_expl_type
1314: -- Bug 15961704