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.CCT_JTFRESOURCEROUTING_PUB dependencies on JTF_RS_GROUP_USAGES

Line 89: jtf_rs_group_usages_vl b

85: FROM jtf_rs_group_members
86: WHERE delete_flag='N'
87: AND group_id = ( SELECT distinct a.group_id
88: FROM jtf_rs_groups_vl a,
89: jtf_rs_group_usages_vl b
90: WHERE b.usage='CALL'
91: AND b.group_ID=a.group_ID
92: AND a.start_date_active<=sysdate
93: AND nvl(a.end_date_active,sysdate)>=sysdate

Line 138: jtf_rs_group_usages_vl b

134: FROM jtf_rs_group_members
135: WHERE delete_flag='N'
136: AND group_id= ( SELECT a.group_id
137: FROM jtf_rs_groups_vl a,
138: jtf_rs_group_usages_vl b
139: WHERE b.usage='CALL'
140: AND b.group_ID=a.group_ID
141: AND a.start_date_active<=sysdate
142: AND nvl(a.end_date_active,sysdate)>=sysdate

Line 313: jtf_rs_group_usages b

309: from jtf_rs_group_members
310: where delete_flag='N'
311: and group_id = ( select a.group_id
312: from jtf_rs_groups_vl a,
313: jtf_rs_group_usages b
314: where upper(a.group_name) = upper(p_group_name)
315: and b.usage='CALL'
316: and b.group_ID=a.group_ID
317: and a.start_date_active<=sysdate

Line 334: -- jtf_rs_group_usages_vl b

330: -- FROM jtf_rs_group_members
331: -- WHERE delete_flag='N'
332: -- AND group_id= ( SELECT distinct a.group_id
333: -- FROM jtf_rs_groups_vl a,
334: -- jtf_rs_group_usages_vl b
335: -- WHERE b.usage='CALL'
336: -- AND b.group_ID=a.group_ID
337: -- AND a.start_date_active<=sysdate
338: -- AND nvl(a.end_date_active,sysdate)>=sysdate

Line 390: jtf_rs_group_usages b

386: from jtf_rs_group_members
387: where delete_flag='N'
388: and group_id = ( select a.group_id
389: from jtf_rs_groups_b a,
390: jtf_rs_group_usages b
391: where a.group_number = p_group_number
392: and b.usage='CALL'
393: and b.group_ID=a.group_ID
394: and a.start_date_active<=sysdate

Line 412: -- jtf_rs_group_usages_vl b

408: -- FROM jtf_rs_group_members
409: -- WHERE delete_flag='N'
410: -- AND group_id = ( SELECT a.group_id
411: -- FROM jtf_rs_groups_vl a,
412: -- jtf_rs_group_usages_vl b
413: -- WHERE b.usage='CALL'
414: -- AND b.group_ID=a.group_ID
415: -- AND a.start_date_active<=sysdate
416: -- AND nvl(a.end_date_active,sysdate)>=sysdate