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.ASP_CONTACT_PREF_SECURITY_PUB dependencies on JTF_RS_GROUP_USAGES

Line 85: jtf_rs_group_usages jrgu

81: AND salesforce_id = res.resource_id)
82: AND NOT EXISTS (
83: SELECT jrrm.group_id,resource_id
84: FROM jtf_rs_rep_managers jrrm ,
85: jtf_rs_group_usages jrgu
86:
87: WHERE jrgu.usage in ('SALES', 'PRM')
88: AND jrgu.group_id = jrrm.group_id
89: AND jrrm.start_date_active <= trunc(SYSDATE)

Line 123: JTF_RS_GROUP_USAGES jrgu,

119: AND PP.PARTY_ID = per.PARTY_ID
120: AND NOT EXISTS(
121: SELECT 1
122: FROM JTF_RS_REP_MANAGERS jrrm,
123: JTF_RS_GROUP_USAGES jrgu,
124: AS_ACCESSES_ALL aaa
125: WHERE jrgu.usage IN ('SALES', 'PRM')
126: AND jrgu.group_id = jrrm.group_id
127: AND jrrm.hierarchy_type IN ('MGR_TO_MGR', 'MGR_TO_REP')

Line 147: jtf_rs_group_usages jrgu

143: AND salesforce_id = res.resource_id)
144: AND EXISTS (
145: SELECT jrrm.group_id,resource_id
146: FROM jtf_rs_rep_managers jrrm ,
147: jtf_rs_group_usages jrgu
148: WHERE jrgu.usage in ('SALES', 'PRM')
149: AND jrgu.group_id = jrrm.group_id
150: AND jrrm.start_date_active <= trunc(SYSDATE)
151: AND NVL(jrrm.end_date_active, SYSDATE) >= trunc(SYSDATE)