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_WR_PUB dependencies on IEU_UWQM_PRIORITIES_B

Line 257: FROM ieu_uwqm_priorities_b

253: BEGIN
254:
255: SELECT priority_id, priority_level
256: INTO l_priority_id, l_priority_level
257: FROM ieu_uwqm_priorities_b
258: WHERE priority_code = p_priority_code;
259:
260: EXCEPTION
261: WHEN no_data_found THEN

Line 1175: from ieu_uwqm_items a, ieu_uwqm_priorities_b b

1171:
1172: BEGIN
1173: select decode(p_priority_code, FND_API.G_MISS_CHAR, b.priority_code, p_priority_code) priority_code
1174: into m_priority_code
1175: from ieu_uwqm_items a, ieu_uwqm_priorities_b b
1176: where a.priority_id = b.priority_id
1177: and a.priority_level = b.priority_level
1178: and a.workitem_obj_code = p_workitem_obj_code
1179: and a.workitem_pk_id = p_workitem_pk_id;

Line 1280: FROM ieu_uwqm_priorities_b

1276: BEGIN
1277:
1278: SELECT priority_id, priority_level
1279: INTO l_priority_id, l_priority_level
1280: FROM ieu_uwqm_priorities_b
1281: WHERE priority_code = m_priority_code;
1282:
1283: EXCEPTION
1284: WHEN no_data_found THEN

Line 1995: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip

1991: -- 'A', tb.actual_end_date, 'S', tb.scheduled_end_date, null, tb.scheduled_end_date) due_date,
1992: tb.planned_start_date, tb.planned_end_date, tb.actual_start_date, tb.actual_end_date,
1993: tb.scheduled_start_date, tb.scheduled_end_date,tb.task_type_id,
1994: tb.task_status_id, tt.task_name, tp.importance_level, ip.priority_code, tb.task_priority_id
1995: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
1996: where tb.entity = 'TASK' and nvl(tb.deleted_flag, 'N') = 'N' and tb.task_id = tt.task_id
1997: and tt.language = userenv('LANG') and tp.task_priority_id = nvl(tb.task_priority_id, 4)
1998: and least(tp.importance_level, 4) = ip.priority_level
1999: and tb.open_flag = 'Y'

Line 3414: FROM ieu_uwqm_priorities_b

3410: BEGIN
3411:
3412: SELECT priority_id, priority_level
3413: INTO l_priority_id, l_priority_level
3414: FROM ieu_uwqm_priorities_b
3415: WHERE priority_code = p_priority_code;
3416:
3417: EXCEPTION
3418: WHEN no_data_found THEN

Line 4799: from ieu_uwqm_items a, ieu_uwqm_priorities_b b

4795:
4796: BEGIN
4797: select decode(p_priority_code, FND_API.G_MISS_CHAR, b.priority_code, p_priority_code) priority_code
4798: into m_priority_code
4799: from ieu_uwqm_items a, ieu_uwqm_priorities_b b
4800: where a.priority_id = b.priority_id
4801: and a.priority_level = b.priority_level
4802: and a.workitem_obj_code = p_workitem_obj_code
4803: and a.workitem_pk_id = p_workitem_pk_id;

Line 4907: FROM ieu_uwqm_priorities_b

4903: BEGIN
4904:
4905: SELECT priority_id, priority_level
4906: INTO l_priority_id, l_priority_level
4907: FROM ieu_uwqm_priorities_b
4908: WHERE priority_code = m_priority_code;
4909:
4910: EXCEPTION
4911: WHEN no_data_found THEN

Line 6792: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip

6788: -- 'A', tb.actual_end_date, 'S', tb.scheduled_end_date, null, tb.scheduled_end_date) due_date,
6789: tb.planned_start_date, tb.planned_end_date, tb.actual_start_date, tb.actual_end_date,
6790: tb.scheduled_start_date, tb.scheduled_end_date,tb.task_type_id,
6791: tb.task_status_id, tt.task_name, tp.importance_level, ip.priority_code, tb.task_priority_id
6792: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
6793: where tb.entity = 'TASK' and nvl(tb.deleted_flag, 'N') = 'N' and tb.task_id = tt.task_id
6794: and tt.language = userenv('LANG') and tp.task_priority_id = nvl(tb.task_priority_id, 4)
6795: and least(tp.importance_level, 4) = ip.priority_level
6796: and tb.open_flag = 'Y'

Line 7271: from ieu_uwqm_priorities_b

7267:
7268: BEGIN
7269: SELECT priority_id
7270: into l_priority_id
7271: from ieu_uwqm_priorities_b
7272: where priority_code = l_priority_code;
7273: EXCEPTION
7274: when others then
7275: null;

Line 10720: FROM IEU_UWQM_PRIORITIES_B B

10716: FROM IEU_UWQM_ITEMS_GTT A
10717: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10718: AND NOT EXISTS
10719: ( SELECT 1
10720: FROM IEU_UWQM_PRIORITIES_B B
10721: WHERE B.PRIORITY_CODE = A.PRIORITY_CODE );
10722:
10723: IF nvl(l_count, 0) > 0
10724: THEN

Line 10736: FROM IEU_UWQM_PRIORITIES_B B

10732: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10733: AND ROWNUM <= 5
10734: AND NOT EXISTS
10735: ( SELECT 1
10736: FROM IEU_UWQM_PRIORITIES_B B
10737: WHERE B.PRIORITY_CODE = A.PRIORITY_CODE );
10738:
10739: FOR i IN WORKITEM_PK_ID_LIST.FIRST..WORKITEM_PK_ID_LIST.LAST
10740: LOOP

Line 10923: FROM IEU_UWQM_PRIORITIES_B B

10919: , A.PRIORITY_LEVEL
10920: ) =
10921: (SELECT B.PRIORITY_ID
10922: , B.PRIORITY_LEVEL
10923: FROM IEU_UWQM_PRIORITIES_B B
10924: WHERE A.PRIORITY_CODE = B.PRIORITY_CODE)
10925: WHERE PROCESSING_SET_ID = P_PROCESSING_SET_ID;
10926:
10927:

Line 11341: , ieu_uwqm_priorities_b ip

11337: , tb.task_status_id
11338: from jtf_tasks_b tb
11339: , jtf_tasks_tl tt
11340: , jtf_task_priorities_vl tp
11341: , ieu_uwqm_priorities_b ip
11342: , jtf_task_statuses_b sts_b
11343: where tb.entity = 'TASK'
11344: and nvl(tb.deleted_flag, 'N') = 'N'
11345: and tb.task_id = tt.task_id