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

Line 359: then no transactions will be inserted in ic_tran_cmp table.

355: Added the code for picking the correct lot_ststaus
356: from the corresponding period.
357: The lot_status is fetched from ic_adjs_jnl table in the
358: query because if the item's status control is of type 2
359: then no transactions will be inserted in ic_tran_cmp table.
360: It is not required to use doc_type in the where clause
361: because for TRNI and TRNR also based on the value of profile
362: option IC$MOVEDIFFSTAT the status might change.
363: ======================================================*/

Line 474: FROM ic_tran_cmp c, ic_item_mst_b m

470: SELECT c.item_id, lot_id, whse_code,
471: location, doc_type, line_type,
472: reason_code, trans_date, trans_id,
473: trans_qty, trans_qty2
474: FROM ic_tran_cmp c, ic_item_mst_b m
475: WHERE whse_code = uwhse_code
476: AND trans_date >= pprd_start_date
477: AND c.creation_date <= l_log_end_date
478: AND trans_qty <> 0