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.PV_USER_RESP_PVT dependencies on JTF_AUTH_ROLE_PERMS

Line 249: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

245: AND fndu.start_date <= sysdate
246: AND (fndu.end_date is null or fndu.end_date > sysdate)
247: AND exists (
248: SELECT jtfp1.principal_name username
249: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
250: WHERE jtfp1.is_user_flag=1
251: AND jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id
252: AND jtfp2.jtf_auth_principal_id=jtfpm.jtf_auth_parent_principal_id
253: AND jtfp2.is_user_flag=0

Line 288: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm

284: AND fndu.start_date <= sysdate
285: AND (fndu.end_date is null or fndu.end_date > sysdate)
286: AND exists (
287: SELECT jtfp1.principal_name username
288: FROM jtf_auth_principal_maps jtfpm, jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd, jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp, jtf_auth_permissions_b jtfperm
289: WHERE jtfp1.is_user_flag = 1
290: AND jtfp1.jtf_auth_principal_id = jtfpm.jtf_auth_principal_id
291: AND jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id
292: AND jtfp2.is_user_flag = 0

Line 830: jtf_auth_role_perms jtfrp,

826: SELECT jtfperm.permission_name
827: FROM jtf_auth_principal_maps jtfpm,
828: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
829: jtf_auth_principals_b jtfp2,
830: jtf_auth_role_perms jtfrp,
831: jtf_auth_permissions_b jtfperm,
832: fnd_user fndu
833: WHERE fndu.user_id = p_user_id
834: AND jtfp1.principal_name = fndu.user_name

Line 5684: jtf_auth_role_perms jtfrp,

5680: FROM jtf_auth_principal_maps jtfpm,
5681: jtf_auth_principals_b jtfp1,
5682: jtf_auth_domains_b jtfd,
5683: jtf_auth_principals_b jtfp2,
5684: jtf_auth_role_perms jtfrp,
5685: jtf_auth_permissions_b jtfperm
5686: WHERE jtfp1.is_user_flag=1
5687: AND jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id
5688: AND jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id

Line 5728: jtf_auth_role_perms jtfrp,

5724: FROM jtf_auth_principal_maps jtfpm,
5725: jtf_auth_principals_b jtfp1,
5726: jtf_auth_domains_b jtfd,
5727: jtf_auth_principals_b jtfp2,
5728: jtf_auth_role_perms jtfrp,
5729: jtf_auth_permissions_b jtfperm
5730: WHERE jtfp1.is_user_flag=1
5731: AND jtfp1.jtf_auth_principal_id=jtfpm.jtf_auth_principal_id
5732: AND jtfpm.jtf_auth_parent_principal_id = jtfp2.jtf_auth_principal_id