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_MAINTAIN_NA_PVT dependencies on JTF_TERR_ALL

Line 123: FROM jtf_tty_terr_groups a, jtf_terr_all b

119: CURSOR c_validate_tg(l_tg_name VARCHAR2) IS
120: SELECT a.terr_group_id,
121: a.active_from_date,
122: NVL( a.active_to_date, ADD_MONTHS(a.active_from_date,120) ) active_to_date
123: FROM jtf_tty_terr_groups a, jtf_terr_all b
124: WHERE a.parent_terr_id = b.terr_id
125: AND upper(a.terr_group_name) = upper(l_tg_name)
126: -- and b.org_id = FND_PROFILE.VALUE('ORG_ID')
127: AND a.self_service_type = 'NAMED_ACCOUNT'

Line 633: FROM jtf_tty_terr_groups a, jtf_terr_all b

629: CURSOR c_validate_tg(l_tg_name VARCHAR2) IS
630: SELECT a.terr_group_id, a.matching_rule_code,
631: a.active_from_date,
632: NVL( a.active_to_date, ADD_MONTHS(a.active_from_date,120) ) active_to_date
633: FROM jtf_tty_terr_groups a, jtf_terr_all b
634: WHERE a.parent_terr_id = b.terr_id
635: AND upper(a.terr_group_name) like upper(l_tg_name)
636: AND a.self_service_type = 'NAMED_ACCOUNT'
637: AND a.active_from_date <= sysdate