DBA Data[Home] [Help]

APPS.GML_MOBILE_MOVE_ORDER dependencies on IC_LOCT_MST

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