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.GME_REROUTE_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 58: FROM gme_material_details

54:
55: CURSOR cur_get_material (v_batch_id NUMBER)
56: IS
57: SELECT material_detail_id, phantom_id
58: FROM gme_material_details
59: WHERE batch_id = v_batch_id;
60:
61: CURSOR get_prim_prod (v_batch_id NUMBER, v_inventory_item_id NUMBER)
62: IS

Line 64: FROM gme_material_details

60:
61: CURSOR get_prim_prod (v_batch_id NUMBER, v_inventory_item_id NUMBER)
62: IS
63: SELECT plan_qty, dtl_um
64: FROM gme_material_details
65: WHERE batch_id = v_batch_id
66: AND inventory_item_id = v_inventory_item_id
67: AND line_type = gme_common_pvt.g_line_type_prod
68: ORDER BY line_no ASC;

Line 71: l_material_detail_rec gme_material_details%ROWTYPE;

67: AND line_type = gme_common_pvt.g_line_type_prod
68: ORDER BY line_no ASC;
69:
70: l_material_detail_ids_tab gme_common_pvt.number_tab;
71: l_material_detail_rec gme_material_details%ROWTYPE;
72: l_return_code NUMBER;
73: l_recipe_id NUMBER;
74: l_temp_qty NUMBER DEFAULT 0;
75: l_message_count NUMBER;

Line 79: l_gme_material_details gme_material_details%ROWTYPE;

75: l_message_count NUMBER;
76: l_message_list VARCHAR2 (1000);
77: l_max_step_date DATE;
78: l_process_parameters_tab gmd_recipe_fetch_pub.recp_resc_proc_param_tbl;
79: l_gme_material_details gme_material_details%ROWTYPE;
80: l_material_details gme_common_pvt.material_details_tab;
81: l_total_output_qty_b NUMBER;
82: l_total_output_qty_c NUMBER;
83: l_phantom_ids_tab gme_common_pvt.number_tab;

Line 244: l_gme_material_details.batch_id := x_batch_header_rec.batch_id;

240: RAISE fnd_api.g_exc_error;
241: END IF;
242:
243: /* Batch Quantities calculation */
244: l_gme_material_details.batch_id := x_batch_header_rec.batch_id;
245: --{
246: IF gme_material_details_dbl.fetch_tab
247: (p_material_detail => l_gme_material_details
248: ,x_material_detail => l_material_details) THEN

Line 246: IF gme_material_details_dbl.fetch_tab

242:
243: /* Batch Quantities calculation */
244: l_gme_material_details.batch_id := x_batch_header_rec.batch_id;
245: --{
246: IF gme_material_details_dbl.fetch_tab
247: (p_material_detail => l_gme_material_details
248: ,x_material_detail => l_material_details) THEN
249: l_total_output_qty_b := 0;
250:

Line 247: (p_material_detail => l_gme_material_details

243: /* Batch Quantities calculation */
244: l_gme_material_details.batch_id := x_batch_header_rec.batch_id;
245: --{
246: IF gme_material_details_dbl.fetch_tab
247: (p_material_detail => l_gme_material_details
248: ,x_material_detail => l_material_details) THEN
249: l_total_output_qty_b := 0;
250:
251: FOR l_row_count IN 1 .. l_material_details.COUNT LOOP

Line 491: IF NOT gme_material_details_dbl.fetch_row(l_material_detail_rec, l_material_detail_rec) THEN

487:
488: IF ( l_phantom_ids_tab (i) IS NOT NULL ) THEN
489: /*Sunitha ch Bug#5391396 included the code to rescedule_step of the child batch when the product
490: is associated to step and its release type is autobystep.*/
491: IF NOT gme_material_details_dbl.fetch_row(l_material_detail_rec, l_material_detail_rec) THEN
492: l_proc := 'gme_material_details_dbl.fetch_row';
493: RAISE error_dbl;
494: END IF;
495: -- IF(l_material_detail_rec.material_requirement_date <> l_db_mtl_dtl_rec.material_requirement_date ) THEN

Line 492: l_proc := 'gme_material_details_dbl.fetch_row';

488: IF ( l_phantom_ids_tab (i) IS NOT NULL ) THEN
489: /*Sunitha ch Bug#5391396 included the code to rescedule_step of the child batch when the product
490: is associated to step and its release type is autobystep.*/
491: IF NOT gme_material_details_dbl.fetch_row(l_material_detail_rec, l_material_detail_rec) THEN
492: l_proc := 'gme_material_details_dbl.fetch_row';
493: RAISE error_dbl;
494: END IF;
495: -- IF(l_material_detail_rec.material_requirement_date <> l_db_mtl_dtl_rec.material_requirement_date ) THEN
496: l_phantom_batch_header_rec.batch_id:= l_phantom_ids_tab (i);

Line 748: FROM gme_material_details

744: v_batch_id IN NUMBER
745: ,v_inventory_item_id IN NUMBER)
746: IS
747: SELECT plan_qty, dtl_um
748: FROM gme_material_details
749: WHERE batch_id = v_batch_id
750: AND line_type = 1
751: AND inventory_item_id = v_inventory_item_id;
752:

Line 756: l_dtl_um gme_material_details.dtl_um%TYPE;

752:
753: l_formula_id NUMBER;
754: l_inventory_item_id NUMBER;
755: l_plan_qty NUMBER;
756: l_dtl_um gme_material_details.dtl_um%TYPE;
757: BEGIN
758: IF (NVL (g_debug, 0) IN
759: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
760: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

Line 901: FROM gme_material_details d

897: ,v_validity_rule_id IN NUMBER)
898: IS
899: SELECT d.inventory_item_id, d.organization_id, d.plan_qty
900: ,d.dtl_um line_um, msib.primary_uom_code item_um
901: FROM gme_material_details d
902: ,mtl_system_items_b msib
903: ,gmd_recipe_validity_rules v
904: WHERE d.batch_id = v_batch_id
905: AND d.line_type = 1