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 721: -- select 'GLOBAL' from dual first.

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

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

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

Line 739: select cp_user_name name from dual

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

Line 799: ( (select cp_user_name from dual)

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

Line 842: select cp_user_name name from dual

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

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

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

Line 2172: select cp_user_name name from dual

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

Line 2230: ( (select cp_user_name from dual)

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

Line 2268: select cp_user_name name from dual

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

Line 2723: ' from dual) '||

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

Line 2741: ' name from dual '||

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

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

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

Line 3195: dual

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

Line 3236: from dual

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

Line 3248: ( (select cp_user_name from dual)

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

Line 3284: dual

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

Line 3292: select cp_user_name name from dual

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

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

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

Line 3351: select cp_user_name name from dual

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

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

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

Line 3400: select cp_user_name name from dual

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

Line 3453: ( (select cp_user_name from dual)

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

Line 3489: select cp_user_name name from dual

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

Line 3547: ( (select cp_user_name from dual)

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

Line 3586: select cp_user_name name from dual

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

Line 3637: ( (select cp_user_name from dual)

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

Line 3929: from ( select /+ NO_MERGE / 'GLOBAL' role_name from dual union all

3925: end if;
3926:
3927: SELECT Max(LAST_UPDATE_DATE)
3928: INTO l_last_update_date
3929: from ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual union all
3930: select role_name
3931: from wf_user_roles wur,
3932: (
3933: select l_user_name name from dual

Line 3933: select l_user_name name from dual

3929: from ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual union all
3930: select role_name
3931: from wf_user_roles wur,
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

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

5055: ' AND GNT.grantee_key in ' ||
5056: ' (select role_name '||
5057: ' from wf_user_roles wur '||
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 '||

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

5075: l_instance_predicate := l_instance_predicate ||
5076: ' (GNT.grantee_key in '||
5077: ' (select role_name '||
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 '||

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

5089:
5090: if (l_inst_global_grantee_type) then
5091: l_instance_predicate := l_instance_predicate ||
5092: ' union all '||
5093: ' select ''GLOBAL'' from dual ';
5094: end if;
5095:
5096: l_instance_predicate := l_instance_predicate ||
5097: ' ) ) ';

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

6207: FLAT.function_id, FLAT.RESPONSIBILITY_NAME,FLAT.RESPONSIBILITY_ID, FLAT.application_id, FLAT.security_group_id, prompt1.menu_id, prompt1.prompt
6208: from
6209: (select function_id, grants.ctx_secgrp_id, grants.ctx_resp_id, grants.ctx_resp_appl_id
6210: from (select /*+ no_merge */ distinct g.menu_id, g.ctx_secgrp_id, g.ctx_resp_id, g.ctx_resp_appl_id from
6211: ( select /*+ NO_MERGE */ 'GLOBAL' role_name from dual
6212: union all
6213: select role_name
6214: from wf_user_roles wur,
6215: (

Line 6216: select L_USER_NAME name from dual

6212: union all
6213: select role_name
6214: from wf_user_roles wur,
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