APPS.GME_CLOSE_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 86: FROM gme_material_details d, gme_batch_header h

82: /* Get only the phantom ingredients which are not close already */
83: CURSOR cur_get_phant
84: IS
85: SELECT phantom_id
86: FROM gme_material_details d, gme_batch_header h
87: WHERE d.batch_id = x_batch_header_rec.batch_id
88: AND phantom_id IS NOT NULL
89: AND h.batch_id = d.phantom_id
90: AND h.batch_status <> 4;

Line 95: FROM gme_material_details

91:
92: CURSOR cur_lock_material_lines (v_batch_id NUMBER)
93: IS
94: SELECT material_detail_id
95: FROM gme_material_details
96: WHERE batch_id = v_batch_id
97: FOR UPDATE OF actual_qty NOWAIT;
98:
99: CURSOR cur_gme_batch_steps

Line 109: FROM gme_material_details

105: /* siva FPbug#4684029 */
106: CURSOR cur_get_prod (v_batch_id NUMBER)
107: IS
108: SELECT *
109: FROM gme_material_details
110: WHERE batch_id = v_batch_id
111: AND line_type = 1;
112: BEGIN
113: IF g_debug <= gme_debug.g_log_procedure THEN

Line 334: IF NOT gme_material_details_dbl.update_row(l_product_rec) THEN

330: /* dynamic cost factor is ratio of actual qty to total product qty */
331: l_product_rec.cost_alloc := l_qty/l_total_actual_output;
332:
333: /* updating the material detail record with new cost factor*/
334: IF NOT gme_material_details_dbl.update_row(l_product_rec) THEN
335: RAISE MATERIAL_DETAIL_UPD_ERR;
336: END IF;
337: END LOOP;
338: END IF;

Line 466: FROM gme_material_details

462: SELECT step_close_date
463: FROM gme_batch_steps
464: WHERE batch_id IN (
465: SELECT DISTINCT batch_id
466: FROM gme_material_details
467: START WITH batch_id =
468: p_batch_header_rec.batch_id
469: CONNECT BY batch_id = PRIOR phantom_id)
470: AND NVL (step_close_date, p_batch_header_rec.batch_close_date) >

Line 476: FROM gme_material_details

472:
473: CURSOR cur_get_batches (v_batch_id NUMBER)
474: IS
475: SELECT DISTINCT batch_id
476: FROM gme_material_details
477: START WITH batch_id = v_batch_id
478: CONNECT BY batch_id = PRIOR phantom_id;
479:
480: x_batch_tbl gme_common_pvt.number_tab;

Line 520: from gme_material_details

516: against the transactions of the materials in a batch */
517: CURSOR cur_get_materials(v_batch_id NUMBER)
518: IS
519: SELECT material_detail_id
520: from gme_material_details
521: WHERE batch_id = v_batch_id;
522:
523:
524: CURSOR cur_inventory_txns (v_mat_det_id NUMBER, v_batch_id NUMBER,

Line 548: FROM gme_material_details

544: SELECT actual_cmplt_date
545: FROM gme_batch_header
546: WHERE batch_id IN (
547: SELECT DISTINCT batch_id
548: FROM gme_material_details
549: START WITH batch_id =
550: p_batch_header_rec.batch_id
551: CONNECT BY batch_id = PRIOR phantom_id)
552: AND NVL (actual_cmplt_date, p_batch_header_rec.batch_close_date) >