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_ACTIVATE_PKG dependencies on JTF_TTY_TERR_GRP_ACCTS

Line 56: FROM jtf_tty_terr_grp_accts ga,

52: FROM jtf_tty_align_accts aa
53: WHERE aa.alignment_id = c_alignment_id
54: AND aa.terr_group_account_id NOT IN
55: ( SELECT ga.terr_group_account_id
56: FROM jtf_tty_terr_grp_accts ga,
57: jtf_tty_terr_groups ttygrp,
58: jtf_tty_named_acct_rsc narsc,
59: jtf_tty_srch_my_resources_v repdn
60: WHERE ttygrp.terr_group_id = ga.terr_group_id

Line 78: , jtf_tty_terr_grp_accts tga

74: SELECT 'Y'
75: FROM jtf_tty_pterr_accts alpa
76: , jtf_tty_align_pterr alpt
77: , jtf_tty_align_accts alac
78: , jtf_tty_terr_grp_accts tga
79: WHERE alpt.align_proposed_terr_id = alpa.align_proposed_terr_id
80: AND alpa.align_acct_id = alac.align_acct_id
81: AND alac.terr_group_account_id = tga.terr_group_account_id
82: AND alac.alignment_id = c_alignment_id