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 IEU_UWQM_AUDIT_LOG

Line 458: from ieu_uwqm_audit_log a

454: DECODE(a.workitem_STATUS_ID_curr,'0', 'Open', '3', 'Close', '4', 'Delete', '5', 'Sleep') status,
455: a.owner_id_prev,a.owner_id_curr,a.owner_type_prev,a.owner_type_curr,
456: a.assignee_id_prev,a.assignee_id_curr,a.assignee_type_prev,a.assignee_type_curr,
457: ws_code
458: from ieu_uwqm_audit_log a
459: Where a.creation_date between p_from_date and p_to_date
460: And (a.assignee_type_prev ='RS_INDIVIDUAL' )
461: and (a.assignee_type_curr ='RS_INDIVIDUAL')
462: and (a.assignee_id_prev <> a.assignee_id_curr)

Line 686: from ieu_uwqm_audit_log a

682: DECODE(a.workitem_STATUS_ID_curr,'0', 'Open', '3', 'Close', '4', 'Delete', '5', 'Sleep') status,
683: a.owner_id_prev,a.owner_id_curr,a.owner_type_prev,a.owner_type_curr,
684: a.assignee_id_prev,a.assignee_id_curr,a.assignee_type_prev,a.assignee_type_curr,
685: ws_code
686: from ieu_uwqm_audit_log a
687: Where a.creation_date between p_from_date and p_to_date
688: And ( (a.owner_type_prev <> 'RS_GROUP')
689: and (a.owner_type_curr = 'RS_GROUP')
690: and (a.assignee_type_curr is null)

Line 1118: FROM ieu_uwqm_audit_log a, ieu_uwqm_work_sources_b b, ieu_uwqm_work_sources_tl tl,

1114: DECODE(a.WORKITEM_DIST_STATUS_ID_CURR, '0', 'On Hold', '1', 'Distributable',
1115: '2', 'Distributing', '3', 'Distributed') WORKITEM_DIST_STATUS_ID_CURR ,
1116: a.workitem_obj_code,a.OWNER_ID_CURR, rs1.group_name owner_name,
1117: a.ASSIGNEE_ID_CURR, rs2.resource_name assignee_name, a.ws_code, a.work_item_number, b.ws_id, tl.ws_name ws_name
1118: FROM ieu_uwqm_audit_log a, ieu_uwqm_work_sources_b b, ieu_uwqm_work_sources_tl tl,
1119: jtf_rs_groups_vl rs1, JTF_RS_RESOURCE_EXTNS_vl rs2
1120: WHERE a.owner_type_curr = 'RS_GROUP'
1121: and a.assignee_type_curr = 'RS_INDIVIDUAL'
1122: AND a.owner_id_curr = rs1.group_id(+)

Line 1162: FROM ieu_uwqm_audit_log a, ieu_uwqm_work_sources_b b, ieu_uwqm_work_sources_tl tl,

1158: '2', 'Distributing', '3', 'Distributed') WORKITEM_DIST_STATUS_ID_CURR ,
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

Line 1358: FROM ieu_uwqm_audit_log a

1354: a.WORKITEM_COMMENT_CODE3 m8,
1355: a.WORKITEM_COMMENT_CODE4 m9,
1356: a.WORKITEM_COMMENT_CODE5 m10, a.LAST_UPDATE_DATE, a.workitem_pk_id,
1357: a.return_status, a.error_code, a.ws_code, a.source_object_id_curr, a.source_object_type_code_curr
1358: FROM ieu_uwqm_audit_log a
1359: where (a.work_item_number = p_item_number
1360: AND a.workitem_obj_code = p_object_code)
1361: or (a.SOURCE_OBJECT_ID_CURR = p_item_number
1362: and a.SOURCE_OBJECT_TYPE_CODE_CURR = p_object_code)