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.

[Home] [Help]

APPS.JTF_TTY_OVERLAP_WEBADI_PKG dependencies on JTF_TERR_ALL

Line 89: ,jtf_terr_all TER

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
92: and TG.parent_terr_id = TER.terr_id
93: and trunc(TG.active_from_date) <= trunc(sysdate)