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_POP_TERR_ADMIN_BIN_PVT dependencies on AS_ACCESSES_ALL

Line 65: as_accesses_all AAA

61: --Accounts
62: SELECT /*+ INDEX (AAA as_accesses_u1) */ COUNT(*)
63: INTO L_ACCOUNTS
64: FROM
65: as_accesses_all AAA
66: , as_territory_accesses ATA
67: WHERE AAA.ACCESS_ID = ATA.ACCESS_ID
68: AND ATA.TERRITORY_ID = l_list.terr_id
69: AND LEAD_ID IS NULL

Line 77: as_accesses_all AAA

73: -- Leads
74: SELECT /*+ INDEX (AAA as_accesses_u1) */ COUNT(*)
75: INTO L_LEADS
76: FROM
77: as_accesses_all AAA
78: , as_territory_accesses ATA
79: WHERE AAA.ACCESS_ID = ATA.ACCESS_ID
80: AND ATA.TERRITORY_ID = l_list.terr_id
81: AND LEAD_ID IS NULL

Line 89: as_accesses_all AAA

85: -- Opportunities
86: SELECT /*+ INDEX (AAA as_accesses_u1) */ COUNT(*)
87: INTO L_OPPORTUNITIES
88: FROM
89: as_accesses_all AAA
90: , as_territory_accesses ATA
91: WHERE AAA.ACCESS_ID = ATA.ACCESS_ID
92: AND ATA.TERRITORY_ID = l_list.terr_id
93: AND LEAD_ID IS NOT NULL