APPS.WSM_JOBCOPIES_PVT dependencies on BOM_EXPLOSION_TEMP

Line 612: BOM_EXPLOSION_TEMP BE

608: a.attribute15
609: FROM WSM_COPY_OPERATIONS O,
610: BOM_INVENTORY_COMPONENTS A,
611: MTL_SYSTEM_ITEMS C,
612: BOM_EXPLOSION_TEMP BE
613: WHERE be.group_id = l_explosion_group_id
614: AND be.top_bill_sequence_id = l_top_level_bill_seq_id
615: AND a.component_sequence_id = be.component_sequence_id
616: AND be.component_item_id = c.inventory_item_id

Line 826: BOM_EXPLOSION_TEMP BE

822: FROM WSM_COPY_OPERATIONS O,
823: BOM_INVENTORY_COMPONENTS A,
824: BOM_SUBSTITUTE_COMPONENTS S,
825: MTL_SYSTEM_ITEMS C,
826: BOM_EXPLOSION_TEMP BE
827: WHERE BE.GROUP_ID=l_explosion_group_id
828: AND BE.TOP_BILL_SEQUENCE_ID = l_top_level_bill_seq_id
829: AND A.COMPONENT_SEQUENCE_ID=BE.COMPONENT_SEQUENCE_ID
830: AND S.COMPONENT_SEQUENCE_ID = A.COMPONENT_SEQUENCE_ID

Line 1115: BOM_EXPLOSION_TEMP_S.nextval -- Added here for performance improvement

1111:
1112: BEGIN
1113: SELECT nvl(use_phantom_routings, 0),
1114: nvl(maximum_bom_level, 60),
1115: BOM_EXPLOSION_TEMP_S.nextval -- Added here for performance improvement
1116: INTO l_use_phantom_routings,
1117: l_max_bill_levels,
1118: l_explosion_group_id
1119: FROM BOM_PARAMETERS

Line 2687: FROM BOM_EXPLOSION_TEMP

2683:
2684: IF (g_debug = 'Y') THEN
2685: SELECT count(*)
2686: INTO l_be_count
2687: FROM BOM_EXPLOSION_TEMP
2688: WHERE group_id = l_explosion_group_id;
2689:
2690: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2691: ' l_explosion_group_id ='||l_explosion_group_id||

Line 2830: SELECT BOM_EXPLOSION_TEMP_S.nextval

2826:
2827: l_stmt_num := 200;
2828:
2829:
2830: SELECT BOM_EXPLOSION_TEMP_S.nextval
2831: INTO l_phantom_expl_group_id
2832: FROM DUAL;
2833:
2834: l_stmt_num := 210;

Line 2878: FROM BOM_EXPLOSION_TEMP

2874:
2875: IF (g_debug = 'Y') THEN
2876: SELECT count(*)
2877: INTO l_be_count
2878: FROM BOM_EXPLOSION_TEMP
2879: WHERE group_id = l_phantom_expl_group_id;
2880:
2881: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2882: ' l_phantom_expl_group_id ='||l_phantom_expl_group_id||

Line 2901: FROM bom_explosion_temp

2897: l_stmt_num := 210;
2898:
2899: SELECT max(plan_level)
2900: INTO l_phantom_bill_levels
2901: FROM bom_explosion_temp
2902: WHERE top_bill_sequence_id = l_phantom_bill_seq_id;
2903:
2904: FOR l_level in 1..l_phantom_bill_levels
2905: LOOP

Line 2908: UPDATE bom_explosion_temp be

2904: FOR l_level in 1..l_phantom_bill_levels
2905: LOOP
2906: l_stmt_num := 220;
2907:
2908: UPDATE bom_explosion_temp be
2909: SET be.primary_path_flag=1
2910: WHERE be.top_bill_sequence_id=l_phantom_bill_seq_id
2911: AND be.group_id=l_phantom_expl_group_id --l_explosion_group_id
2912: AND ((be.operation_seq_num=1)

Line 2943: FROM bom_explosion_temp be1

2939: AND plan_level=l_level
2940: AND ((plan_level=1)
2941: OR (exists
2942: (SELECT 'x'
2943: FROM bom_explosion_temp be1
2944: WHERE be1.top_bill_sequence_id =
2945: l_phantom_bill_seq_id
2946: AND be1.group_id =
2947: l_phantom_expl_group_id --l_explosion_group_id

Line 2964: UPDATE bom_explosion_temp be

2960: END;
2961: ELSE
2962:
2963: l_stmt_num := 230;
2964: UPDATE bom_explosion_temp be
2965: SET be.primary_path_flag=1
2966: WHERE be.top_bill_sequence_id = l_phantom_bill_seq_id;
2967:
2968: END IF;

Line 3133: BOM_EXPLOSION_TEMP BE

3129: a.attribute14,
3130: a.attribute15
3131: FROM BOM_INVENTORY_COMPONENTS A,
3132: MTL_SYSTEM_ITEMS C,
3133: BOM_EXPLOSION_TEMP BE
3134: WHERE BE.GROUP_ID = l_phantom_expl_group_id--l_explosion_group_id
3135: AND A.COMPONENT_SEQUENCE_ID = BE.COMPONENT_SEQUENCE_ID
3136: AND C.INVENTORY_ITEM_ID = BE.COMPONENT_ITEM_ID
3137: AND C.ORGANIZATION_ID = p_org_id