APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_RESERVATIONS

Line 3154: FROM mtl_reservations

3150: /* LPN reservation impact */
3151: BEGIN
3152: /*SELECT COUNT(*)
3153: INTO l_lpn_rsvd
3154: FROM mtl_reservations
3155: WHERE lpn_id = p_lpn_id;*/
3156:
3157: --Bug 5942895 Modified above query to consider nesting of LPNs.
3158: SELECT COUNT(*)

Line 3160: FROM mtl_reservations

3156:
3157: --Bug 5942895 Modified above query to consider nesting of LPNs.
3158: SELECT COUNT(*)
3159: INTO l_lpn_rsvd
3160: FROM mtl_reservations
3161: WHERE lpn_id IN (SELECT lpn_id
3162: FROM wms_license_plate_numbers
3163: WHERE outermost_lpn_id = p_lpn_id);
3164: EXCEPTION