APPS.GME_MOBILE_LOVS dependencies on MTL_ONHAND_SUB_V

Line 2298: FROM mtl_secondary_inventories sub, mtl_onhand_sub_v onh

2294: IF l_ind = 1 THEN
2295: OPEN x_sub_lov FOR
2296: SELECT DISTINCT sub.secondary_inventory_name, sub.description,
2297: NVL(sub.locator_type, 1)
2298: FROM mtl_secondary_inventories sub, mtl_onhand_sub_v onh
2299: WHERE sub.organization_id = onh.organization_id
2300: AND sub.secondary_inventory_name = onh.subinventory_code
2301: AND NVL(sub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2302: AND sub.quantity_tracked = 1