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.ASO_SALES_TEAM_PVT dependencies on DUAL

Line 60: from dual where not exists (select 1 from

56: FND_GLOBAL.USER_ID ,
57: SYSDATE,
58: null,
59: null
60: from dual where not exists (select 1 from
61: ASO_QUOTE_ACCESSES where resource_id = p_WinningTerrMember_tbl.resource_id(l_index)
62: and quote_number = P_Qte_Header_Rec.quote_number);
63:
64:

Line 170: AND tm.resource_type = 'INDIVIDUAL'

166: AND tu.team_id = t.team_id
167: AND tu.usage IN ('SALES','PRM')
168: AND tm.team_member_id = trr.role_resource_id
169: AND tm.delete_flag <> 'Y'
170: AND tm.resource_type = 'INDIVIDUAL'
171: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
172: AND trr.delete_flag <> 'Y'
173: AND SYSDATE BETWEEN trr.start_date_active
174: AND NVL(trr.end_date_active,SYSDATE)