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_EXPLODER_PUB dependencies on BOM_EXPLOSIONS_ALL

Line 14: | use value FROM sequence BOM_EXPLOSIONS_ALL_s

Line 16: | use value FROM BOM_EXPLOSIONS_ALL_session_s

Line 388: INSERT INTO BOM_EXPLOSIONS_ALL

384: , p_plan_level IN NUMBER
385: )
386: IS
387: BEGIN
388: INSERT INTO BOM_EXPLOSIONS_ALL
389: ( top_bill_sequence_id
390: ,bill_sequence_id
391: ,organization_id
392: ,explosion_type

Line 459: FROM BOM_EXPLOSIONS_ALL BET ,

455: 0, -- default insert attachment with rexplode flag of 0
456: BET.exploded_date,
457: BET.exploded_unit_number,
458: BET.exploded_end_item_rev
459: FROM BOM_EXPLOSIONS_ALL BET ,
460: FND_ATTACHED_DOCUMENTS ATDOCS,
461: FND_DOCUMENTS_TL DOCTL
462: WHERE ATDOCS.DOCUMENT_ID = DOCTL.DOCUMENT_ID
463: AND DOCTL.LANGUAGE = USERENV('LANG')

Line 529: FROM BOM_EXPLOSIONS_ALL

525: AND d.disable_date IS NULL
526: AND d.acd_type = 1
527: AND r.bill_sequence_id IN
528: (SELECT bill_sequence_id
529: FROM BOM_EXPLOSIONS_ALL
530: WHERE group_id = p_Group_Id
531: );
532:
533: IF (reApply = 1) THEN

Line 534: UPDATE BOM_EXPLOSIONS_ALL

530: WHERE group_id = p_Group_Id
531: );
532:
533: IF (reApply = 1) THEN
534: UPDATE BOM_EXPLOSIONS_ALL
535: SET is_excluded_by_rule = NULL
536: WHERE group_id = p_Group_Id
537: AND is_excluded_by_rule = 'Y';
538: END IF;

Line 540: UPDATE BOM_EXPLOSIONS_ALL

536: WHERE group_id = p_Group_Id
537: AND is_excluded_by_rule = 'Y';
538: END IF;
539:
540: UPDATE BOM_EXPLOSIONS_ALL
541: SET reapply_exclusions = NULL
542: WHERE group_id = p_Group_Id AND plan_level = 0;
543:
544: FORALL i in 1..exclusion_t.count

Line 545: UPDATE BOM_EXPLOSIONS_ALL

541: SET reapply_exclusions = NULL
542: WHERE group_id = p_Group_Id AND plan_level = 0;
543:
544: FORALL i in 1..exclusion_t.count
545: UPDATE BOM_EXPLOSIONS_ALL
546: SET is_excluded_by_rule = 'Y'
547: WHERE group_id = p_Group_Id
548: AND new_component_code like exclusion_t(i);
549: END;/* Procedure Apply_Exclusion_Rules Ends */

Line 573: UPDATE BOM_EXPLOSIONS_ALL

569: AND d.acd_type = 1
570: AND r.bill_sequence_id = p_bill_sequence_id;
571:
572: FORALL i in 1..exclusion_t.count
573: UPDATE BOM_EXPLOSIONS_ALL
574: SET is_excluded_by_rule = 'Y'
575: WHERE group_id IN
576: (SELECT t.Group_Id FROM BOM_EXPLOSIONS_ALL t
577: WHERE t.bill_sequence_id = p_bill_sequence_id

Line 576: (SELECT t.Group_Id FROM BOM_EXPLOSIONS_ALL t

572: FORALL i in 1..exclusion_t.count
573: UPDATE BOM_EXPLOSIONS_ALL
574: SET is_excluded_by_rule = 'Y'
575: WHERE group_id IN
576: (SELECT t.Group_Id FROM BOM_EXPLOSIONS_ALL t
577: WHERE t.bill_sequence_id = p_bill_sequence_id
578: )
579: AND new_component_code like exclusion_t(i);
580: END; /* Procedure Apply_New_Exclusion_Rules Ends */

Line 593: UPDATE BOM_EXPLOSIONS_ALL

589: ******************************************************************************/
590: PROCEDURE Set_Reapply_Exclusion_Flag (p_bill_sequence_id IN NUMBER)
591: IS
592: BEGIN
593: UPDATE BOM_EXPLOSIONS_ALL
594: SET reapply_exclusions = 'Y'
595: WHERE Top_bill_sequence_id IN
596: (SELECT Top_bill_sequence_id FROM BOM_EXPLOSIONS_ALL
597: WHERE bill_sequence_id = p_bill_sequence_id

Line 596: (SELECT Top_bill_sequence_id FROM BOM_EXPLOSIONS_ALL

592: BEGIN
593: UPDATE BOM_EXPLOSIONS_ALL
594: SET reapply_exclusions = 'Y'
595: WHERE Top_bill_sequence_id IN
596: (SELECT Top_bill_sequence_id FROM BOM_EXPLOSIONS_ALL
597: WHERE bill_sequence_id = p_bill_sequence_id
598: )
599: AND plan_level = 0;
600: END;/* Procedure Set_Reapply_Exclusion_Flag Ends */

Line 879: BOM_EXPLOSIONS_ALL BET,

875: to_number(NULL) CSBSI,
876: to_number(NULL) COMP_EFFECTIVITY_CONTROL
877: FROM
878: --BOM_PLM_EXPLOSION_TEMP BET,
879: BOM_EXPLOSIONS_ALL BET,
880: BOM_STRUCTURES_B BOM,
881: BOM_COMPONENTS_B BIC
882: WHERE BET.GROUP_ID = c_grp_id
883: AND BET.PLAN_LEVEL = c_level - 1

Line 1224: BOM_EXPLOSIONS_ALL bet

1220: Select msi.concatenated_segments,
1221: bom.alternate_bom_designator
1222: From mtl_system_items_b_kfv msi,
1223: bom_structures_b bom,
1224: BOM_EXPLOSIONS_ALL bet
1225: Where msi.inventory_item_id = bom.assembly_item_id
1226: And msi.organization_id = bom.organization_id
1227: And bom.bill_sequence_id = bet.top_bill_sequence_id
1228: And bet.group_id = grp_id

Line 2056: --INSERT /+append / INTO BOM_EXPLOSIONS_ALL

2052: INSERT INTO bom_plm_explosion_temp VALUES be_temp_TBL(i);
2053: */
2054:
2055: FORALL i IN 1..top_bill_sequence_id_tbl.COUNT
2056: --INSERT /*+append */ INTO BOM_EXPLOSIONS_ALL
2057: INSERT INTO BOM_EXPLOSIONS_ALL
2058: (
2059: TOP_BILL_SEQUENCE_ID ,
2060: BILL_SEQUENCE_ID ,

Line 2057: INSERT INTO BOM_EXPLOSIONS_ALL

2053: */
2054:
2055: FORALL i IN 1..top_bill_sequence_id_tbl.COUNT
2056: --INSERT /*+append */ INTO BOM_EXPLOSIONS_ALL
2057: INSERT INTO BOM_EXPLOSIONS_ALL
2058: (
2059: TOP_BILL_SEQUENCE_ID ,
2060: BILL_SEQUENCE_ID ,
2061: COMMON_BILL_SEQUENCE_ID ,

Line 2355: UPDATE BOM_EXPLOSIONS_ALL

2351:
2352: --Dbms_Output.put_line('g_parent_sort_order_tbl.COUNT : '||g_parent_sort_order_tbl.COUNT);
2353:
2354: FORALL i IN 1..g_parent_sort_order_tbl.COUNT
2355: UPDATE BOM_EXPLOSIONS_ALL
2356: SET quantity_of_children = g_quantity_of_children_tbl(i),
2357: total_qty_at_next_level = g_total_qty_at_next_level_tbl(i)
2358: WHERE group_id = grp_id
2359: AND sort_order = g_parent_sort_order_tbl(i);

Line 2361: UPDATE BOM_EXPLOSIONS_ALL bet SET (bet.primary_uom_code, bet.eng_item_flag, bet.primary_unit_of_measure) =

2357: total_qty_at_next_level = g_total_qty_at_next_level_tbl(i)
2358: WHERE group_id = grp_id
2359: AND sort_order = g_parent_sort_order_tbl(i);
2360:
2361: UPDATE BOM_EXPLOSIONS_ALL bet SET (bet.primary_uom_code, bet.eng_item_flag, bet.primary_unit_of_measure) =
2362: (SELECT msi.primary_uom_code
2363: , msi.eng_item_flag
2364: , mum.unit_of_measure
2365: FROM mtl_system_items_b msi

Line 2605: FROM BOM_EXPLOSIONS_ALL

2601: SELECT
2602: COMPONENT_CODE,
2603: LOOP_FLAG,
2604: PLAN_LEVEL
2605: FROM BOM_EXPLOSIONS_ALL
2606: WHERE GROUP_ID = c_group_id
2607: AND LOOP_FLAG = 1;
2608: BEGIN
2609:

Line 2612: FROM BOM_EXPLOSIONS_ALL

2608: BEGIN
2609:
2610: SELECT NVL( TOP_ALTERNATE_DESIGNATOR, 'none' ), ORGANIZATION_ID
2611: INTO top_alt, org_id
2612: FROM BOM_EXPLOSIONS_ALL
2613: WHERE GROUP_ID = grp_id
2614: AND ROWNUM = 1
2615: AND PLAN_LEVEL = 0;
2616:

Line 2755: FROM BOM_EXPLOSIONS_ALL BET, bom_structures_b BOM

2751: BET.common_bill_sequence_id curCBSI,
2752: BET.group_id curGI,
2753: BET.primary_uom_code curPUC,
2754: BET.primary_unit_of_measure curPUM
2755: FROM BOM_EXPLOSIONS_ALL BET, bom_structures_b BOM
2756: WHERE BET.group_id = p_group_id AND BET.obj_name IS NULL AND
2757: BET.bill_sequence_id <> BET.common_bill_sequence_id AND
2758: BET.source_bill_sequence_id = BOM.BILL_SEQUENCE_ID AND
2759: BET.plan_level <> 0;

Line 2838: SELECT sort_order, comp_common_bill_seq_id, comp_bill_seq_id FROM BOM_EXPLOSIONS_ALL WHERE

2834: pk2_value = p_pk2_value AND structure_type_id = p_structure_type_id;
2835:
2836:
2837: CURSOR c_dirty_nodes (p_group_id IN NUMBER ) IS
2838: SELECT sort_order, comp_common_bill_seq_id, comp_bill_seq_id FROM BOM_EXPLOSIONS_ALL WHERE
2839: group_id = grp_id AND comp_bill_seq_id IS NOT NULL AND rexplode_flag = 1
2840: ORDER BY sort_order;
2841:
2842: CURSOR c_get_first_revision (p_inventory_item_id IN NUMBER,

Line 2856: mir.revision revision FROM bom_explosions_all bet, mtl_item_revisions_b mir

2852: WHERE structure_type_name = 'Packaging Hierarchy';
2853:
2854: CURSOR getComponentFixedRevisions (p_group_id IN NUMBER) IS
2855: SELECT bet.component_sequence_id, bet.component_item_revision_id revision_id,
2856: mir.revision revision FROM bom_explosions_all bet, mtl_item_revisions_b mir
2857: WHERE bet.group_id = p_group_id AND bet.plan_level <> 0 AND nvl(bet.component_item_revision_id,0) <> 0
2858: AND bet.component_item_revision_id = mir.revision_id;
2859:
2860: CURSOR getFixedRevDetails (p_group_id IN NUMBER) IS

Line 2882: FROM bom_explosions_all bet, Mtl_Item_Revisions_B rev2 , Mtl_Item_Revisions_B rev1

2878: NVL( MIN(rev2.Effectivity_Date - 1/(60*60*24)),
2879: GREATEST(TO_DATE('9999/12/31 00:00:00','yyyy/mm/dd hh24:mi:ss'), reV1.Effectivity_Date)
2880: ) High_Date,
2881: rev1.Implementation_Date, rev1.Change_Notice, rev1.revision_label
2882: FROM bom_explosions_all bet, Mtl_Item_Revisions_B rev2 , Mtl_Item_Revisions_B rev1
2883: WHERE bet.group_id = p_group_id AND bet.component_item_revision_id IS NOT NULL AND
2884: rev1.revision_id = bet.component_item_revision_id AND rev1.Organization_Id = rev2.Organization_Id(+)
2885: AND rev1.Inventory_Item_Id = rev2.Inventory_Item_Id(+) AND rev2.Effectivity_Date(+) > rev1.Effectivity_Date
2886: AND rev2.implementation_date (+) IS NOT NULL

Line 2904: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;

2900: nvl(BE.component_item_revision_id,BOM_EXPLODER_PUB.Get_Current_Revision_Id) REVISION_ID,
2901: --nvl(BE.revision_label,
2902: BOM_EXPLODER_PUB.Get_Current_Revision_Label revision_label,
2903: BE.new_component_code component_code
2904: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;
2905:
2906: CURSOR revTableWithAccessFlag (p_group_id IN NUMBER) IS
2907: SELECT nvl(BE.component_sequence_id,0) component_sequence_id, nvl(BE.current_revision,
2908: BOM_EXPLODER_PUB.Get_Current_RevisionDetails(BE.component_item_id,

Line 2926: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;

2922: NULL,
2923: NULL,
2924: NULL,
2925: BOM_EXPLODER_PUB.Get_EGO_User) ACCESS_FLAG
2926: FROM bom_explosions_all BE WHERE BE.group_id = p_group_id;
2927:
2928:
2929: CURSOR changePolicy (p_group_id IN NUMBER) IS
2930: SELECT

Line 2938: FROM bom_explosions_all bet, mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi

2934: NVL(mirb.current_phase_id , msi.current_phase_id) AS phase_id,
2935: msi.item_catalog_group_id item_catalog_group_id,
2936: msi.inventory_item_id, msi.organization_id , mirb.revision_id,
2937: bet.component_sequence_id, bet.structure_type_id
2938: FROM bom_explosions_all bet, mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2939: WHERE bet.group_id = p_group_id AND bet.comp_bill_seq_id IS NOT NULL
2940: AND bet.component_item_id = msi.INVENTORY_ITEM_ID AND
2941: bet.organization_id = msi.ORGANIZATION_ID AND
2942: mirb.revision_id = BOM_EXPLODER_PUB.Get_Component_Revision_Id(NVL(BET.component_sequence_id,0))

Line 3290: FROM BOM_EXPLOSIONS_ALL

3286: , l_exploded_option
3287: , l_explosion_group_id
3288: , l_reapply_exclusions
3289: , l_max_bill_level
3290: FROM BOM_EXPLOSIONS_ALL
3291: WHERE top_bill_sequence_id = l_bill_sequence_id
3292: AND exploded_option = l_explode_option
3293: AND plan_level = 0;
3294:

Line 3312: UPDATE BOM_EXPLOSIONS_ALL

3308: THEN
3309: l_rexplode_flag := 1;
3310: --set the rexplode flag if max bill level is changed.
3311:
3312: UPDATE BOM_EXPLOSIONS_ALL
3313: SET rexplode_flag = 1
3314: WHERE group_id = grp_id
3315: AND sort_order = '0000001';
3316:

Line 3317: DELETE FROM BOM_EXPLOSIONS_ALL

3313: SET rexplode_flag = 1
3314: WHERE group_id = grp_id
3315: AND sort_order = '0000001';
3316:
3317: DELETE FROM BOM_EXPLOSIONS_ALL
3318: WHERE group_id = grp_id
3319: AND sort_order <> '0000001';
3320:
3321: --Always do an engg explosion for packaging hierarchies

Line 3340: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;

3336: EXCEPTION WHEN NO_DATA_FOUND
3337: THEN
3338: -- Insert for plan level 0
3339:
3340: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;
3341:
3342: insert INTO BOM_EXPLOSIONS_ALL
3343: (
3344: group_id,

Line 3342: insert INTO BOM_EXPLOSIONS_ALL

3338: -- Insert for plan level 0
3339:
3340: SELECT BOM_EXPLOSIONS_ALL_S.NEXTVAL INTO grp_id FROM dual;
3341:
3342: insert INTO BOM_EXPLOSIONS_ALL
3343: (
3344: group_id,
3345: bill_sequence_id,
3346: common_bill_sequence_id,

Line 3447: insert INTO BOM_EXPLOSIONS_ALL

3443: FROM bom_structures_b bom
3444: where bill_sequence_id = l_bill_sequence_id);
3445:
3446: IF (SQL%NOTFOUND) THEN
3447: insert INTO BOM_EXPLOSIONS_ALL
3448: (
3449: group_id,
3450: top_item_id,
3451: component_item_id,

Line 3672: UPDATE BOM_EXPLOSIONS_ALL

3668: ELSE
3669:
3670: /* Reexplode otherwise */
3671:
3672: UPDATE BOM_EXPLOSIONS_ALL
3673: SET rexplode_flag = 1
3674: WHERE group_id = grp_id
3675: AND sort_order = '0000001';
3676:

Line 3677: DELETE FROM BOM_EXPLOSIONS_ALL

3673: SET rexplode_flag = 1
3674: WHERE group_id = grp_id
3675: AND sort_order = '0000001';
3676:
3677: DELETE FROM BOM_EXPLOSIONS_ALL
3678: WHERE group_id = grp_id
3679: AND sort_order <> '0000001';
3680:
3681: --Commit;

Line 3712: DELETE FROM BOM_EXPLOSIONS_ALL

3708:
3709: l_dirty_node_exists := 'Y';
3710:
3711: --Dbms_Output.put_line('Clean up the dirty nodes before the explosion : '||r1.sort_order);
3712: DELETE FROM BOM_EXPLOSIONS_ALL
3713: WHERE group_id = grp_id
3714: AND sort_order like r1.sort_order||'%' AND sort_order <> r1.sort_order;
3715:
3716: --Update the change_policy value for the leaf component that has become a subassembly.

Line 3717: UPDATE BOM_EXPLOSIONS_ALL

3713: WHERE group_id = grp_id
3714: AND sort_order like r1.sort_order||'%' AND sort_order <> r1.sort_order;
3715:
3716: --Update the change_policy value for the leaf component that has become a subassembly.
3717: UPDATE BOM_EXPLOSIONS_ALL
3718: SET CHANGE_POLICY_VALUE = Get_Change_Policy_Val(0, r1.comp_bill_seq_id)
3719: WHERE sort_order = r1.sort_order
3720: AND group_id = grp_id;
3721:

Line 3741: UPDATE BOM_EXPLOSIONS_ALL

3737: END IF;
3738:
3739: ELSE
3740:
3741: UPDATE BOM_EXPLOSIONS_ALL
3742: SET exploded_date = l_rev_date,
3743: exploded_unit_number = unit_number,
3744: --exploded_unit_number = l_unit_number,
3745: exploded_end_item_rev = l_end_item_revision_id,

Line 3763: UPDATE BOM_EXPLOSIONS_ALL

3759: END IF;
3760:
3761: ELSE
3762:
3763: UPDATE BOM_EXPLOSIONS_ALL
3764: SET exploded_date = l_rev_date,
3765: exploded_unit_number = unit_number,
3766: --exploded_unit_number = l_unit_number,
3767: exploded_end_item_rev = l_end_item_revision_id,

Line 3810: UPDATE BOM_EXPLOSIONS_ALL

3806:
3807: /* Get the BOM item type and Parent BOM item type for item BOM */
3808:
3809: /*
3810: UPDATE BOM_EXPLOSIONS_ALL
3811: SET access_flag = l_access_flag,
3812: (bom_item_type, parent_bom_item_type, primary_uom_code, eng_item_flag, primary_unit_of_measure) = (SELECT msi.bom_item_type, msi.bom_item_type, msi.primary_uom_code,
3813: msi.eng_item_flag, (select description from mtl_units_of_measure where uom_code = msi.primary_uom_code) FROM
3814: mtl_system_items_b msi WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id)

Line 3819: UPDATE BOM_EXPLOSIONS_ALL

3815: WHERE group_id = grp_id
3816: AND sort_order = '0000001';
3817: */
3818:
3819: UPDATE BOM_EXPLOSIONS_ALL
3820: SET access_flag = l_access_flag,
3821: (bom_item_type, parent_bom_item_type, primary_uom_code, eng_item_flag, primary_unit_of_measure) = (SELECT msi.bom_item_type, msi.bom_item_type, msi.primary_uom_code,
3822: msi.eng_item_flag, muom.unit_of_measure FROM mtl_system_items_b msi, mtl_units_of_measure muom
3823: WHERE msi.inventory_item_id = item_id AND msi.organization_id = org_id AND muom.uom_code = msi.primary_uom_code)

Line 3831: UPDATE BOM_EXPLOSIONS_ALL

3827: IF (SQL%NOTFOUND) THEN
3828: raise no_data_found;
3829: END IF;
3830:
3831: UPDATE BOM_EXPLOSIONS_ALL
3832: SET (gtin_number, gtin_description, trade_item_descriptor, top_gtin_number, top_gtin_description, top_trade_item_descriptor, trade_item_descriptor_desc, gtin_publication_status) =
3833: (SELECT gtin, description, trade_item_descriptor, gtin, description, trade_item_descriptor, trade_item_descriptor_desc, publication_status
3834: FROM ego_items_v egi
3835: WHERE inventory_item_id = item_id AND organization_id = org_id)

Line 3840: UPDATE BOM_EXPLOSIONS_ALL

3836: WHERE group_id = grp_id
3837: AND sort_order = '0000001';
3838:
3839: /* Update the change policy value for the top item */
3840: UPDATE BOM_EXPLOSIONS_ALL
3841: SET CHANGE_POLICY_VALUE = Get_Change_Policy_Val(revision_id, Comp_bill_seq_Id)
3842: WHERE group_id = grp_id
3843: AND sort_order = '0000001';
3844:

Line 3965: UPDATE BOM_EXPLOSIONS_ALL

3961: -- If cost_organization is Master organization THEN the item cost should be
3962: -- calculated by multiplying the conversion_rate.
3963:
3964: IF is_cost_organization <> 'Y' THEN
3965: UPDATE BOM_EXPLOSIONS_ALL
3966: SET item_cost = item_cost*t_conversion_rate
3967: WHERE group_id = cr.curGI and
3968: component_sequence_id = cr.curCSI and
3969: bill_sequence_id = cr.curBSI and

Line 3973: UPDATE BOM_EXPLOSIONS_ALL

3969: bill_sequence_id = cr.curBSI and
3970: common_bill_sequence_id = cr.curCBSI;
3971: END IF;
3972:
3973: UPDATE BOM_EXPLOSIONS_ALL
3974: SET component_quantity = component_quantity/t_conversion_rate,
3975: extended_quantity = extended_quantity/t_conversion_rate,
3976: -- item_cost = item_cost*t_conversion_rate,
3977: primary_uom_code = cr.curPUC,

Line 3996: for c in (select rexplode_flag from BOM_EXPLOSIONS_ALL

3992:
3993: /* insert attachments for level 0 */
3994:
3995: /*
3996: for c in (select rexplode_flag from BOM_EXPLOSIONS_ALL
3997: where group_id = grp_id
3998: and plan_level = 0)
3999: loop
4000: if c.rexplode_flag = 1

Line 4023: DELETE FROM bom_explosions_all

4019: -- recompute the pkg hky attributes (total quantity and qty at next level)
4020: IF l_Pkg_Structure_Type_Id = l_Structure_Type_Id
4021: THEN
4022:
4023: DELETE FROM bom_explosions_all
4024: WHERE group_id = grp_id
4025: AND nvl(trimmed_disable_date, l_rev_date+1) <= l_rev_date;
4026:
4027: UPDATE bom_explosions_all

Line 4027: UPDATE bom_explosions_all

4023: DELETE FROM bom_explosions_all
4024: WHERE group_id = grp_id
4025: AND nvl(trimmed_disable_date, l_rev_date+1) <= l_rev_date;
4026:
4027: UPDATE bom_explosions_all
4028: SET exploded_date = l_rev_date,
4029: object_revision_id = l_item_rev_id,
4030: minor_revision_id = l_minor_rev_id,
4031: revision_id = l_item_rev_id --insert top item's rev id

Line 4036: UPDATE BOM_EXPLOSIONS_ALL BE

4032: --effectivity_date = l_rev_date
4033: WHERE group_id = grp_id
4034: AND sort_order = '0000001';
4035:
4036: UPDATE BOM_EXPLOSIONS_ALL BE
4037: SET (quantity_of_children, total_qty_at_next_level) =
4038: (SELECT count(*), sum(component_quantity) FROM bom_explosions_all
4039: WHERE group_id = BE.group_id AND
4040: parent_sort_order = BE.sort_order)

Line 4038: (SELECT count(*), sum(component_quantity) FROM bom_explosions_all

4034: AND sort_order = '0000001';
4035:
4036: UPDATE BOM_EXPLOSIONS_ALL BE
4037: SET (quantity_of_children, total_qty_at_next_level) =
4038: (SELECT count(*), sum(component_quantity) FROM bom_explosions_all
4039: WHERE group_id = BE.group_id AND
4040: parent_sort_order = BE.sort_order)
4041: WHERE group_id = grp_id AND comp_bill_seq_id IS NOT NULL;
4042:

Line 4050: UPDATE BOM_EXPLOSIONS_ALL

4046:
4047: END IF;
4048: */
4049:
4050: UPDATE BOM_EXPLOSIONS_ALL
4051: SET rexplode_flag = 0
4052: WHERE group_id = grp_id AND comp_bill_seq_id IS NOT NULL AND rexplode_flag = 1;
4053:
4054: -- change made for P4Telco CMR, bug# 8761845

Line 4062: UPDATE BOM_EXPLOSIONS_ALL

4058: --comment for bug10107073
4059: /*
4060: IF ( nvl(levels_to_explode, 60) <> nvl(l_max_bill_level, 60) OR
4061: nvl(std_bom_explode_flag, 'Y') = 'N') THEN
4062: UPDATE BOM_EXPLOSIONS_ALL
4063: SET rexplode_flag = 1
4064: WHERE group_id = grp_id AND comp_bill_seq_id IS NOT NULL AND rexplode_flag = 0;
4065: END IF;
4066: */

Line 4155: EXECUTE IMMEDIATE 'SELECT BE.new_component_code FROM bom_explosions_all BE WHERE BE.group_id = '||grp_id||' AND comp_bill_seq_id IS NOT NULL AND NOT '|| l_predicate

4151: l_internal_user := 'Y';
4152: ELSE
4153: /* Select all the assemblies for which the user has no access */
4154:
4155: EXECUTE IMMEDIATE 'SELECT BE.new_component_code FROM bom_explosions_all BE WHERE BE.group_id = '||grp_id||' AND comp_bill_seq_id IS NOT NULL AND NOT '|| l_predicate
4156: BULK COLLECT INTO asss_without_access_array;
4157: --dbms_output.put_line('assss without access : '||asss_without_access_array.COUNT);
4158:
4159: /* Select all the leaf nodes for which the user has no access */

Line 4161: EXECUTE IMMEDIATE 'SELECT BE.component_sequence_id FROM bom_explosions_all BE WHERE BE.group_id = '||grp_id||' AND comp_bill_seq_id IS NULL AND NOT '|| l_predicate

4157: --dbms_output.put_line('assss without access : '||asss_without_access_array.COUNT);
4158:
4159: /* Select all the leaf nodes for which the user has no access */
4160:
4161: EXECUTE IMMEDIATE 'SELECT BE.component_sequence_id FROM bom_explosions_all BE WHERE BE.group_id = '||grp_id||' AND comp_bill_seq_id IS NULL AND NOT '|| l_predicate
4162: BULK COLLECT INTO compseqs_without_access_array;
4163:
4164: --dbms_output.put_line('comps without access : '||compseqs_without_access_array.COUNT);
4165:

Line 4222: FROM bom_explosions_all be,

4218: /* Bulk collect all the rev specific exclusions into a table */
4219:
4220: SELECT exclusion_path
4221: BULK COLLECT INTO rev_specific_exclusions_array
4222: FROM bom_explosions_all be,
4223: bom_rules_b rule,
4224: bom_exclusion_rule_def excl
4225: WHERE be.group_id = grp_id
4226: AND be.comp_bill_seq_id IS NOT NULL --get only the bills not its components

Line 4246: tabname => 'BOM_EXPLOSIONS_ALL'

4242: FND_STATS.GATHER_TABLE_STATS (
4243: errbuf => out_message,
4244: retcode => out_message,
4245: ownname => 'BOM',
4246: tabname => 'BOM_EXPLOSIONS_ALL'
4247: );
4248: */
4249: --DBMS_PROFILER.STOP_PROFILER;
4250: