DBA Data[Home] [Help]

APPS.EAM_MATERIALISSUE_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 114: FROM mtl_item_locations_kfv

110:
111: --derive the locator_id (p_source_locator) in case of wireless--for bug 8661513
112: IF(p_locator_name is not null and p_source_locator is null) THEN
113: SELECT inventory_location_id into l_source_locator_wl
114: FROM mtl_item_locations_kfv
115: WHERE organization_id = p_organization_id
116: AND subInventory_code = p_source_subinventory
117: AND NVL(disable_date,TRUNC(sysdate)+1) > TRUNC(sysdate)
118: AND concatenated_segments = p_locator_name;