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.GMI_ERES_UTILS dependencies on IC_LOTS_MST

Line 140: FROM ic_lots_mst

136: plot_no OUT NOCOPY VARCHAR2) IS
137:
138: CURSOR get_lot_no IS
139: SELECT lot_no
140: FROM ic_lots_mst
141: WHERE lot_id = plot_id AND
142: item_id = pitem_id;
143:
144: BEGIN

Line 163: FROM ic_lots_mst

159: psublot_no OUT NOCOPY VARCHAR2) IS
160:
161: CURSOR get_sublot_no IS
162: SELECT sublot_no
163: FROM ic_lots_mst
164: WHERE lot_id = plot_id AND
165: item_id = pitem_id;
166:
167: BEGIN

Line 186: FROM ic_lots_mst

182: plot_desc OUT NOCOPY VARCHAR2) IS
183:
184: CURSOR get_lot_desc IS
185: SELECT lot_desc
186: FROM ic_lots_mst
187: WHERE lot_id = plot_id AND
188: item_id = pitem_id;
189:
190: BEGIN