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_NACCT_SALES_PUB dependencies on JTF_TTY_NAMED_ACCTS

Line 148: jtf_tty_named_accts nai,

144: -- QUERY MODIFIED FOR TERR_GROUP_ACCOUNT_ID IN/OUT
145: cursor c_subsidiaries(cl_terr_group_account_id number) is
146: select distinct gao.terr_group_account_id
147: from hz_relationships hzr,
148: jtf_tty_named_accts nai,
149: jtf_tty_terr_grp_accts gai,
150: jtf_tty_named_accts nao,
151: jtf_tty_terr_grp_accts gao
152: where gao.named_account_id = nao.named_account_id

Line 150: jtf_tty_named_accts nao,

146: select distinct gao.terr_group_account_id
147: from hz_relationships hzr,
148: jtf_tty_named_accts nai,
149: jtf_tty_terr_grp_accts gai,
150: jtf_tty_named_accts nao,
151: jtf_tty_terr_grp_accts gao
152: where gao.named_account_id = nao.named_account_id
153: and nao.party_id = hzr.object_id -- these are the subsidiary parties
154: and hzr.subject_table_name = 'HZ_PARTIES'

Line 166: -- jtf_tty_named_accts na,

162: -- subsidiaries that are owned by user
163: and exists( select 'Y'
164: from jtf_tty_named_acct_rsc narsc ,
165: jtf_tty_my_resources_v repdn
166: -- jtf_tty_named_accts na,
167: -- jtf_tty_terr_grp_accts ga
168: where narsc.terr_group_account_id = gao.terr_group_account_id
169: -- and ga.named_account_id = na.named_account_id
170: and narsc.resource_id = repdn.resource_id