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_PND

Line 156: from ic_tran_pnd

152: return varchar2
153: is
154: cursor prod_cursor is
155: select doc_id
156: from ic_tran_pnd
157: where item_id = fv_item_id and lot_id = fv_lot_id
158: and doc_type = 'PROD' and line_type in (1,2)
159: and completed_ind = 1 and delete_mark = 0
160: group by doc_id

Line 171: from ic_tran_pnd

167: begin
168: select count(*) into lv_ingred_count
169: from (
170: select item_id, lot_id
171: from ic_tran_pnd
172: where doc_type = 'PROD'
173: and doc_id = prod.doc_id
174: and completed_ind = 1
175: and delete_mark = 0

Line 203: from ic_tran_pnd

199: return varchar2
200: is
201: cursor ingred_cursor is
202: select doc_id
203: from ic_tran_pnd
204: where item_id = fv_item_id and lot_id = fv_lot_id
205: and doc_type = 'PROD' and line_type = -1
206: and completed_ind = 1 and delete_mark = 0
207: group by doc_id

Line 218: from ic_tran_pnd

214: begin
215: select count(*) into lv_product_count
216: from (
217: select item_id, lot_id
218: from ic_tran_pnd
219: where doc_type = 'PROD'
220: and doc_id = ingred.doc_id
221: and completed_ind = 1
222: and delete_mark = 0