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.FND_DATA_SECURITY dependencies on FND_USER

Line 741: from wf_local_roles incr1, fnd_user u1

737: (
738: select cp_user_name name from dual
739: union all
740: select incr1.name name
741: from wf_local_roles incr1, fnd_user u1
742: where 'HZ_PARTY' = incr1.orig_system
743: and u1.user_name = cp_user_name
744: and u1.person_party_id = incr1.orig_system_id
745: and incr1.partition_id = 9 /* HZ_PARTY */

Line 800: (select incrns.name from wf_local_roles incrns, fnd_user f

796: from wf_user_roles wur
797: where wur.user_name in
798: ( (select cp_user_name from dual)
799: union all
800: (select incrns.name from wf_local_roles incrns, fnd_user f
801: where 'HZ_PARTY' = incrns.orig_system
802: and f.user_name = cp_user_name
803: and f.person_party_id = incrns.orig_system_id)))))
804: OR (g.grantee_type = 'GLOBAL'))

Line 844: from wf_local_roles incr1, fnd_user u1

840: (
841: select cp_user_name name from dual
842: union all
843: select incr1.name name
844: from wf_local_roles incr1, fnd_user u1
845: where 'HZ_PARTY' = incr1.orig_system
846: and u1.user_name = cp_user_name
847: and u1.person_party_id = incr1.orig_system_id
848: and incr1.partition_id = 9 /* HZ_PARTY */

Line 2174: from wf_local_roles incr1, fnd_user u1

2170: (
2171: select cp_user_name name from dual
2172: union all
2173: select incr1.name name
2174: from wf_local_roles incr1, fnd_user u1
2175: where 'HZ_PARTY' = incr1.orig_system
2176: and u1.user_name = cp_user_name
2177: and u1.person_party_id = incr1.orig_system_id
2178: and incr1.partition_id = 9 /* HZ_PARTY */

Line 2231: (select incrns.name from wf_local_roles incrns, fnd_user f

2227: from wf_user_roles wur
2228: where wur.user_name in
2229: ( (select cp_user_name from dual)
2230: union all
2231: (select incrns.name from wf_local_roles incrns, fnd_user f
2232: where 'HZ_PARTY' = incrns.orig_system
2233: and f.user_name = cp_user_name
2234: and f.person_party_id = incrns.orig_system_id)))))
2235: OR (g.grantee_type = 'GLOBAL'))

Line 2270: from wf_local_roles incr1, fnd_user u1

2266: (
2267: select cp_user_name name from dual
2268: union all
2269: select incr1.name name
2270: from wf_local_roles incr1, fnd_user u1
2271: where 'HZ_PARTY' = incr1.orig_system
2272: and u1.user_name = cp_user_name
2273: and u1.person_party_id = incr1.orig_system_id
2274: and incr1.partition_id = 9 /* HZ_PARTY */

Line 2725: ' fnd_user f '||

2721: ' '''||replace(l_user_name,'''','''''')||''' '||
2722: ' from dual) '||
2723: ' union all '||
2724: ' (select incrns.name from wf_local_roles incrns, '||
2725: ' fnd_user f '||
2726: ' where ''HZ_PARTY'' = incrns.orig_system '||
2727: ' and f.user_name = '||
2728: ' '''||replace(l_user_name,'''','''''')||''' '||
2729: ' and f.person_party_id = incrns.orig_system_id)))) '||

Line 2743: ' fnd_user f '||

2739: ' '''||replace(l_user_name,'''','''''')||''' '||
2740: ' name from dual '||
2741: ' union all '||
2742: ' (select incrns.name from wf_local_roles incrns, '||
2743: ' fnd_user f '||
2744: ' where ''HZ_PARTY'' = incrns.orig_system '||
2745: ' and f.user_name = '||
2746: ' '''||replace(l_user_name,'''','''''')||''' '||
2747: ' and f.person_party_id = incrns.orig_system_id '||

Line 3248: (select incrns.name from wf_local_roles incrns, fnd_user f

3244: from wf_user_roles wur
3245: where wur.user_name in
3246: ( (select cp_user_name from dual)
3247: union all
3248: (select incrns.name from wf_local_roles incrns, fnd_user f
3249: where 'HZ_PARTY' = incrns.orig_system
3250: and f.user_name = cp_user_name
3251: and f.person_party_id = incrns.orig_system_id))))))
3252: and g.object_id = cp_object_id

Line 3293: from wf_local_roles incr1, fnd_user u1

3289: (
3290: select cp_user_name name from dual
3291: union all
3292: select incr1.name name
3293: from wf_local_roles incr1, fnd_user u1
3294: where 'HZ_PARTY' = incr1.orig_system
3295: and u1.user_name = cp_user_name
3296: and u1.person_party_id = incr1.orig_system_id
3297: and incr1.partition_id = 9 /* HZ_PARTY */

Line 3352: from wf_local_roles incr1, fnd_user u1

3348: (
3349: select cp_user_name name from dual
3350: union all
3351: select incr1.name name
3352: from wf_local_roles incr1, fnd_user u1
3353: where 'HZ_PARTY' = incr1.orig_system
3354: and u1.user_name = cp_user_name
3355: and u1.person_party_id = incr1.orig_system_id
3356: and incr1.partition_id = 9 /* HZ_PARTY */

Line 3401: from wf_local_roles incr1, fnd_user u1

3397: (
3398: select cp_user_name name from dual
3399: union all
3400: select incr1.name name
3401: from wf_local_roles incr1, fnd_user u1
3402: where 'HZ_PARTY' = incr1.orig_system
3403: and u1.user_name = cp_user_name
3404: and u1.person_party_id = incr1.orig_system_id
3405: and incr1.partition_id = 9 /* HZ_PARTY */

Line 3453: (select incrns.name from wf_local_roles incrns, fnd_user f

3449: from wf_user_roles wur
3450: where wur.user_name in
3451: ( (select cp_user_name from dual)
3452: union all
3453: (select incrns.name from wf_local_roles incrns, fnd_user f
3454: where 'HZ_PARTY' = incrns.orig_system
3455: and f.user_name = cp_user_name
3456: and f.person_party_id = incrns.orig_system_id)))))
3457: OR (g.grantee_type = 'GLOBAL'))

Line 3490: from wf_local_roles incr1, fnd_user u1

3486: (
3487: select cp_user_name name from dual
3488: union all
3489: select incr1.name name
3490: from wf_local_roles incr1, fnd_user u1
3491: where 'HZ_PARTY' = incr1.orig_system
3492: and u1.user_name = cp_user_name
3493: and u1.person_party_id = incr1.orig_system_id
3494: and incr1.partition_id = 9 /* HZ_PARTY */

Line 3547: (select incrns.name from wf_local_roles incrns, fnd_user f

3543: from wf_user_roles wur
3544: where wur.user_name in
3545: ( (select cp_user_name from dual)
3546: union all
3547: (select incrns.name from wf_local_roles incrns, fnd_user f
3548: where 'HZ_PARTY' = incrns.orig_system
3549: and f.user_name = cp_user_name
3550: and f.person_party_id = incrns.orig_system_id))))))
3551: AND g.object_id = cp_object_id

Line 3587: from wf_local_roles incr1, fnd_user u1

3583: (
3584: select cp_user_name name from dual
3585: union all
3586: select incr1.name name
3587: from wf_local_roles incr1, fnd_user u1
3588: where 'HZ_PARTY' = incr1.orig_system
3589: and u1.user_name = cp_user_name
3590: and u1.person_party_id = incr1.orig_system_id
3591: and incr1.partition_id = 9 /* HZ_PARTY */

Line 3637: (select incrns.name from wf_local_roles incrns, fnd_user f

3633: from wf_user_roles wur
3634: where wur.user_name in
3635: ( (select cp_user_name from dual)
3636: union all
3637: (select incrns.name from wf_local_roles incrns, fnd_user f
3638: where 'HZ_PARTY' = incrns.orig_system
3639: and f.user_name = cp_user_name
3640: and f.person_party_id = incrns.orig_system_id))))))
3641: AND g.object_id = cp_object_id

Line 5022: ' fnd_user f '||

5018: ' where wur.user_name in '||
5019: ' ( (select '||l_user_name_bind ||' from dual) '||
5020: ' union all '||
5021: ' (select incrns.name from wf_local_roles incrns, '||
5022: ' fnd_user f '||
5023: ' where ''HZ_PARTY'' = incrns.orig_system '||
5024: ' and f.user_name = '||l_user_name_bind ||
5025: ' and f.person_party_id = incrns.orig_system_id)))))';
5026:

Line 5042: ' fnd_user f '||

5038: ' from wf_user_roles wur, '||
5039: ' ( select '||l_user_name_bind ||' name from dual '||
5040: ' union all '||
5041: ' (select incrns.name from wf_local_roles incrns, '||
5042: ' fnd_user f '||
5043: ' where ''HZ_PARTY'' = incrns.orig_system '||
5044: ' and f.user_name = '||l_user_name_bind ||
5045: ' and f.person_party_id = incrns.orig_system_id '||
5046: ' and incrns.partition_id = 9 ) '||