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_MIXED_MODEL_MAP_PVT dependencies on BOM_MIXED_MODEL_MAP_PROCESSES

Line 315: -- BOM_MIXED_MODEL_MAP_PROCESSES.

311: -- NAME : GetProcessLineOp
312: -- DESCRIPTION: Get Processes or Line Operations for a given Line
313: -- (and Family if the Family is specified by the user).
314: -- Insert these values into the table
315: -- BOM_MIXED_MODEL_MAP_PROCESSES.
316: -- REQUIRES : err_text out buffer to return error message
317: -- MODIFIES : BOM_MIXED_MODEL_MAP_PROCESSES
318: --
319: -- ==========================================================================

Line 317: -- MODIFIES : BOM_MIXED_MODEL_MAP_PROCESSES

313: -- (and Family if the Family is specified by the user).
314: -- Insert these values into the table
315: -- BOM_MIXED_MODEL_MAP_PROCESSES.
316: -- REQUIRES : err_text out buffer to return error message
317: -- MODIFIES : BOM_MIXED_MODEL_MAP_PROCESSES
318: --
319: -- ==========================================================================
320:
321: PROCEDURE GetProcessLineOp (

Line 403: INSERT INTO bom_mixed_model_map_processes

399: l_seq_id := 1;
400: END IF;
401:
402: l_stmt_num := 3;
403: INSERT INTO bom_mixed_model_map_processes
404: (MIXED_MODEL_MAP_ID,
405: GROUP_NUMBER,
406: SEQUENCE_ID,
407: OPERATION_CODE,

Line 435: INSERT INTO bom_mixed_model_map_processes

431: l_seq_id := 1;
432: END IF;
433:
434: l_stmt_num := 3;
435: INSERT INTO bom_mixed_model_map_processes
436: (MIXED_MODEL_MAP_ID,
437: GROUP_NUMBER,
438: SEQUENCE_ID,
439: OPERATION_CODE,

Line 2675: FROM bom_mixed_model_map_processes

2671: DECLARE
2672: CURSOR GetSavedValues IS
2673: SELECT machines_needed MN, labor_needed LN,
2674: in_process_kanban IPK
2675: FROM bom_mixed_model_map_processes
2676: WHERE mixed_model_map_id = l_mmm_id
2677: AND operation_code = p_op_code1;
2678: BEGIN
2679: l_stmt_num := 72;

Line 2699: FROM bom_mixed_model_map_processes

2695: DECLARE
2696: CURSOR GetSavedValues IS
2697: SELECT machines_needed MN, labor_needed LN,
2698: in_process_kanban IPK
2699: FROM bom_mixed_model_map_processes
2700: WHERE mixed_model_map_id = l_mmm_id
2701: AND operation_code = p_op_code2;
2702: BEGIN
2703: l_stmt_num := 73;

Line 2723: FROM bom_mixed_model_map_processes

2719: DECLARE
2720: CURSOR GetSavedValues IS
2721: SELECT machines_needed MN, labor_needed LN,
2722: in_process_kanban IPK
2723: FROM bom_mixed_model_map_processes
2724: WHERE mixed_model_map_id = l_mmm_id
2725: AND operation_code = p_op_code3;
2726: BEGIN
2727: l_stmt_num := 74;

Line 2747: FROM bom_mixed_model_map_processes

2743: DECLARE
2744: CURSOR GetSavedValues IS
2745: SELECT machines_needed MN, labor_needed LN,
2746: in_process_kanban IPK
2747: FROM bom_mixed_model_map_processes
2748: WHERE mixed_model_map_id = l_mmm_id
2749: AND operation_code = p_op_code4;
2750: BEGIN
2751: l_stmt_num := 75;

Line 2771: FROM bom_mixed_model_map_processes

2767: DECLARE
2768: CURSOR GetSavedValues IS
2769: SELECT machines_needed MN, labor_needed LN,
2770: in_process_kanban IPK
2771: FROM bom_mixed_model_map_processes
2772: WHERE mixed_model_map_id = l_mmm_id
2773: AND operation_code = p_op_code5;
2774: BEGIN
2775: l_stmt_num := 76;

Line 2938: UPDATE bom_mixed_model_map_processes

2934: l_ipk_delta5 := nvl(l_ipk5, 0) - l_ipk_saved5;
2935:
2936: -- UPDATE PROCESSES TABLE
2937: --below code changed slightly
2938: UPDATE bom_mixed_model_map_processes
2939: SET machine_weighted_time = ROUND(nvl(l_machine_wt1, 0), G_DECIMAL),
2940: labor_weighted_time = ROUND(nvl(l_labor_wt1, 0), G_DECIMAL),
2941: total_weighted_time = ROUND(nvl(l_total_wt1, 0), G_DECIMAL),
2942: machines_needed = ROUND(nvl(l_machines_needed1, 0), G_DECIMAL),

Line 2957: UPDATE bom_mixed_model_map_processes

2953: AND group_number = p_group_number
2954: AND sequence_id = 1 ;
2955:
2956: l_stmt_num := 79;
2957: UPDATE bom_mixed_model_map_processes
2958: SET machine_weighted_time = ROUND(nvl(l_machine_wt2, 0), G_DECIMAL),
2959: labor_weighted_time = ROUND(nvl(l_labor_wt2, 0), G_DECIMAL),
2960: total_weighted_time = ROUND(nvl(l_total_wt2, 0), G_DECIMAL),
2961: machines_needed = ROUND(nvl(l_machines_needed2, 0), G_DECIMAL),

Line 2976: UPDATE bom_mixed_model_map_processes

2972: AND group_number = p_group_number
2973: AND sequence_id = 2 ;
2974:
2975: l_stmt_num := 80;
2976: UPDATE bom_mixed_model_map_processes
2977: SET machine_weighted_time = ROUND(nvl(l_machine_wt3, 0), G_DECIMAL),
2978: labor_weighted_time = ROUND(nvl(l_labor_wt3, 0), G_DECIMAL),
2979: total_weighted_time = ROUND(nvl(l_total_wt3, 0), G_DECIMAL),
2980: machines_needed = ROUND(nvl(l_machines_needed3, 0), G_DECIMAL),

Line 2995: UPDATE bom_mixed_model_map_processes

2991: AND group_number = p_group_number
2992: AND sequence_id = 3 ;
2993:
2994: l_stmt_num := 81;
2995: UPDATE bom_mixed_model_map_processes
2996: SET machine_weighted_time = ROUND(nvl(l_machine_wt4, 0), G_DECIMAL),
2997: labor_weighted_time = ROUND(nvl(l_labor_wt4, 0), G_DECIMAL),
2998: total_weighted_time = ROUND(nvl(l_total_wt4, 0), G_DECIMAL),
2999: machines_needed = ROUND(nvl(l_machines_needed4, 0), G_DECIMAL),

Line 3014: UPDATE bom_mixed_model_map_processes

3010: AND group_number = p_group_number
3011: AND sequence_id = 4 ;
3012:
3013: l_stmt_num := 82;
3014: UPDATE bom_mixed_model_map_processes
3015: SET machine_weighted_time = ROUND(nvl(l_machine_wt5, 0), G_DECIMAL),
3016: labor_weighted_time = ROUND(nvl(l_labor_wt5, 0), G_DECIMAL),
3017: total_weighted_time = ROUND(nvl(l_total_wt5, 0), G_DECIMAL),
3018: machines_needed = ROUND(nvl(l_machines_needed5, 0), G_DECIMAL),