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_CATCHALL_WORKFLOW dependencies on AS_TERRITORY_ACCESSES

Line 52: , as_territory_accesses ATA

48: from HZ_PARTY_SITES SITE
49: , HZ_LOCATIONS LOC
50: , HZ_PARTIES PARTY
51: , as_accesses_all AAA
52: , as_territory_accesses ATA
53: , AS_SALES_LEADS SL
54: where SITE.party_id = PARTY.party_id
55: and LOC.location_id = SITE.location_id
56: and SL.customer_id = PARTY.party_id

Line 76: , as_territory_accesses ATA

72: , HZ_LOCATIONS LOC
73: , HZ_PARTIES PARTY
74: , AS_LEADS_ALL LEAD
75: , as_accesses_all AAA
76: , as_territory_accesses ATA
77: where SITE.party_id = PARTY.party_id
78: and LOC.location_id = SITE.location_id
79: and LEAD.customer_id = PARTY.party_id
80: and LEAD.address_id = SITE.party_site_id

Line 98: , as_territory_accesses ATA

94: from HZ_PARTY_SITES SITE
95: , HZ_LOCATIONS LOC
96: , HZ_PARTIES PARTY
97: , as_accesses_all AAA
98: , as_territory_accesses ATA
99: where SITE.party_id = PARTY.party_id
100: and LOC.location_id = SITE.location_id
101: AND AAA.ACCESS_ID = ATA.ACCESS_ID
102: AND ATA.TERRITORY_ID = l_terr_id