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 DUAL

Line 720: -- select 'GLOBAL' from dual first.

716: l_function_id number;
717: l_user_name varchar2(80);
718:
719: -- Performance bug 5080621. Flipped the order of 'union all' to do
720: -- select 'GLOBAL' from dual first.
721: -- Done similar changes in the following cursors also.
722: -- instance_set_grants_c (in get_security_predicate_helper api)
723: -- isg_grp_glob_fn_c (in get_security_predicate_intrnl api)
724: -- isg_grp_glob_nofn_c (in get_security_predicate_intrnl api)

Line 733: ( select /+ NO_MERGE / 'GLOBAL' role_name from dual

729: cp_object_id in NUMBER
730: ) IS
731: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */ 'X'
732: FROM
733: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
734: union all
735: select role_name
736: from wf_user_roles wur,
737: (

Line 738: select cp_user_name name from dual

734: union all
735: select role_name
736: from wf_user_roles wur,
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

Line 798: ( (select cp_user_name from dual)

794: and (g.grantee_key in
795: (select role_name
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

Line 841: select cp_user_name name from dual

837: FROM
838: ( select /*+ NO_MERGE */ role_name
839: from wf_user_roles wur,
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

Line 2166: ( select /+ NO_MERGE / 'GLOBAL' role_name from dual

2162: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */
2163: UNIQUE
2164: instance_sets.predicate, instance_sets.instance_set_id
2165: FROM
2166: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
2167: union all
2168: select role_name
2169: from wf_user_roles wur,
2170: (

Line 2171: select cp_user_name name from dual

2167: union all
2168: select role_name
2169: from wf_user_roles wur,
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

Line 2229: ( (select cp_user_name from dual)

2225: AND (g.grantee_key in
2226: (select role_name
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

Line 2267: select cp_user_name name from dual

2263: FROM
2264: ( select /*+ NO_MERGE */ role_name
2265: from wf_user_roles wur,
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

Line 2722: ' from dual) '||

2718: ' from wf_user_roles wur '||
2719: ' where wur.user_name in '||
2720: ' ( (select '||
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 '||

Line 2740: ' name from dual '||

2736: ' (select role_name '||
2737: ' from wf_user_roles wur, '||
2738: ' ( select '||
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 '||

Line 2752: ' select ''GLOBAL'' from dual))';

2748: ' and incrns.partition_id = 9 ) '||
2749: ' ) incr2 '||
2750: ' where wur.user_name = incr2.name '||
2751: ' union all '||
2752: ' select ''GLOBAL'' from dual))';
2753: end if;
2754: if (l_function_id <> -1) then
2755: l_aggregate_predicate := l_aggregate_predicate ||
2756: ' AND GNT.menu_id in'||

Line 3193: dual

3189: cp_object_id VARCHAR2,
3190: cp_instance_type VARCHAR2)
3191: IS
3192: select 1 from
3193: dual
3194: where exists
3195: (
3196: SELECT 1
3197: FROM fnd_grants g

Line 3234: from dual

3230: cp_object_id VARCHAR2,
3231: cp_instance_type VARCHAR2)
3232: IS
3233: select 1
3234: from dual
3235: where exists
3236: (
3237: select 1
3238: from fnd_grants g

Line 3246: ( (select cp_user_name from dual)

3242: AND (g.grantee_key in
3243: (select role_name
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

Line 3282: dual

3278: cp_object_id VARCHAR2,
3279: cp_instance_type VARCHAR2)
3280: IS
3281: select 1 from
3282: dual
3283: where exists
3284: (
3285: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */ 'X'
3286: FROM

Line 3290: select cp_user_name name from dual

3286: FROM
3287: ( select /*+ NO_MERGE */ role_name
3288: from wf_user_roles wur,
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

Line 3344: ( select /+ NO_MERGE / 'GLOBAL' role_name from dual

3340: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */
3341: instance_sets.predicate, instance_sets.instance_set_id,
3342: g.grant_guid
3343: FROM
3344: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
3345: union all
3346: select role_name
3347: from wf_user_roles wur,
3348: (

Line 3349: select cp_user_name name from dual

3345: union all
3346: select role_name
3347: from wf_user_roles wur,
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

Line 3393: ( select /+ NO_MERGE / 'GLOBAL' role_name from dual

3389: SELECT /*+ leading(u2) use_nl(g) index(g,FND_GRANTS_N9) */
3390: instance_sets.predicate, instance_sets.instance_set_id,
3391: g.grant_guid
3392: FROM
3393: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
3394: union all
3395: select role_name
3396: from wf_user_roles wur,
3397: (

Line 3398: select cp_user_name name from dual

3394: union all
3395: select role_name
3396: from wf_user_roles wur,
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

Line 3451: ( (select cp_user_name from dual)

3447: AND (g.grantee_key in
3448: (select role_name
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

Line 3487: select cp_user_name name from dual

3483: FROM
3484: ( select /*+ NO_MERGE */ role_name
3485: from wf_user_roles wur,
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

Line 3545: ( (select cp_user_name from dual)

3541: AND (g.grantee_key in
3542: (select role_name
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

Line 3584: select cp_user_name name from dual

3580: FROM
3581: ( select /*+ NO_MERGE */ role_name
3582: from wf_user_roles wur,
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

Line 3635: ( (select cp_user_name from dual)

3631: AND (g.grantee_key in
3632: (select role_name
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

Line 5019: ' ( (select '||l_user_name_bind ||' from dual) '||

5015: ' AND GNT.grantee_key in ' ||
5016: ' (select role_name '||
5017: ' from wf_user_roles wur '||
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 '||

Line 5039: ' ( select '||l_user_name_bind ||' name from dual '||

5035: l_instance_predicate := l_instance_predicate ||
5036: ' (GNT.grantee_key in '||
5037: ' (select role_name '||
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 '||

Line 5053: ' select ''GLOBAL'' from dual ';

5049:
5050: if (l_inst_global_grantee_type) then
5051: l_instance_predicate := l_instance_predicate ||
5052: ' union all '||
5053: ' select ''GLOBAL'' from dual ';
5054: end if;
5055:
5056: l_instance_predicate := l_instance_predicate ||
5057: ' ) ) ';