APPS.OE_UPG_SO_NEW dependencies on SO_LINE_SERVICE_DETAILS

Line 1269: select max(system_id) into v_system_id from so_line_service_details

1265: -- Fix made for Bug-1894965
1266:
1267: v_system_id := NULL;
1268:
1269: select max(system_id) into v_system_id from so_line_service_details
1270: where line_id = mol.line_id;
1271:
1272: g_line_rec.service_reference_system_id :=v_system_id;
1273: else

Line 4528: ' (select count(1) from so_line_service_details),' ||

4524:
4525: l_cursor_stmt VARCHAR2(2000) :=
4526: 'select ' ||
4527: ' line_service_detail_id,'||
4528: ' (select count(1) from so_line_service_details),' ||
4529: ' (select min(line_service_detail_id) from so_line_service_details),' ||
4530: ' (select max(line_service_detail_id) from so_line_service_details)' ||
4531: ' from so_line_service_details' ||
4532: ' order by line_service_detail_id';

Line 4529: ' (select min(line_service_detail_id) from so_line_service_details),' ||

4525: l_cursor_stmt VARCHAR2(2000) :=
4526: 'select ' ||
4527: ' line_service_detail_id,'||
4528: ' (select count(1) from so_line_service_details),' ||
4529: ' (select min(line_service_detail_id) from so_line_service_details),' ||
4530: ' (select max(line_service_detail_id) from so_line_service_details)' ||
4531: ' from so_line_service_details' ||
4532: ' order by line_service_detail_id';
4533:

Line 4530: ' (select max(line_service_detail_id) from so_line_service_details)' ||

4526: 'select ' ||
4527: ' line_service_detail_id,'||
4528: ' (select count(1) from so_line_service_details),' ||
4529: ' (select min(line_service_detail_id) from so_line_service_details),' ||
4530: ' (select max(line_service_detail_id) from so_line_service_details)' ||
4531: ' from so_line_service_details' ||
4532: ' order by line_service_detail_id';
4533:
4534: l_total_slabs NUMBER := p_number_of_slabs;

Line 4531: ' from so_line_service_details' ||

4527: ' line_service_detail_id,'||
4528: ' (select count(1) from so_line_service_details),' ||
4529: ' (select min(line_service_detail_id) from so_line_service_details),' ||
4530: ' (select max(line_service_detail_id) from so_line_service_details)' ||
4531: ' from so_line_service_details' ||
4532: ' order by line_service_detail_id';
4533:
4534: l_total_slabs NUMBER := p_number_of_slabs;
4535: l_current_slab NUMBER := 1;