DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on MTL_ONHAND_LOCATOR_V

Line 2577: FROM wms_item_locations_kfv loc, mtl_onhand_locator_v onh

2573: IF l_ind = 1 THEN
2574: OPEN x_locators FOR
2575: SELECT DISTINCT loc.concatenated_segments locator, loc.description,
2576: onh.locator_id
2577: FROM wms_item_locations_kfv loc, mtl_onhand_locator_v onh
2578: WHERE loc.organization_id = onh.organization_id
2579: AND loc.inventory_location_id = onh.locator_id
2580: AND NVL(loc.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2581: AND loc.organization_id = p_organization_id