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_ADJS_JNL

Line 357: The lot_status is fetched from ic_adjs_jnl table in the

353:
354: BUG#2355980 VRA Srinivas 24-Jun-2002.
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

Line 435: FROM ic_adjs_jnl

431:
432: Cursor lot_status_cur (x_item_id Number,x_lot_id Number,x_location varchar2,x_whse_code varchar2)
433: IS
434: SELECT lot_status
435: FROM ic_adjs_jnl
436: WHERE line_id = (select max(line_id) from ic_adjs_jnl
437: WHERE item_id = x_item_id
438: AND lot_id = x_lot_id
439: AND location = x_location

Line 436: WHERE line_id = (select max(line_id) from ic_adjs_jnl

432: Cursor lot_status_cur (x_item_id Number,x_lot_id Number,x_location varchar2,x_whse_code varchar2)
433: IS
434: SELECT lot_status
435: FROM ic_adjs_jnl
436: WHERE line_id = (select max(line_id) from ic_adjs_jnl
437: WHERE item_id = x_item_id
438: AND lot_id = x_lot_id
439: AND location = x_location
440: AND whse_code = x_whse_code