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.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_TTY_NAMED_ACCT_RSC

Line 103: jtf_tty_named_acct_rsc narsc,

99: and mydir.resource_id in (
100: select -- NO_MERGE
101: repmgr.parent_resource_id
102: from jtf_rs_rep_managers repmgr,
103: jtf_tty_named_acct_rsc narsc,
104: jtf_tty_terr_grp_accts ga
105: where narsc.resource_id = repmgr.resource_id
106: and narsc.rsc_group_id = repmgr.group_id
107: AND narsc.terr_group_account_id = ga.terr_group_account_id

Line 128: jtf_tty_named_acct_rsc narsc,

124: repmgr.parent_resource_id resource_id,
125: grpmem.group_id group_id,
126: rol.role_code role_code
127: from jtf_tty_webadi_interface tmp,
128: jtf_tty_named_acct_rsc narsc,
129: jtf_rs_rep_managers repmgr,
130: jtf_rs_role_relations rlt,
131: jtf_rs_roles_b rol,
132: jtf_rs_group_members grpmem,

Line 159: jtf_tty_named_acct_rsc narsc,

155: narsc.resource_id resource_id,
156: narsc.rsc_group_id group_id,
157: narsc.rsc_role_code role_code
158: from jtf_tty_webadi_interface tmp,
159: jtf_tty_named_acct_rsc narsc,
160: jtf_tty_my_directs_gt dir
161: where narsc.terr_group_account_id = tmp.terr_grp_acct_id
162: AND dir.current_user_id = userid
163: AND dir.dir_user_id = userid

Line 217: from jtf_tty_named_acct_rsc narsc,

213: ( select /*+ NO_MERGE */
214: repmgr.parent_resource_id,
215: grpmem.group_id,
216: rol.role_code
217: from jtf_tty_named_acct_rsc narsc,
218: jtf_rs_rep_managers repmgr,
219: jtf_rs_role_relations rlt,
220: jtf_rs_roles_b rol,
221: jtf_rs_group_members grpmem

Line 246: from jtf_tty_named_acct_rsc narsc

242: and mydir.dir_user_id = userid
243: and ( mydir.resource_id, mydir.group_id, mydir.role_code) in
244: ( select /*+ NO_MERGE */
245: narsc.resource_id, narsc.rsc_group_id, narsc.rsc_role_code
246: from jtf_tty_named_acct_rsc narsc
247: where narsc.terr_group_account_id = tgaid
248: );
249:
250:

Line 258: jtf_tty_named_acct_rsc narsc,

254: mydir.resource_name,
255: mydir.group_name,
256: mydir.role_name, mydir.role_code
257: FROM
258: jtf_tty_named_acct_rsc narsc,
259: jtf_tty_terr_grp_accts ga,
260: jtf_rs_rep_managers repmgr,
261: jtf_tty_my_directs_v mydir
262: WHERE narsc.resource_id = repmgr.resource_id

Line 405: ' from jtf_tty_named_acct_rsc narsc, '||

401: ' ttygrp.active_to_date >= sysdate '||
402: ' ) '||
403: ' and ga.terr_group_account_id IN '||
404: ' ( select /*+ NO_MERGE */ narsc.terr_group_account_id '||
405: ' from jtf_tty_named_acct_rsc narsc, '||
406: ' jtf_tty_srch_my_resources_v repdn '||
407: ' where narsc.resource_id = repdn.resource_id '||
408: ' and narsc.rsc_group_id = repdn.group_id '||
409: ' and repdn.current_user_id = :p_userid '||

Line 422: ' jtf_tty_named_acct_rsc narsc, '||

418: ' dir.resource_name, dir.resource_id, '||
419: ' dir.group_name, dir.group_id, '||
420: ' dir.role_name, dir.role_code '||
421: ' FROM '||
422: ' jtf_tty_named_acct_rsc narsc, '||
423: ' jtf_tty_terr_grp_accts ga, '||
424: ' jtf_rs_rep_managers repmgr, '||
425: ' jtf_tty_my_directs_v mydir '||
426: ' WHERE narsc.resource_id = repmgr.resource_id '||

Line 449: ' jtf_tty_named_acct_rsc narsc, '||

445: ' dir.group_name, dir.group_id, '||
446: ' dir.role_name, dir.role_code '||
447: ' from '||
448: ' jtf_tty_my_directs_v dir, '||
449: ' jtf_tty_named_acct_rsc narsc, '||
450: ' jtf_tty_terr_grp_accts ga '||
451: ' where dir.current_user_id = :0 '||
452: ' and dir.resource_id = narsc.resource_id '||
453: ' and dir.role_code = narsc.rsc_role_code '||

Line 471: ' jtf_tty_named_acct_rsc narsc, '||

467: ' where dir.current_user_id = :0 '||
468: ' and dir.dir_user_id <> :1 '||
469: ' and dir.resource_id IN ( select res.parent_resource_id '||
470: ' from jtf_rs_rep_managers res, '||
471: ' jtf_tty_named_acct_rsc narsc, '||
472: ' jtf_tty_terr_grp_accts ga '||
473: ' where res.resource_id = narsc.resource_id '||
474: ' and res.group_id = narsc.rsc_group_id '||
475: ' and res.role_code = narsc.rsc_role_code '||

Line 1030: from jtf_tty_named_acct_rsc narsc,

1026: )
1027: and ga.terr_group_account_id IN
1028: ( select /*+ NO_MERGE */
1029: narsc.terr_group_account_id
1030: from jtf_tty_named_acct_rsc narsc,
1031: jtf_tty_srch_my_resources_v repdn
1032: where narsc.resource_id = repdn.resource_id
1033: and narsc.rsc_group_id = repdn.group_id
1034: and repdn.current_user_id = c_user_id

Line 1041: from jtf_tty_named_acct_rsc narsc

1037: CURSOR c_res_for_tg_account(c_tg_acct_id VARCHAR2, c_user_id NUMBER ) IS
1038: select narsc.resource_id resource_id,
1039: narsc.rsc_group_id group_id,
1040: narsc.rsc_role_code role_code
1041: from jtf_tty_named_acct_rsc narsc
1042: where narsc.terr_group_account_id = c_tg_acct_id
1043: and narsc.rsc_resource_type = 'RS_EMPLOYEE'
1044: and (narsc.resource_id, narsc.rsc_group_id, narsc.rsc_role_code ) IN
1045: ( select /*+ NO_MERGE */ mydir.resource_id, mydir.group_id, mydir.role_code

Line 1062: from jtf_tty_named_acct_rsc narsc,

1058: ( select /*+ NO_MERGE */
1059: repmgr.parent_resource_id,
1060: grpmem.group_id,
1061: rol.role_code
1062: from jtf_tty_named_acct_rsc narsc,
1063: jtf_rs_rep_managers repmgr,
1064: jtf_rs_role_relations rlt,
1065: jtf_rs_roles_b rol,
1066: jtf_rs_group_members grpmem

Line 1489: from jtf_tty_named_acct_rsc narsc,

1485: ttygrp.active_to_date >= sysdate
1486: )
1487: and ga.terr_group_account_id IN
1488: ( select /*+ NO_MERGE */ narsc.terr_group_account_id
1489: from jtf_tty_named_acct_rsc narsc,
1490: jtf_tty_srch_my_resources_v repdn
1491: where narsc.resource_id = repdn.resource_id
1492: and narsc.rsc_group_id = repdn.group_id
1493: and repdn.current_user_id = l_user_id