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

Line 81: from jtf_tty_terr_grp_accts

77: l_PARENT20 VARCHAR2(360);
78:
79: cursor c_NA_in_TG is
80: select distinct named_account_id
81: from jtf_tty_terr_grp_accts
82: where terr_group_id = p_terr_group_id;
83:
84: cursor c_conflicting_TG(c_named_account_id VARCHAR2) is
85: select distinct TG.terr_group_name

Line 87: from jtf_tty_terr_grp_accts TGA

83:
84: cursor c_conflicting_TG(c_named_account_id VARCHAR2) is
85: select distinct TG.terr_group_name
86: , TER.name parent_territory
87: from jtf_tty_terr_grp_accts TGA
88: ,jtf_tty_terr_groups TG
89: ,jtf_terr_all TER
90: where TGA.named_account_id = c_named_account_id
91: and TGA.terr_group_id = TG.terr_group_id