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_LOT_TRACE_PKG dependencies on IC_TRAN_CMP

Line 249: from ic_tran_cmp

245: return varchar2
246: is
247: cursor prod_cursor is
248: select doc_id
249: from ic_tran_cmp
250: where item_id = fv_item_id and lot_id = fv_lot_id
251: and doc_type = 'PROD' and line_type in (1,2)
252: group by doc_id
253: having sum(trans_qty) > 0;

Line 263: from ic_tran_cmp

259: begin
260: select count(*) into lv_ingred_count
261: from (
262: select item_id, lot_id
263: from ic_tran_cmp
264: where doc_type = 'PROD'
265: and doc_id = prod.doc_id
266: and lot_id <> 0
267: and line_type = -1

Line 293: from ic_tran_cmp

289: return varchar2
290: is
291: cursor ingred_cursor is
292: select doc_id
293: from ic_tran_cmp
294: where item_id = fv_item_id and lot_id = fv_lot_id
295: and doc_type = 'PROD' and line_type = -1
296: group by doc_id
297: having sum(trans_qty) < 0;

Line 307: from ic_tran_cmp

303: begin
304: select count(*) into lv_product_count
305: from (
306: select item_id, lot_id
307: from ic_tran_cmp
308: where doc_type = 'PROD'
309: and doc_id = ingred.doc_id
310: and lot_id <> 0
311: and line_type in (1,2)