DBA Data[Home] [Help]

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 1114: BOM_EXPLOSION_TEMP_S.nextval -- Added here for performance improvement

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

Line 2455: FROM BOM_EXPLOSION_TEMP

2451:
2452: IF (g_debug = 'Y') THEN
2453: SELECT count(*)
2454: INTO l_be_count
2455: FROM BOM_EXPLOSION_TEMP
2456: WHERE group_id = l_explosion_group_id;
2457:
2458: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2459: ' l_explosion_group_id ='||l_explosion_group_id||

Line 2599: SELECT BOM_EXPLOSION_TEMP_S.nextval

2595:
2596: l_stmt_num := 200;
2597:
2598:
2599: SELECT BOM_EXPLOSION_TEMP_S.nextval
2600: INTO l_phantom_expl_group_id
2601: FROM DUAL;
2602:
2603: l_stmt_num := 210;

Line 2647: FROM BOM_EXPLOSION_TEMP

2643:
2644: IF (g_debug = 'Y') THEN
2645: SELECT count(*)
2646: INTO l_be_count
2647: FROM BOM_EXPLOSION_TEMP
2648: WHERE group_id = l_phantom_expl_group_id;
2649:
2650: fnd_file.put_line(fnd_file.log, 'At stmt('||l_stmt_num||'): '||
2651: ' l_phantom_expl_group_id ='||l_phantom_expl_group_id||

Line 2670: FROM bom_explosion_temp

2666: l_stmt_num := 210;
2667:
2668: SELECT max(plan_level)
2669: INTO l_phantom_bill_levels
2670: FROM bom_explosion_temp
2671: WHERE top_bill_sequence_id = l_phantom_bill_seq_id;
2672:
2673: FOR l_level in 1..l_phantom_bill_levels
2674: LOOP

Line 2677: UPDATE bom_explosion_temp be

2673: FOR l_level in 1..l_phantom_bill_levels
2674: LOOP
2675: l_stmt_num := 220;
2676:
2677: UPDATE bom_explosion_temp be
2678: SET be.primary_path_flag=1
2679: WHERE be.top_bill_sequence_id=l_phantom_bill_seq_id
2680: AND be.group_id=l_phantom_expl_group_id --l_explosion_group_id
2681: AND ((be.operation_seq_num=1)

Line 2712: FROM bom_explosion_temp be1

2708: AND plan_level=l_level
2709: AND ((plan_level=1)
2710: OR (exists
2711: (SELECT 'x'
2712: FROM bom_explosion_temp be1
2713: WHERE be1.top_bill_sequence_id =
2714: l_phantom_bill_seq_id
2715: AND be1.group_id =
2716: l_phantom_expl_group_id --l_explosion_group_id

Line 2733: UPDATE bom_explosion_temp be

2729: END;
2730: ELSE
2731:
2732: l_stmt_num := 230;
2733: UPDATE bom_explosion_temp be
2734: SET be.primary_path_flag=1
2735: WHERE be.top_bill_sequence_id = l_phantom_bill_seq_id;
2736:
2737: END IF;

Line 2902: BOM_EXPLOSION_TEMP BE

2898: a.attribute14,
2899: a.attribute15
2900: FROM BOM_INVENTORY_COMPONENTS A,
2901: MTL_SYSTEM_ITEMS C,
2902: BOM_EXPLOSION_TEMP BE
2903: WHERE BE.GROUP_ID = l_phantom_expl_group_id--l_explosion_group_id
2904: AND A.COMPONENT_SEQUENCE_ID = BE.COMPONENT_SEQUENCE_ID
2905: AND C.INVENTORY_ITEM_ID = BE.COMPONENT_ITEM_ID
2906: AND C.ORGANIZATION_ID = p_org_id