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_UWQ_GET_NEXT_WORK_PVT dependencies on IEU_UWQM_ITEMS

Line 78: FROM ieu_uwqm_items

74: THEN
75:
76: SELECT status_id, source_object_id, source_object_type_code
77: INTO l_status_id, l_source_object_id, l_source_obj_type_code
78: FROM ieu_uwqm_items
79: WHERE work_item_id = p_work_item_id;
80:
81: ELSE
82:

Line 85: FROM ieu_uwqm_items

81: ELSE
82:
83: SELECT status_id, source_object_id, source_object_type_code
84: INTO l_status_id, l_source_object_id, l_source_obj_type_code
85: FROM ieu_uwqm_items
86: WHERE workitem_pk_id = p_workitem_pk_id
87: AND workitem_obj_code = p_workitem_obj_code;
88:
89: END IF;

Line 119: FROM IEU_UWQM_ITEMS

115: -- Release source_doc_id
116:
117: /* SELECT WORK_ITEM_ID
118: INTO L_SOURCEOBJ_WORKITEM_ID
119: FROM IEU_UWQM_ITEMS
120: WHERE (WORKITEM_PK_ID, WORKITEM_OBJ_CODE) IN
121: (SELECT SOURCE_OBJECT_ID, SOURCE_OBJECT_TYPE_CODE
122: FROM IEU_UWQM_ITEMS
123: WHERE ( (WORK_ITEM_ID = P_WORK_ITEM_ID) OR

Line 122: FROM IEU_UWQM_ITEMS

118: INTO L_SOURCEOBJ_WORKITEM_ID
119: FROM IEU_UWQM_ITEMS
120: WHERE (WORKITEM_PK_ID, WORKITEM_OBJ_CODE) IN
121: (SELECT SOURCE_OBJECT_ID, SOURCE_OBJECT_TYPE_CODE
122: FROM IEU_UWQM_ITEMS
123: WHERE ( (WORK_ITEM_ID = P_WORK_ITEM_ID) OR
124: ( (WORKITEM_PK_ID = P_WORKITEM_PK_ID) AND (WORKITEM_OBJ_CODE = P_WORKITEM_OBJ_CODE) )
125: )
126: );

Line 131: FROM IEU_UWQM_ITEMS

127: */
128: /*
129: SELECT WORK_ITEM_ID
130: INTO L_SOURCEOBJ_WORKITEM_ID
131: FROM IEU_UWQM_ITEMS
132: WHERE WORKITEM_PK_ID = l_source_object_id
133: AND WORKITEM_OBJ_CODE = l_source_obj_type_code;
134:
135: IF (L_SOURCEOBJ_WORKITEM_ID is not null)

Line 289: from ieu_uwqm_items

285: declare
286: cursor c1 is
287: select work_item_id, priority_level, to_char(due_date,'dd-mon-yyyy hh24:mi:ss') due_date,
288: workitem_obj_code
289: from ieu_uwqm_items
290: where owner_type = l_owner_type_ind
291: and owner_id = p_resource_id
292: and status_id in (0,1,2)
293: and reschedule_time <= sysdate

Line 320: from ieu_uwqm_items

316: declare
317: cursor c1 is
318: select work_item_id, priority_level, to_char(due_date,'dd-mon-yyyy hh24:mi:ss') due_date,
319: workitem_obj_code
320: from ieu_uwqm_items
321: where owner_type = l_owner_type_grp
322: and owner_id in (select group_id from jtf_rs_group_members where resource_id = p_resource_id)
323: and status_id in (0,1,2)
324: and reschedule_time <= sysdate

Line 353: from ieu_uwqm_items

349: declare
350: cursor c1 is
351: select work_item_id, priority_level, to_char(due_date,'dd-mon-yyyy hh24:mi:ss') due_date,
352: workitem_obj_code
353: from ieu_uwqm_items
354: where assignee_type = l_owner_type_ind
355: and assignee_id = p_resource_id
356: and status_id in (0,1,2)
357: and reschedule_time <= sysdate

Line 386: from ieu_uwqm_items

382: declare
383: cursor c1 is
384: select work_item_id, priority_level, to_char(due_date,'dd-mon-yyyy hh24:mi:ss') due_date,
385: workitem_obj_code
386: from ieu_uwqm_items
387: where assignee_type = l_owner_type_grp
388: and assignee_id in (select group_id from jtf_rs_group_members where resource_id =p_resource_id)
389: and status_id in (0,1,2)
390: and reschedule_time <= sysdate

Line 757: FROM IEU_UWQM_ITEMS UWQM,

753: UWQM.RESCHEDULE_TIME,
754: LKUPS.MEANING WORK_TYPE,
755: DECODE(STATUS_ID, 0, '', 1, LKUPS1.MEANING, 2, LKUPS1.MEANING) STATUS_CODE
756: INTO X_UWQM_WORKITEM_DATA(i)
757: FROM IEU_UWQM_ITEMS UWQM,
758: IEU_UWQ_SEL_ENUMERATORS ENUM,
759: IEU_UWQM_PRIORITIES_TL PR,
760: FND_LOOKUP_VALUES_VL LKUPS,
761: FND_LOOKUP_VALUES_VL LKUPS1

Line 862: from ieu_uwqm_items

858: -------------- Individual Owned Work Items ----------1
859: declare
860: cursor c1 is
861: select work_item_id
862: from ieu_uwqm_items
863: where owner_type = l_owner_type_ind
864: and owner_id = p_resource_id
865: and status_id = p_status_id
866: and (p_node_type = 1 or p_node_type = 2)

Line 870: from ieu_uwqm_items

866: and (p_node_type = 1 or p_node_type = 2)
867: and reschedule_time <= sysdate
868: union
869: select work_item_id
870: from ieu_uwqm_items
871: where owner_type = l_owner_type_grp
872: and owner_id in (select group_id from jtf_rs_group_members where resource_id = p_resource_id)
873: and status_id = p_status_id
874: and (p_node_type = 1 or p_node_type = 3)

Line 878: from ieu_uwqm_items

874: and (p_node_type = 1 or p_node_type = 3)
875: and reschedule_time <= sysdate
876: union
877: select work_item_id
878: from ieu_uwqm_items
879: where assignee_type = l_owner_type_ind
880: and assignee_id = p_resource_id
881: and status_id = p_status_id
882: and (p_node_type = 1 or p_node_type = 4)

Line 886: from ieu_uwqm_items

882: and (p_node_type = 1 or p_node_type = 4)
883: and reschedule_time <= sysdate
884: union
885: select work_item_id
886: from ieu_uwqm_items
887: where assignee_type = l_owner_type_grp
888: and assignee_id in (select group_id from jtf_rs_group_members where resource_id =p_resource_id)
889: and status_id = p_status_id
890: and (p_node_type = 1 or p_node_type = 5)

Line 1105: FROM IEU_UWQM_ITEMS items '||

1101: IEU_ENUM_TYPE_UUID,
1102: WORK_ITEM_NUMBER,
1103: RESCHEDULE_TIME,
1104: WS_ID
1105: FROM IEU_UWQM_ITEMS items '||
1106: ' WHERE ( '|| p_dist_to_extra_where_clause || ' ) '||
1107: ' AND DISTRIBUTION_STATUS_ID = :l_del_status' ||
1108: ' AND STATUS_ID = :l_open_status_id ' ||
1109: ' and reschedule_time <= sysdate ' ||

Line 1263: FROM IEU_UWQM_ITEMS items '||

1259: IEU_ENUM_TYPE_UUID,
1260: WORK_ITEM_NUMBER,
1261: RESCHEDULE_TIME,
1262: WS_ID
1263: FROM IEU_UWQM_ITEMS items '||
1264: ' WHERE ( '|| p_dist_from_extra_where_clause || ' ) '||
1265: ' AND DISTRIBUTION_STATUS_ID = :l_dist_status' ||
1266: ' AND STATUS_ID = :l_open_status_id ' ||
1267: ' and reschedule_time <= sysdate ' ||

Line 1360: update ieu_uwqm_items

1356:
1357: l_dist_wr_cur_cnt := l_dist_wr_cur_cnt + 1;
1358:
1359:
1360: update ieu_uwqm_items
1361: set distribution_status_id = 2
1362: where work_item_id = l_dist_nw_item.WORK_ITEM_ID;
1363:
1364:

Line 1547: from ieu_uwqm_items

1543: BEGIN
1544:
1545: select reschedule_time, distribution_status_id
1546: into l_reschedule_time, l_distribution_status_id
1547: from ieu_uwqm_items
1548: where workitem_pk_id = l_workitem_pk_id
1549: and workitem_obj_code = l_workitem_obj_code;
1550:
1551: EXCEPTION

Line 1770: from ieu_uwqm_items

1766: BEGIN
1767:
1768: select reschedule_time, distribution_status_id
1769: into l_reschedule_time, l_distribution_status_id
1770: from ieu_uwqm_items
1771: where workitem_pk_id = l_workitem_pk_id
1772: and workitem_obj_code = l_workitem_obj_code;
1773:
1774: EXCEPTION

Line 2043: update ieu_uwqm_items

2039: then
2040: l_status_id := 5;
2041: end if;
2042:
2043: update ieu_uwqm_items
2044: set distribution_status_id = 1
2045: where work_item_id = l_dist_items(k).work_item_id;
2046: commit;
2047:

Line 2077: from ieu_uwqm_items

2073: BEGIN
2074:
2075: select reschedule_time, distribution_status_id, priority_id
2076: into l_reschedule_time, l_distribution_status_id, l_priority_id
2077: from ieu_uwqm_items
2078: where workitem_pk_id = l_workitem_pk_id
2079: and workitem_obj_code = l_workitem_obj_code;
2080:
2081: EXCEPTION

Line 2196: from ieu_uwqm_items

2192: BEGIN
2193:
2194: select reschedule_time, distribution_status_id, priority_id
2195: into l_reschedule_time, l_distribution_status_id, l_priority_id
2196: from ieu_uwqm_items
2197: where workitem_pk_id = l_workitem_pk_id
2198: and workitem_obj_code = l_workitem_obj_code;
2199:
2200: EXCEPTION

Line 2340: from ieu_uwqm_items

2336: BEGIN
2337:
2338: select reschedule_time, distribution_status_id, priority_id
2339: into l_reschedule_time, l_distribution_status_id, l_priority_id
2340: from ieu_uwqm_items
2341: where workitem_pk_id = l_dist_items(j).workitem_pk_id
2342: and workitem_obj_code = l_dist_items(j).workitem_obj_code;
2343:
2344: EXCEPTION

Line 2469: update ieu_uwqm_items

2465: --dbms_output.put_line('Work item id: '||l_nw_items_list(y).workitem_pk_id);
2466: --dbms_output.put_line('Distributed Work Item Id: '||l_dist_work_item_id );
2467: if (l_nw_items_list(y).work_item_id <> nvl(l_dist_work_item_id,-1))
2468: then
2469: update ieu_uwqm_items
2470: set distribution_status_id = 1
2471: where work_item_id = l_nw_items_list(y).work_item_id;
2472: commit;
2473: end if;

Line 2855: FROM IEU_UWQM_ITEMS '||

2851: IEU_ENUM_TYPE_UUID,
2852: WORK_ITEM_NUMBER,
2853: RESCHEDULE_TIME,
2854: WS_ID
2855: FROM IEU_UWQM_ITEMS '||
2856: ' WHERE ' || ' ( ' ||p_extra_where_clause || ' ) '||
2857: ' AND DISTRIBUTION_STATUS_ID = :l_dist_status' ||
2858: ' AND STATUS_ID = :l_status_id ' ||
2859: ' and reschedule_time <= sysdate ' ||

Line 2963: update ieu_uwqm_items

2959:
2960: l_wr_cur_cnt := l_wr_cur_cnt + 1;
2961:
2962: -- update work item status to distributing
2963: update ieu_uwqm_items
2964: set distribution_status_id = 2
2965: where work_item_id = l_nw_item.WORK_ITEM_ID;
2966:
2967:

Line 3286: update ieu_uwqm_items

3282: l_status_id := 5;
3283: end if;
3284:
3285: -- insert into p_temp values('dist func failed '||l_return_status||' '||l_msg_data, l_dist_items(k).work_item_id);commit;
3286: update ieu_uwqm_items
3287: set distribution_status_id = 1
3288: where work_item_id = l_dist_items(k).work_item_id;
3289: commit;
3290:

Line 3335: from ieu_uwqm_items

3331: BEGIN
3332:
3333: select reschedule_time, distribution_status_id, priority_id
3334: into l_reschedule_time, l_distribution_status_id, l_priority_id
3335: from ieu_uwqm_items
3336: where workitem_pk_id = l_workitem_pk_id
3337: and workitem_obj_code = l_workitem_obj_code;
3338:
3339: EXCEPTION

Line 3464: from ieu_uwqm_items

3460: BEGIN
3461:
3462: select reschedule_time, priority_id
3463: into l_reschedule_time, l_priority_id
3464: from ieu_uwqm_items
3465: where workitem_pk_id = l_workitem_pk_id
3466: and workitem_obj_code = l_workitem_obj_code;
3467:
3468: EXCEPTION

Line 3576: update ieu_uwqm_items

3572: elsif (l_dist_items(j).DISTRIBUTED = 'FALSE')
3573: then
3574: -- set the distribution_status_id back to 'Distributable'
3575: --dbms_output.put_line('dist status set to FALSE work item pkid: '||l_dist_items(j).WORKITEM_PK_ID);
3576: update ieu_uwqm_items
3577: set distribution_status_id = 1
3578: where work_item_id = l_dist_items(j).work_item_id;
3579: commit;
3580:

Line 3595: update ieu_uwqm_items

3591: end if; /* x_num_of_items_distributed <> -1 */
3592: if l_nw_items_list.count > 0 then
3593: for y in l_nw_items_list.first..l_nw_items_list.last
3594: loop
3595: update ieu_uwqm_items
3596: set distribution_status_id = 1
3597: where work_item_id = l_nw_items_list(y).work_item_id
3598: and distribution_status_id = 2;
3599: commit;

Line 4941: l_sql_stmt := 'UPDATE IEU_UWQM_ITEMS

4937: end if;
4938: l_df_grp_id_clause := '( owner_type = '||''''||'RS_GROUP'||''''||' and '||l_df_grp_id_clause||')';
4939:
4940:
4941: l_sql_stmt := 'UPDATE IEU_UWQM_ITEMS
4942: SET DISTRIBUTION_STATUS_ID = 1
4943: WHERE '|| l_df_grp_id_clause ||
4944: 'AND DISTRIBUTION_STATUS_ID = '||':l_distribution_status_id '||
4945: 'AND STATUS_ID = '||':l_status_id'