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_PICK_WAVE_CONFIRM_PVT dependencies on IC_LOTS_STS

Line 401: , ic_lots_sts sts

397: is
398: SELECT SUM(ABS(nvl(trans_qty,0))),SUM(ABS(nvl(trans_qty2,0)))
399: FROM ic_tran_pnd trans
400: , ic_loct_inv lots
401: , ic_lots_sts sts
402: WHERE trans.line_id = p_line_id
403: AND trans.lot_id > 0
404: -- AND trans.item_id = p_item_id -- REMOVED for bug 3403418
405: AND trans.doc_type = 'OMSO'

Line 431: From ic_lots_sts sts

427: p_location IN VARCHAR2)
428: IS
429: Select order_proc_ind
430: , shipping_ind
431: From ic_lots_sts sts
432: , ic_loct_inv inv
433: Where inv.item_id = p_item_id
434: AND inv.whse_code = p_whse_code
435: AND inv.lot_id = p_lot_id

Line 443: , ic_lots_sts sts -- status check

439: CURSOR qty_sum_for_del_sts IS
440: SELECT SUM(ABS(trans_qty)),SUM(ABS(trans_qty2))
441: FROM ic_tran_pnd tran
442: , ic_loct_inv inv -- get status
443: , ic_lots_sts sts -- status check
444: WHERE tran.line_id = l_mo_line_rec.txn_source_line_id
445: AND tran.line_detail_id = l_delivery_detail_id
446: AND tran.delete_mark = 0
447: AND inv.item_id = tran.item_id