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.GML_MOBILE_MOVE_ORDER dependencies on IC_LOCT_INV

Line 325: from ic_loct_inv inv, ic_loct_mst loc

321: IF l_loct_ctl <> 2 THEN
322:
323: OPEN x_location_lov FOR
324: select distinct inv.location, NVL(loc.loct_desc, inv.location)
325: from ic_loct_inv inv, ic_loct_mst loc
326: where inv.whse_code = p_whse_code and inv.delete_mark = 0 and
327: inv.location like (p_location)
328: and inv.lot_id = nvl(l_lot_id,inv.lot_id)
329: and inv.loct_onhand > 0

Line 336: from ic_loct_inv inv, ic_loct_mst loc

332: ELSE
333:
334: OPEN x_location_lov FOR
335: select distinct inv.location, NVL(loc.loct_desc, inv.location)
336: from ic_loct_inv inv, ic_loct_mst loc
337: where inv.whse_code = p_whse_code and inv.delete_mark = 0 and
338: inv.location like (p_location)
339: and inv.lot_id = nvl(l_lot_id,inv.lot_id)
340: and inv.loct_onhand > 0

Line 351: from ic_loct_inv inv, ic_loct_mst loc

347: IF l_loct_ctl <> 2 THEN
348:
349: OPEN x_location_lov FOR
350: select distinct inv.location, NVL(loc.loct_desc, inv.location)
351: from ic_loct_inv inv, ic_loct_mst loc
352: where inv.whse_code = p_whse_code and inv.delete_mark = 0 and
353: inv.location like (p_location)
354: and inv.lot_id = nvl(l_lot_id,inv.lot_id)
355: and inv.item_id = p_item_id

Line 361: from ic_loct_inv inv, ic_loct_mst loc

357: ELSE
358:
359: OPEN x_location_lov FOR
360: select distinct inv.location, NVL(loc.loct_desc, inv.location)
361: from ic_loct_inv inv, ic_loct_mst loc
362: where inv.whse_code = p_whse_code and inv.delete_mark = 0 and
363: inv.location like (p_location)
364: and inv.lot_id = nvl(l_lot_id,inv.lot_id)
365: and inv.item_id = p_item_id

Line 404: from ic_lots_mst a, ic_loct_inv b

400:
401:
402: OPEN x_lot_lov FOR
403: select distinct lot_no,sublot_no, a.lot_id,a.qc_grade, b.lot_status
404: from ic_lots_mst a, ic_loct_inv b
405: where a.lot_no like (p_lot_no) and a.lot_id <> 0 and a.lot_id =b.lot_id and a.item_id = b.item_id and
406: a.delete_mark = 0 and b.delete_mark = 0 and a.item_id = p_item_id and
407: b.whse_code = p_whse_code and b.location = nvl(l_location,b.location)
408: and b.loct_onhand > 0 and a.expire_date >= sysdate

Line 415: from ic_lots_mst a, ic_loct_inv b

411: ELSE
412:
413: OPEN x_lot_lov FOR
414: select distinct lot_no,sublot_no, a.lot_id,a.qc_grade, b.lot_status
415: from ic_lots_mst a, ic_loct_inv b
416: where a.lot_no like (p_lot_no) and a.lot_id <> 0 and a.lot_id =b.lot_id and a.item_id = b.item_id and
417: a.delete_mark = 0 and b.delete_mark = 0 and a.item_id = p_item_id and
418: b.whse_code = p_whse_code and b.location = nvl(l_location,b.location)
419: and a.qc_grade = l_pref_grade

Line 431: from ic_lots_mst a, ic_loct_inv b

427: IF l_pref_grade IS NULL THEN
428:
429: OPEN x_lot_lov FOR
430: select distinct lot_no,sublot_no, a.lot_id,a.qc_grade,b.lot_status
431: from ic_lots_mst a, ic_loct_inv b
432: where a.lot_no like (p_lot_no) and a.lot_id <> 0 and a.lot_id =b.lot_id
433: and a.item_id = b.item_id and
434: a.delete_mark = 0 and b.delete_mark = 0 and a.item_id = p_item_id and
435: b.whse_code = p_whse_code and b.location = nvl(l_location,b.location)

Line 444: from ic_lots_mst a, ic_loct_inv b

440:
441:
442: OPEN x_lot_lov FOR
443: select distinct lot_no,sublot_no, a.lot_id,a.qc_grade,b.lot_status
444: from ic_lots_mst a, ic_loct_inv b
445: where a.lot_no like (p_lot_no) and a.lot_id <> 0 and a.lot_id =b.lot_id
446: and a.item_id = b.item_id and
447: a.delete_mark = 0 and b.delete_mark = 0 and a.item_id = p_item_id and
448: b.whse_code = p_whse_code and b.location = nvl(l_location,b.location)

Line 481: from ic_lots_mst a, ic_loct_inv b

477: IF p_neg_inv_allowed = 0 THEN
478:
479: OPEN x_sub_lot_lov FOR
480: select distinct sublot_no, a.qc_grade, b.lot_status, a.lot_id
481: from ic_lots_mst a, ic_loct_inv b
482: where a.lot_id <> 0 and a.lot_id = b.lot_id and a.item_id = b.item_id and
483: a.delete_mark = 0 and
484:
485: b.delete_mark = 0 and b.whse_code = p_whse_code and a.lot_no = p_lot_no and b.loct_onhand > 0

Line 493: from ic_lots_mst a, ic_loct_inv b

489: ELSE
490:
491: OPEN x_sub_lot_lov FOR
492: select distinct sublot_no, a.qc_grade, b.lot_status, a.lot_id
493: from ic_lots_mst a, ic_loct_inv b
494: where a.lot_id <> 0 and a.lot_id = b.lot_id and a.item_id = b.item_id and
495: a.delete_mark = 0 and
496:
497: b.delete_mark = 0 and b.whse_code = p_whse_code and a.lot_no = p_lot_no