APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_RESERVATIONS

Line 2777: FROM mtl_reservations

2773: /* LPN reservation impact */
2774: BEGIN
2775: /*SELECT COUNT(*)
2776: INTO l_lpn_rsvd
2777: FROM mtl_reservations
2778: WHERE lpn_id = p_lpn_id;*/
2779:
2780: --Bug 5942895 Modified above query to consider nesting of LPNs.
2781: SELECT COUNT(*)

Line 2783: FROM mtl_reservations

2779:
2780: --Bug 5942895 Modified above query to consider nesting of LPNs.
2781: SELECT COUNT(*)
2782: INTO l_lpn_rsvd
2783: FROM mtl_reservations
2784: WHERE lpn_id IN (SELECT lpn_id
2785: FROM wms_license_plate_numbers
2786: WHERE outermost_lpn_id = p_lpn_id);
2787: EXCEPTION