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

Line 83: From gme_material_details

79:
80: Cursor get_batch_line (p_batch_id IN NUMBER) IS
81: Select material_detail_id
82: , item_id
83: From gme_material_details
84: where batch_id = p_batch_id
85: and line_type <> -1 -- not ingredient
86: ;
87:

Line 123: From gme_material_details

119:
120: Cursor get_new_batch_line (p_batch_id IN NUMBER
121: , p_item_id IN NUMBER) is
122: Select material_detail_id
123: From gme_material_details
124: Where batch_id = p_batch_id
125: and item_id = p_item_id
126: and line_type <> -1
127: ;

Line 1014: FROM gme_material_details gl,

1010: and reserved_qty <> 0;
1011:
1012: CURSOR get_batch_id_for_line(p_batch_line_id IN NUMBER) Is
1013: SELECT gl.batch_id,gh.batch_type
1014: FROM gme_material_details gl,
1015: gme_batch_header gh
1016: WHERE gl.material_detail_id = p_batch_line_id
1017: and gl.batch_id = gh.batch_id;
1018: