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.IEU_DIAG_AUDIT_TRACK_PVT dependencies on JTF_RS_GROUPS_TL

Line 87: from jtf_rs_groups_tl

83: if cur_rec.owner_id is not null then
84: if cur_rec.owner_type = 'RS_GROUP' then
85: begin
86: select group_name into owner_name
87: from jtf_rs_groups_tl
88: where group_id = cur_rec.owner_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
89: exception
90: when no_data_found then null;
91: end;

Line 115: from jtf_rs_groups_tl

111: end;
112: else
113: begin
114: select group_name into assignee_name
115: from jtf_rs_groups_tl
116: where group_id = cur_rec.assignee_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
117: exception
118: when no_data_found then null;
119: end;

Line 312: from jtf_rs_groups_tl

308: if cur_rec.owner_id is not null then
309: if cur_rec.owner_type = 'RS_GROUP' then
310: begin
311: select group_name into owner_name
312: from jtf_rs_groups_tl
313: where group_id = cur_rec.owner_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
314: exception
315: when no_data_found then null;
316: end;

Line 340: from jtf_rs_groups_tl

336: end;
337: else
338: begin
339: select group_name into assignee_name
340: from jtf_rs_groups_tl
341: where group_id = cur_rec.assignee_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
342: exception
343: when no_data_found then null;
344: end;

Line 514: from jtf_rs_groups_tl

510: if cur_rec.owner_id_prev is not null then
511: if cur_rec.owner_type_prev = 'RS_GROUP' then
512: begin
513: select group_name into owner_name_prev
514: from jtf_rs_groups_tl
515: where group_id = cur_rec.owner_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;
516: exception
517: when no_data_found then null;
518: end;

Line 542: from jtf_rs_groups_tl

538: end;
539: else
540: begin
541: select group_name into assignee_name_prev
542: from jtf_rs_groups_tl
543: where group_id = cur_rec.assignee_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;
544: exception
545: when no_data_found then null;
546: end;

Line 553: from jtf_rs_groups_tl

549: if cur_rec.owner_id_curr is not null then
550: if cur_rec.owner_type_curr = 'RS_GROUP' then
551: begin
552: select group_name into owner_name_curr
553: from jtf_rs_groups_tl
554: where group_id = cur_rec.owner_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;
555: exception
556: when no_data_found then null;
557: end;

Line 581: from jtf_rs_groups_tl

577: end;
578: else
579: begin
580: select group_name into assignee_name_curr
581: from jtf_rs_groups_tl
582: where group_id = cur_rec.assignee_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;
583: exception
584: when no_data_found then null;
585: end;

Line 753: from jtf_rs_groups_tl

749: if cur_rec.owner_id_prev is not null then
750: if cur_rec.owner_type_prev = 'RS_GROUP' then
751: begin
752: select group_name into owner_name_prev
753: from jtf_rs_groups_tl
754: where group_id = cur_rec.owner_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;
755: exception
756: when no_data_found then null;
757: end;

Line 781: from jtf_rs_groups_tl

777: end;
778: else
779: begin
780: select group_name into assignee_name_prev
781: from jtf_rs_groups_tl
782: where group_id = cur_rec.assignee_id_prev and language = FND_GLOBAL.CURRENT_LANGUAGE;
783: exception
784: when no_data_found then null;
785: end;

Line 792: from jtf_rs_groups_tl

788: if cur_rec.owner_id_curr is not null then
789: if cur_rec.owner_type_curr = 'RS_GROUP' then
790: begin
791: select group_name into owner_name_curr
792: from jtf_rs_groups_tl
793: where group_id = cur_rec.owner_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;
794: exception
795: when no_data_found then null;
796: end;

Line 820: from jtf_rs_groups_tl

816: end;
817: else
818: begin
819: select group_name into assignee_name_curr
820: from jtf_rs_groups_tl
821: where group_id = cur_rec.assignee_id_curr and language = FND_GLOBAL.CURRENT_LANGUAGE;
822: exception
823: when no_data_found then null;
824: end;

Line 974: from jtf_rs_groups_tl

970: if cur_rec.owner_id is not null then
971: if cur_rec.owner_type = 'RS_GROUP' then
972: begin
973: select group_name into owner_name
974: from jtf_rs_groups_tl
975: where group_id = cur_rec.owner_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
976: exception
977: when no_data_found then null;
978: end;

Line 1002: from jtf_rs_groups_tl

998: end;
999: else
1000: begin
1001: select group_name into assignee_name
1002: from jtf_rs_groups_tl
1003: where group_id = cur_rec.assignee_id and language = FND_GLOBAL.CURRENT_LANGUAGE;
1004: exception
1005: when no_data_found then null;
1006: end;

Line 1163: jtf_rs_groups_tl rs1, JTF_RS_RESOURCE_EXTNS_vl rs2

1159: a.workitem_obj_code,a.OWNER_ID_CURR, rs1.group_name owner_name,
1160: a.ASSIGNEE_ID_CURR, rs2.resource_name assignee_name, b.ws_id, tl.ws_name ws_name,
1161: a.work_item_number
1162: FROM ieu_uwqm_audit_log a, ieu_uwqm_work_sources_b b, ieu_uwqm_work_sources_tl tl,
1163: jtf_rs_groups_tl rs1, JTF_RS_RESOURCE_EXTNS_vl rs2
1164: WHERE a.owner_type_curr = 'RS_GROUP'
1165: and a.assignee_type_curr = 'RS_INDIVIDUAL'
1166: and a.workitem_obj_code = b.object_code
1167: and b.ws_id = tl.ws_id

Line 1411: from jtf_rs_groups_tl

1407: if cur_rec.owner_id_curr is not null then
1408: if cur_rec.owner_type_curr = 'RS_GROUP' then
1409: begin
1410: select group_name into owner_name
1411: from jtf_rs_groups_tl
1412: where group_id = cur_rec.owner_id_curr and language = l_language;
1413: exception
1414: when no_data_found then null;
1415: end;

Line 1439: from jtf_rs_groups_tl

1435: end;
1436: else
1437: begin
1438: select group_name into assignee_name
1439: from jtf_rs_groups_tl
1440: where group_id = cur_rec.assignee_id_curr and language = l_language;
1441: exception
1442: when no_data_found then null;
1443: end;