APPS.GME_MOBILE_LOVS dependencies on MTL_ONHAND_SUB_V

Line 2271: FROM mtl_secondary_inventories sub, mtl_onhand_sub_v onh

2267: IF l_ind = 1 THEN
2268: OPEN x_sub_lov FOR
2269: SELECT DISTINCT sub.secondary_inventory_name, sub.description,
2270: NVL(sub.locator_type, 1)
2271: FROM mtl_secondary_inventories sub, mtl_onhand_sub_v onh
2272: WHERE sub.organization_id = onh.organization_id
2273: AND sub.secondary_inventory_name = onh.subinventory_code
2274: AND NVL(sub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2275: AND sub.quantity_tracked = 1