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_REOPEN_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 54: FROM gme_material_details d

50: which are release type of "Automatic by Step" and attached to steps */
51: CURSOR cur_matl_phant_ids (v_batch_id NUMBER)
52: IS
53: SELECT d.phantom_id
54: FROM gme_material_details d
55: WHERE d.batch_id = v_batch_id
56: AND NVL (d.phantom_id, 0) > 0
57: AND NOT EXISTS (
58: SELECT 1

Line 71: l_material_details gme_material_details%ROWTYPE;

67: l_back_flush NUMBER;
68: l_error_count NUMBER;
69: l_row_count NUMBER;
70: l_ins_history gme_batch_history%ROWTYPE;
71: l_material_details gme_material_details%ROWTYPE;
72: l_material_details_tab gme_reopen_batch_pvt.material_details_tab;
73: l_phantom_ids gme_common_pvt.number_tab;
74: l_batch_header gme_batch_header%ROWTYPE;
75: l_in_batch_header gme_batch_header%ROWTYPE;

Line 444: ,gme_material_details md

440: -- See if any of the matl lines has been costed and frozen.
441: SELECT COUNT (1)
442: FROM cm_cmpt_dtl cst
443: ,cm_acst_led aled
444: ,gme_material_details md
445: ,gme_batch_header bh
446: WHERE bh.batch_id = l_batch_id
447: AND bh.batch_id = md.batch_id
448: AND md.material_detail_id = aled.transline_id