DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on MTL_ONHAND_LOCATOR_V

Line 2604: FROM wms_item_locations_kfv loc, mtl_onhand_locator_v onh

2600: IF l_ind = 1 THEN
2601: OPEN x_locators FOR
2602: SELECT DISTINCT loc.concatenated_segments locator, loc.description,
2603: onh.locator_id
2604: FROM wms_item_locations_kfv loc, mtl_onhand_locator_v onh
2605: WHERE loc.organization_id = onh.organization_id
2606: AND loc.inventory_location_id = onh.locator_id
2607: AND NVL(loc.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2608: AND loc.organization_id = p_organization_id