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_DYNAMIC_GROUPS_VL

Line 183: FROM JTF_RS_DYNAMIC_GROUPS_vl a

179: l_dummy INTEGER;
180:
181: CURSOR csr_text IS
182: SELECT a.sql_text
183: FROM JTF_RS_DYNAMIC_GROUPS_vl a
184: WHERE upper(a.usage)='CALL'
185: AND a.start_date_active<=sysdate
186: AND nvl(a.end_date_active,sysdate)>=sysdate
187: AND a.group_name = p_group_name

Line 457: FROM JTF_RS_DYNAMIC_GROUPS_vl a

453: l_sort_num NUMBER := 0;
454:
455: CURSOR csr_text IS
456: SELECT a.sql_text
457: FROM JTF_RS_DYNAMIC_GROUPS_vl a
458: WHERE upper(a.usage)='CALL'
459: AND a.start_date_active<=sysdate
460: AND nvl(a.end_date_active,sysdate)>=sysdate
461: AND upper(a.group_name) = upper(p_group_name)

Line 532: FROM JTF_RS_DYNAMIC_GROUPS_vl a

528: l_sort_num NUMBER := 0;
529:
530: CURSOR csr_text IS
531: SELECT a.sql_text
532: FROM JTF_RS_DYNAMIC_GROUPS_vl a
533: WHERE upper(a.usage)='CALL'
534: AND a.start_date_active<=sysdate
535: AND nvl(a.end_date_active,sysdate)>=sysdate
536: AND a.group_number = p_group_number