1177: select min(asset_id), max(asset_id), 0,
1178: 'UNASSIGNED', p_parent_request_id from ( select /*+ parallel(dh) */
1179: asset_id, floor(rank()
1180: over (order by asset_id)/l_batch_size ) unit_id 1181: from fa_books 1182: where book_type_code = p_book_type_code )
1183: group by unit_id;
1184:
1185: if g_print_debug then