eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_BUE_WORKER_DATA

Line 12571: FROM ahl_bue_worker_data

12567: -- JKJain, NR Analysis and Forecasting
12568: CURSOR get_sim_plan_id (p_parent_conc_pgm_id IN NUMBER)
12569: IS
12570: SELECT simulation_plan_id
12571: FROM ahl_bue_worker_data
12572: WHERE parent_conc_request_id = p_parent_conc_pgm_id
12573: AND child_conc_request_id IS NULL;
12574:
12575: l_simulation_plan_id NUMBER := NULL;

Line 13091: INSERT INTO AHL_BUE_WORKER_DATA

13087: EXIT WHEN (l_instance_id_tbl.count = 0);
13088:
13089: -- insert into BUE table.
13090: FORALL instance_indx IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST
13091: INSERT INTO AHL_BUE_WORKER_DATA
13092: (parent_conc_request_id,
13093: csi_item_instance_id,
13094: child_conc_request_id,
13095: last_update_date,

Line 13149: INSERT INTO AHL_BUE_WORKER_DATA

13145:
13146: BEGIN
13147: -- insert into BUE table.
13148: FORALL instance_indx IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST SAVE EXCEPTIONS
13149: INSERT INTO AHL_BUE_WORKER_DATA
13150: (parent_conc_request_id,
13151: csi_item_instance_id,
13152: child_conc_request_id,
13153: last_update_date,

Line 13185: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');

13181:
13182: x_return_status := 'E';
13183:
13184: IF (p_concurrent_flag = 'Y') THEN
13185: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
13186: FOR j IN 1..sql%bulk_exceptions.count
13187: LOOP
13188: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
13189: sqlerrm(-sql%bulk_exceptions(j).error_code) );

Line 13223: INSERT INTO AHL_BUE_WORKER_DATA

13219:
13220: BEGIN
13221: -- insert into BUE table.
13222: FORALL instance_indx IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST SAVE EXCEPTIONS
13223: INSERT INTO AHL_BUE_WORKER_DATA
13224: (parent_conc_request_id,
13225: csi_item_instance_id,
13226: child_conc_request_id,
13227: last_update_date,

Line 13252: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');

13248:
13249: x_return_status := 'E';
13250:
13251: IF (p_concurrent_flag = 'Y') THEN
13252: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
13253: FOR j IN 1..sql%bulk_exceptions.count
13254: LOOP
13255: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
13256: sqlerrm(-sql%bulk_exceptions(j).error_code) );

Line 13275: DELETE FROM ahl_bue_worker_data

13271: END IF; -- G_PRIMARY_PLAN <> 'N'
13272:
13273: -- delete duplicate rows.
13274: /* fix for performance bug# 16003176 (10g to 11g upgrade)
13275: DELETE FROM ahl_bue_worker_data
13276: WHERE parent_conc_request_id = p_conc_request_id
13277: AND rowid not in (SELECT MIN(rowid)
13278: FROM ahl_bue_worker_data
13279: WHERE parent_conc_request_id = p_conc_request_id

Line 13278: FROM ahl_bue_worker_data

13274: /* fix for performance bug# 16003176 (10g to 11g upgrade)
13275: DELETE FROM ahl_bue_worker_data
13276: WHERE parent_conc_request_id = p_conc_request_id
13277: AND rowid not in (SELECT MIN(rowid)
13278: FROM ahl_bue_worker_data
13279: WHERE parent_conc_request_id = p_conc_request_id
13280: GROUP BY csi_item_instance_id, parent_conc_request_id) ;
13281: */
13282: --DELETE FROM ahl_bue_worker_data wrk1

Line 13282: --DELETE FROM ahl_bue_worker_data wrk1

13278: FROM ahl_bue_worker_data
13279: WHERE parent_conc_request_id = p_conc_request_id
13280: GROUP BY csi_item_instance_id, parent_conc_request_id) ;
13281: */
13282: --DELETE FROM ahl_bue_worker_data wrk1
13283: --WHERE wrk1.parent_conc_request_id = p_conc_request_id
13284: -- AND wrk1.rowid > ANY ( SELECT wrk2.rowid
13285: -- FROM ahl_bue_worker_data wrk2
13286: -- WHERE wrk2.parent_conc_request_id = p_conc_request_id

Line 13285: -- FROM ahl_bue_worker_data wrk2

13281: */
13282: --DELETE FROM ahl_bue_worker_data wrk1
13283: --WHERE wrk1.parent_conc_request_id = p_conc_request_id
13284: -- AND wrk1.rowid > ANY ( SELECT wrk2.rowid
13285: -- FROM ahl_bue_worker_data wrk2
13286: -- WHERE wrk2.parent_conc_request_id = p_conc_request_id
13287: -- AND wrk2.csi_item_instance_id = wrk1.csi_item_instance_id) ;
13288:
13289: --DELETE FROM ahl_bue_worker_data ad1

Line 13289: --DELETE FROM ahl_bue_worker_data ad1

13285: -- FROM ahl_bue_worker_data wrk2
13286: -- WHERE wrk2.parent_conc_request_id = p_conc_request_id
13287: -- AND wrk2.csi_item_instance_id = wrk1.csi_item_instance_id) ;
13288:
13289: --DELETE FROM ahl_bue_worker_data ad1
13290: --WHERE ad1.parent_conc_request_id = p_conc_request_id
13291: -- AND ad1.rowid not in (SELECT /*+ UNNEST INDEX(ad2 AHL_BUE_WORKER_DATA_N2) */ MIN(ad2.rowid)
13292: -- FROM ahl_bue_worker_data ad2
13293: -- WHERE ad2.parent_conc_request_id = p_conc_request_id

Line 13291: -- AND ad1.rowid not in (SELECT /+ UNNEST INDEX(ad2 AHL_BUE_WORKER_DATA_N2) / MIN(ad2.rowid)

13287: -- AND wrk2.csi_item_instance_id = wrk1.csi_item_instance_id) ;
13288:
13289: --DELETE FROM ahl_bue_worker_data ad1
13290: --WHERE ad1.parent_conc_request_id = p_conc_request_id
13291: -- AND ad1.rowid not in (SELECT /*+ UNNEST INDEX(ad2 AHL_BUE_WORKER_DATA_N2) */ MIN(ad2.rowid)
13292: -- FROM ahl_bue_worker_data ad2
13293: -- WHERE ad2.parent_conc_request_id = p_conc_request_id
13294: -- GROUP BY ad2.csi_item_instance_id, ad2.parent_conc_request_id) ;
13295:

Line 13292: -- FROM ahl_bue_worker_data ad2

13288:
13289: --DELETE FROM ahl_bue_worker_data ad1
13290: --WHERE ad1.parent_conc_request_id = p_conc_request_id
13291: -- AND ad1.rowid not in (SELECT /*+ UNNEST INDEX(ad2 AHL_BUE_WORKER_DATA_N2) */ MIN(ad2.rowid)
13292: -- FROM ahl_bue_worker_data ad2
13293: -- WHERE ad2.parent_conc_request_id = p_conc_request_id
13294: -- GROUP BY ad2.csi_item_instance_id, ad2.parent_conc_request_id) ;
13295:
13296: --delete /*+ rowid(a) use_nl(a) */

Line 13297: -- from ahl_bue_worker_data a

13293: -- WHERE ad2.parent_conc_request_id = p_conc_request_id
13294: -- GROUP BY ad2.csi_item_instance_id, ad2.parent_conc_request_id) ;
13295:
13296: --delete /*+ rowid(a) use_nl(a) */
13297: -- from ahl_bue_worker_data a
13298: -- where rowid in
13299: -- (select /*+ unnest */ rowid
13300: -- from
13301: -- (select /*+ parallel(b) cardinality(b,10) */

Line 13306: -- from ahl_bue_worker_data b

13302: -- rowid, row_number() over (partition by
13303: -- csi_item_instance_id, parent_conc_request_id
13304: -- order by 1
13305: -- ) dup
13306: -- from ahl_bue_worker_data b
13307: -- where b.parent_conc_request_id = p_conc_request_id)
13308: -- where dup > 1);
13309:
13310: DELETE /*+ parallel(a) */ FROM ahl_bue_worker_data a

Line 13310: DELETE /+ parallel(a) / FROM ahl_bue_worker_data a

13306: -- from ahl_bue_worker_data b
13307: -- where b.parent_conc_request_id = p_conc_request_id)
13308: -- where dup > 1);
13309:
13310: DELETE /*+ parallel(a) */ FROM ahl_bue_worker_data a
13311: where a.parent_conc_request_id = p_conc_request_id
13312: and exists (select 'x' from ahl_bue_worker_data b
13313: where b.parent_conc_request_id = a.parent_conc_request_id
13314: and b.csi_item_instance_id = a.csi_item_instance_id

Line 13312: and exists (select 'x' from ahl_bue_worker_data b

13308: -- where dup > 1);
13309:
13310: DELETE /*+ parallel(a) */ FROM ahl_bue_worker_data a
13311: where a.parent_conc_request_id = p_conc_request_id
13312: and exists (select 'x' from ahl_bue_worker_data b
13313: where b.parent_conc_request_id = a.parent_conc_request_id
13314: and b.csi_item_instance_id = a.csi_item_instance_id
13315: and b.rowid > a.rowid);
13316:

Line 13340: SELECT /+ INDEX(BUEWD AHL_BUE_WORKER_DATA_N1) / BUEWD.rowid, BUEWD.csi_item_instance_id, BUEWD.object_version_number

13336:
13337: -- added hint to resolve perf bug# 16003176
13338: CURSOR ahl_bue_worker_csr (p_parent_conc_pgm_id IN NUMBER)
13339: IS
13340: SELECT /*+ INDEX(BUEWD AHL_BUE_WORKER_DATA_N1) */ BUEWD.rowid, BUEWD.csi_item_instance_id, BUEWD.object_version_number
13341: FROM ahl_bue_worker_data BUEWD
13342: WHERE BUEWD.parent_conc_request_id = p_parent_conc_pgm_id
13343: AND BUEWD.child_conc_request_id IS NULL;
13344: --FOR UPDATE OF child_conc_request_id;

Line 13341: FROM ahl_bue_worker_data BUEWD

13337: -- added hint to resolve perf bug# 16003176
13338: CURSOR ahl_bue_worker_csr (p_parent_conc_pgm_id IN NUMBER)
13339: IS
13340: SELECT /*+ INDEX(BUEWD AHL_BUE_WORKER_DATA_N1) */ BUEWD.rowid, BUEWD.csi_item_instance_id, BUEWD.object_version_number
13341: FROM ahl_bue_worker_data BUEWD
13342: WHERE BUEWD.parent_conc_request_id = p_parent_conc_pgm_id
13343: AND BUEWD.child_conc_request_id IS NULL;
13344: --FOR UPDATE OF child_conc_request_id;
13345:

Line 13349: FROM ahl_bue_worker_data

13345:
13346: CURSOR bue_lock_row (p_rowid IN urowid, p_parent_conc_pgm_id IN NUMBER )
13347: IS
13348: SELECT rowid, csi_item_instance_id
13349: FROM ahl_bue_worker_data
13350: WHERE parent_conc_request_id = p_parent_conc_pgm_id
13351: AND child_conc_request_id IS NULL
13352: AND ROWID = p_rowid
13353: FOR UPDATE OF child_conc_request_id NOWAIT;

Line 13384: UPDATE ahl_bue_worker_data

13380: OPEN bue_lock_row(l_rowid, p_parent_conc_pgm_id);
13381: FETCH bue_lock_row into l_rowid, l_instance_id;
13382: IF (bue_lock_row%FOUND) THEN
13383: -- update only if ovn remains the same.
13384: UPDATE ahl_bue_worker_data
13385: set child_conc_request_id = p_conc_child_req_id,
13386: last_update_date = sysdate,
13387: object_version_number = object_version_number + 1,
13388: last_update_login = fnd_global.login_id,

Line 13469: FROM ahl_bue_worker_data

13465: PRAGMA AUTONOMOUS_TRANSACTION;
13466:
13467: CURSOR get_undeleted_parents(p_conc_request_id IN NUMBER) IS
13468: SELECT DISTINCT parent_conc_request_id
13469: FROM ahl_bue_worker_data
13470: WHERE parent_conc_request_id <> p_conc_request_id;
13471:
13472: CURSOR get_undeleted_child(p_conc_request_id IN NUMBER) IS
13473: SELECT DISTINCT child_conc_request_id

Line 13474: FROM ahl_bue_worker_data

13470: WHERE parent_conc_request_id <> p_conc_request_id;
13471:
13472: CURSOR get_undeleted_child(p_conc_request_id IN NUMBER) IS
13473: SELECT DISTINCT child_conc_request_id
13474: FROM ahl_bue_worker_data
13475: WHERE parent_conc_request_id = p_conc_request_id
13476: AND child_conc_request_id IS NOT NULL;
13477:
13478: CURSOR lock_child_rows(p_parent_conc_id IN NUMBER,

Line 13481: FROM ahl_bue_worker_data

13477:
13478: CURSOR lock_child_rows(p_parent_conc_id IN NUMBER,
13479: p_child_conc_id IN NUMBER) IS
13480: SELECT rowid
13481: FROM ahl_bue_worker_data
13482: WHERE parent_conc_request_id = p_parent_conc_id
13483: AND child_conc_request_id = p_child_conc_id
13484: FOR UPDATE OF object_version_number NOWAIT;
13485:

Line 13523: DELETE from ahl_bue_worker_data

13519:
13520: IF (p_child_conc_request_id IS NOT NULL) THEN
13521: G_DEBUG_LINE_NUM := 300;
13522: -- cleanup rows processed by this worker.
13523: DELETE from ahl_bue_worker_data
13524: WHERE parent_conc_request_id = p_parent_conc_request_id
13525: AND child_conc_request_id = p_child_conc_request_id ;
13526: COMMIT WORK;
13527: END IF;

Line 13557: DELETE FROM AHL_BUE_WORKER_DATA

13553: FETCH fnd_concur_csr INTO l_junk;
13554: IF (fnd_concur_csr%NOTFOUND) THEN
13555: G_DEBUG_LINE_NUM := 315;
13556:
13557: DELETE FROM AHL_BUE_WORKER_DATA
13558: WHERE parent_conc_request_id = undeleted_parent.parent_conc_request_id
13559: AND child_conc_request_id IS NULL;
13560: COMMIT WORK;
13561: END IF;

Line 13608: DELETE FROM ahl_bue_worker_data

13604: BEGIN
13605: SAVEPOINT lock_child_rows_upd_s;
13606: FORALL j IN l_rowid_tbl.FIRST..l_rowid_tbl.LAST
13607: -- delete for parent concurrent.
13608: DELETE FROM ahl_bue_worker_data
13609: WHERE rowid = l_rowid_tbl(j);
13610:
13611: COMMIT;
13612: --

Line 13828: FROM AHL_BUE_WORKER_DATA

13824: WHERE item_instance_id = ue.csi_item_instance_id)
13825: )
13826: ) valid_inst
13827: WHERE NOT EXISTS (Select 1
13828: FROM AHL_BUE_WORKER_DATA
13829: WHERE csi_item_instance_id = valid_inst.csi_item_instance_id
13830: AND parent_conc_request_id = p_conc_request_id) ;
13831:
13832: l_relationship_tbl nbr_tbl_type;

Line 13908: INSERT INTO AHL_BUE_WORKER_DATA

13904:
13905: BEGIN
13906: -- insert into BUE table.
13907: FORALL instance_indx IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST SAVE EXCEPTIONS
13908: INSERT INTO AHL_BUE_WORKER_DATA
13909: (parent_conc_request_id,
13910: csi_item_instance_id,
13911: child_conc_request_id,
13912: last_update_date,

Line 13940: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');

13936:
13937: x_return_status := 'E';
13938:
13939: IF (p_concurrent_flag = 'Y') THEN
13940: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
13941: FOR j IN 1..sql%bulk_exceptions.count
13942: LOOP
13943: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
13944: sqlerrm(-sql%bulk_exceptions(j).error_code) );

Line 13974: INSERT INTO AHL_BUE_WORKER_DATA

13970: EXIT WHEN (l_instance_id_tbl.COUNT = 0);
13971: BEGIN
13972: -- insert into BUE table.
13973: FORALL instance_indx IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST SAVE EXCEPTIONS
13974: INSERT INTO AHL_BUE_WORKER_DATA
13975: (parent_conc_request_id,
13976: csi_item_instance_id,
13977: child_conc_request_id,
13978: last_update_date,

Line 14003: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');

13999: END IF;
14000: x_return_status := 'E';
14001:
14002: IF (p_concurrent_flag = 'Y') THEN
14003: fnd_file.put_line(fnd_file.log, 'Following error(s) occured while inserting into table ahl_bue_worker_data');
14004: FOR j IN 1..sql%bulk_exceptions.count
14005: LOOP
14006: fnd_file.put_line(fnd_file.log, sql%bulk_exceptions(j).error_index || ', ' ||
14007: sqlerrm(-sql%bulk_exceptions(j).error_code) );

Line 14024: DELETE FROM ahl_bue_worker_data

14020: CLOSE get_extra_ue_na;
14021:
14022: -- delete duplicate rows.
14023: /* fix for performance bug# 16003176 (10g to 11g upgrade)
14024: DELETE FROM ahl_bue_worker_data
14025: WHERE parent_conc_request_id = p_conc_request_id
14026: AND rowid not in (SELECT MIN(rowid)
14027: FROM ahl_bue_worker_data
14028: WHERE parent_conc_request_id = p_conc_request_id

Line 14027: FROM ahl_bue_worker_data

14023: /* fix for performance bug# 16003176 (10g to 11g upgrade)
14024: DELETE FROM ahl_bue_worker_data
14025: WHERE parent_conc_request_id = p_conc_request_id
14026: AND rowid not in (SELECT MIN(rowid)
14027: FROM ahl_bue_worker_data
14028: WHERE parent_conc_request_id = p_conc_request_id
14029: GROUP BY csi_item_instance_id, parent_conc_request_id) ;
14030: */
14031:

Line 14032: --DELETE FROM ahl_bue_worker_data wrk1

14028: WHERE parent_conc_request_id = p_conc_request_id
14029: GROUP BY csi_item_instance_id, parent_conc_request_id) ;
14030: */
14031:
14032: --DELETE FROM ahl_bue_worker_data wrk1
14033: --WHERE wrk1.parent_conc_request_id = p_conc_request_id
14034: -- AND wrk1.rowid > ANY ( SELECT wrk2.rowid
14035: -- FROM ahl_bue_worker_data wrk2
14036: -- WHERE wrk2.parent_conc_request_id = p_conc_request_id

Line 14035: -- FROM ahl_bue_worker_data wrk2

14031:
14032: --DELETE FROM ahl_bue_worker_data wrk1
14033: --WHERE wrk1.parent_conc_request_id = p_conc_request_id
14034: -- AND wrk1.rowid > ANY ( SELECT wrk2.rowid
14035: -- FROM ahl_bue_worker_data wrk2
14036: -- WHERE wrk2.parent_conc_request_id = p_conc_request_id
14037: -- AND wrk2.csi_item_instance_id = wrk1.csi_item_instance_id) ;
14038:
14039: --DELETE FROM ahl_bue_worker_data ad1

Line 14039: --DELETE FROM ahl_bue_worker_data ad1

14035: -- FROM ahl_bue_worker_data wrk2
14036: -- WHERE wrk2.parent_conc_request_id = p_conc_request_id
14037: -- AND wrk2.csi_item_instance_id = wrk1.csi_item_instance_id) ;
14038:
14039: --DELETE FROM ahl_bue_worker_data ad1
14040: --WHERE ad1.parent_conc_request_id = p_conc_request_id
14041: -- AND ad1.rowid not in (SELECT /*+ UNNEST INDEX(ad2 AHL_BUE_WORKER_DATA_N2) */ MIN(ad2.rowid)
14042: -- FROM ahl_bue_worker_data ad2
14043: -- WHERE ad2.parent_conc_request_id = p_conc_request_id

Line 14041: -- AND ad1.rowid not in (SELECT /+ UNNEST INDEX(ad2 AHL_BUE_WORKER_DATA_N2) / MIN(ad2.rowid)

14037: -- AND wrk2.csi_item_instance_id = wrk1.csi_item_instance_id) ;
14038:
14039: --DELETE FROM ahl_bue_worker_data ad1
14040: --WHERE ad1.parent_conc_request_id = p_conc_request_id
14041: -- AND ad1.rowid not in (SELECT /*+ UNNEST INDEX(ad2 AHL_BUE_WORKER_DATA_N2) */ MIN(ad2.rowid)
14042: -- FROM ahl_bue_worker_data ad2
14043: -- WHERE ad2.parent_conc_request_id = p_conc_request_id
14044: -- GROUP BY ad2.csi_item_instance_id, ad2.parent_conc_request_id) ;
14045:

Line 14042: -- FROM ahl_bue_worker_data ad2

14038:
14039: --DELETE FROM ahl_bue_worker_data ad1
14040: --WHERE ad1.parent_conc_request_id = p_conc_request_id
14041: -- AND ad1.rowid not in (SELECT /*+ UNNEST INDEX(ad2 AHL_BUE_WORKER_DATA_N2) */ MIN(ad2.rowid)
14042: -- FROM ahl_bue_worker_data ad2
14043: -- WHERE ad2.parent_conc_request_id = p_conc_request_id
14044: -- GROUP BY ad2.csi_item_instance_id, ad2.parent_conc_request_id) ;
14045:
14046: --delete /*+ rowid(a) use_nl(a) */

Line 14047: -- from ahl_bue_worker_data a

14043: -- WHERE ad2.parent_conc_request_id = p_conc_request_id
14044: -- GROUP BY ad2.csi_item_instance_id, ad2.parent_conc_request_id) ;
14045:
14046: --delete /*+ rowid(a) use_nl(a) */
14047: -- from ahl_bue_worker_data a
14048: -- where rowid in
14049: -- (select /*+ unnest */ rowid
14050: -- from
14051: -- (select /*+ parallel(b) cardinality(b,10) */

Line 14056: -- from ahl_bue_worker_data b

14052: -- rowid, row_number() over (partition by
14053: -- csi_item_instance_id, parent_conc_request_id
14054: -- order by 1
14055: -- ) dup
14056: -- from ahl_bue_worker_data b
14057: -- where b.parent_conc_request_id = p_conc_request_id)
14058: -- where dup > 1);
14059:
14060: DELETE /*+ parallel(a) */ FROM ahl_bue_worker_data a

Line 14060: DELETE /+ parallel(a) / FROM ahl_bue_worker_data a

14056: -- from ahl_bue_worker_data b
14057: -- where b.parent_conc_request_id = p_conc_request_id)
14058: -- where dup > 1);
14059:
14060: DELETE /*+ parallel(a) */ FROM ahl_bue_worker_data a
14061: where a.parent_conc_request_id = p_conc_request_id
14062: and exists (select 'x' from ahl_bue_worker_data b
14063: where b.parent_conc_request_id = a.parent_conc_request_id
14064: and b.csi_item_instance_id = a.csi_item_instance_id

Line 14062: and exists (select 'x' from ahl_bue_worker_data b

14058: -- where dup > 1);
14059:
14060: DELETE /*+ parallel(a) */ FROM ahl_bue_worker_data a
14061: where a.parent_conc_request_id = p_conc_request_id
14062: and exists (select 'x' from ahl_bue_worker_data b
14063: where b.parent_conc_request_id = a.parent_conc_request_id
14064: and b.csi_item_instance_id = a.csi_item_instance_id
14065: and b.rowid > a.rowid);
14066: