APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on IC_LOCT_INV

Line 349: From ic_loct_inv inv

345: p_location IN VARCHAR2)
346: IS
347: Select loct_onhand
348: ,nvl(loct_onhand2,0)
349: From ic_loct_inv inv
350: Where inv.item_id = p_item_id
351: AND inv.whse_code = p_whse_code
352: AND inv.lot_id = p_lot_id
353: AND inv.location = p_location;

Line 400: , ic_loct_inv lots

396: p_mo_line_id NUMBER)
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

Line 432: , ic_loct_inv inv

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
436: AND inv.location = p_location

Line 442: , ic_loct_inv inv -- get status

438: ;
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

Line 2513: FROM ic_loct_inv

2509: IS
2510:
2511: CURSOR loct_onhand_CUR IS
2512: SELECT loct_onhand , loct_onhand2
2513: FROM ic_loct_inv
2514: WHERE whse_code = p_whse_code
2515: AND item_id = p_item_id
2516: AND lot_id = 0
2517: AND location = GMI_RESERVATION_UTIL.G_DEFAULT_LOCT