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 742: from wf_local_roles incr1, fnd_user u1

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

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

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

Line 845: from wf_local_roles incr1, fnd_user u1

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

Line 2175: from wf_local_roles incr1, fnd_user u1

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

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

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

Line 2271: from wf_local_roles incr1, fnd_user u1

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

Line 2726: ' fnd_user f '||

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

Line 2744: ' fnd_user f '||

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

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

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

Line 3295: from wf_local_roles incr1, fnd_user u1

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

Line 3354: from wf_local_roles incr1, fnd_user u1

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

Line 3403: from wf_local_roles incr1, fnd_user u1

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

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

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

Line 3492: from wf_local_roles incr1, fnd_user u1

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

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

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

Line 3589: from wf_local_roles incr1, fnd_user u1

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

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

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

Line 3936: from wf_local_roles incr1, fnd_user u1

3932: (
3933: select l_user_name name from dual
3934: union all
3935: select incr1.name name
3936: from wf_local_roles incr1, fnd_user u1
3937: where 'HZ_PARTY' = incr1.orig_system
3938: and u1.user_name = l_user_name
3939: and u1.person_party_id = incr1.orig_system_id
3940: ) incr2

Line 5062: ' fnd_user f '||

5058: ' where wur.user_name in '||
5059: ' ( (select '||l_user_name_bind ||' from dual) '||
5060: ' union all '||
5061: ' (select incrns.name from wf_local_roles incrns, '||
5062: ' fnd_user f '||
5063: ' where ''HZ_PARTY'' = incrns.orig_system '||
5064: ' and f.user_name = '||l_user_name_bind ||
5065: ' and f.person_party_id = incrns.orig_system_id)))))';
5066:

Line 5082: ' fnd_user f '||

5078: ' from wf_user_roles wur, '||
5079: ' ( select '||l_user_name_bind ||' name from dual '||
5080: ' union all '||
5081: ' (select incrns.name from wf_local_roles incrns, '||
5082: ' fnd_user f '||
5083: ' where ''HZ_PARTY'' = incrns.orig_system '||
5084: ' and f.user_name = '||l_user_name_bind ||
5085: ' and f.person_party_id = incrns.orig_system_id '||
5086: ' and incrns.partition_id = 9 ) '||

Line 6138: FROM FND_USER_RESP_GROUPS FURG, FND_USER FU

6134: WITH FU_FURG AS
6135: (
6136: SELECT DISTINCT FU.USER_NAME, FURG.RESPONSIBILITY_ID,
6137: FURG.RESPONSIBILITY_APPLICATION_ID, FURG.SECURITY_GROUP_ID
6138: FROM FND_USER_RESP_GROUPS FURG, FND_USER FU
6139: WHERE FU.USER_NAME =L_USER_NAME
6140: AND FU.USER_ID = FURG.USER_ID
6141: ) ,
6142: FMEV_EXT AS

Line 6219: from wf_local_roles incr1, fnd_user u1

6215: (
6216: select L_USER_NAME name from dual
6217: union all
6218: select incr1.name name
6219: from wf_local_roles incr1, fnd_user u1
6220: where 'HZ_PARTY' = incr1.orig_system
6221: and u1.user_name = L_USER_NAME
6222: and u1.person_party_id = incr1.orig_system_id
6223: and incr1.partition_id = 9 /* HZ_PARTY */