[Home] [Help]
1237: CURSOR get_location (v_org_id IN NUMBER
1238: ,v_sub_inv IN VARCHAR2
1239: ,v_loc_id IN NUMBER) IS
1240: SELECT substr(concatenated_segments,1,100)
1241: FROM wms_item_locations_kfv
1242: WHERE organization_id = v_org_id
1243: AND subinventory_code = v_sub_inv
1244: AND inventory_location_id (+) = v_loc_id;
1245: l_mmti_rec mtl_transactions_interface%ROWTYPE;