[Home] [Help]
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)
463: AND a.owner_id_curr in ( select group_id from jtf_rs_groups_vl where lower(group_name) = lower(p_group_name))
464: ORDER BY a.creation_date;
465:
466:
467:
931: a.ws_id
932: from ieu_uwqm_items a
933: Where a.DISTRIBUTION_STATUS_ID = 2
934: And a.owner_type = 'RS_GROUP'
935: And a.owner_id IN (select group_id FROM jtf_rs_groups_vl WHERE lower(GROUP_name) = lower(p_group_name))
936: and a.creation_date BETWEEN p_from_date AND p_to_date
937: ORDER BY a.title;
938:
939:
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(+)
1123: AND a.assignee_id_curr = rs2.resource_id(+)