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_OBJECT_INSTANCE_SETS

Line 2183: fnd_object_instance_sets instance_sets

2179: ) incr2
2180: where wur.user_name = incr2.name
2181: ) u2,
2182: fnd_grants g,
2183: fnd_object_instance_sets instance_sets
2184: WHERE g.instance_type = 'SET'
2185: AND g.grantee_key = u2.role_name
2186: AND g.object_id = cp_object_id
2187: AND ( (cp_function_id = -1)

Line 2220: fnd_object_instance_sets instance_sets

2216: IS
2217: SELECT UNIQUE
2218: instance_sets.predicate, instance_sets.instance_set_id
2219: FROM fnd_grants g,
2220: fnd_object_instance_sets instance_sets
2221: WHERE g.instance_type = 'SET'
2222: AND (( g.grantee_type = 'USER'
2223: AND g.grantee_key = cp_user_name)
2224: OR ( g.grantee_type = 'GROUP'

Line 2279: fnd_object_instance_sets instance_sets

2275: ) incr2
2276: where wur.user_name = incr2.name
2277: ) u2,
2278: fnd_grants g,
2279: fnd_object_instance_sets instance_sets
2280: WHERE g.instance_type = 'SET'
2281: AND g.grantee_key = u2.role_name
2282: AND g.object_id = cp_object_id
2283: AND ( (cp_function_id = -1)

Line 3361: fnd_object_instance_sets instance_sets

3357: ) incr2
3358: where wur.user_name = incr2.name
3359: ) u2,
3360: fnd_grants g,
3361: fnd_object_instance_sets instance_sets
3362: WHERE g.grantee_key = u2.role_name
3363: AND g.instance_type = 'SET'
3364: AND g.object_id = cp_object_id
3365: AND (g.menu_id in

Line 3410: fnd_object_instance_sets instance_sets

3406: ) incr2
3407: where wur.user_name = incr2.name
3408: ) u2,
3409: fnd_grants g,
3410: fnd_object_instance_sets instance_sets
3411: WHERE g.grantee_key = u2.role_name
3412: AND g.object_id = cp_object_id
3413: AND g.instance_set_id = instance_sets.instance_set_id
3414: AND ( g.ctx_secgrp_id = -1

Line 3442: fnd_object_instance_sets instance_sets

3438: IS
3439: SELECT instance_sets.predicate, instance_sets.instance_set_id,
3440: g.grant_guid
3441: FROM fnd_grants g,
3442: fnd_object_instance_sets instance_sets
3443: WHERE g.instance_type = 'SET'
3444: AND( (g.grantee_type = 'USER'
3445: AND g.grantee_key = cp_user_name)
3446: OR (g.grantee_type = 'GROUP'

Line 3499: fnd_object_instance_sets instance_sets

3495: ) incr2
3496: where wur.user_name = incr2.name
3497: ) u2,
3498: fnd_grants g,
3499: fnd_object_instance_sets instance_sets
3500: WHERE g.grantee_key = u2.role_name
3501: AND g.object_id = cp_object_id
3502: AND (g.menu_id in
3503: (select cmf.menu_id

Line 3536: fnd_object_instance_sets instance_sets

3532: IS
3533: SELECT instance_sets.predicate, instance_sets.instance_set_id,
3534: g.grant_guid
3535: FROM fnd_grants g,
3536: fnd_object_instance_sets instance_sets
3537: WHERE g.instance_type = 'SET'
3538: AND ( (g.grantee_type = 'USER'
3539: AND g.grantee_key = cp_user_name)
3540: OR ( g.grantee_type = 'GROUP'

Line 3596: fnd_object_instance_sets instance_sets

3592: ) incr2
3593: where wur.user_name = incr2.name
3594: ) u2,
3595: fnd_grants g,
3596: fnd_object_instance_sets instance_sets
3597: WHERE g.grantee_key = u2.role_name
3598: AND g.object_id = cp_object_id
3599: AND g.instance_set_id = instance_sets.instance_set_id
3600: AND ( g.ctx_secgrp_id = -1

Line 3626: FROM fnd_grants g, fnd_object_instance_sets instance_sets

3622: cp_object_id VARCHAR2)
3623: IS
3624: SELECT instance_sets.predicate, instance_sets.instance_set_id,
3625: g.grant_guid
3626: FROM fnd_grants g, fnd_object_instance_sets instance_sets
3627: WHERE g.instance_type = 'SET'
3628: AND ( (g.grantee_type = 'USER'
3629: AND g.grantee_key = cp_user_name)
3630: OR (g.grantee_type = 'GROUP'

Line 3667: fnd_object_instance_sets instance_sets

3663: IS
3664: SELECT instance_sets.predicate, instance_sets.instance_set_id,
3665: g.grant_guid
3666: FROM fnd_grants g,
3667: fnd_object_instance_sets instance_sets
3668: WHERE g.instance_type = 'SET'
3669: AND (g.grantee_type = 'GLOBAL')
3670: AND g.object_id = cp_object_id
3671: AND (g.menu_id in

Line 3698: fnd_object_instance_sets instance_sets

3694: IS
3695: SELECT instance_sets.predicate, instance_sets.instance_set_id,
3696: g.grant_guid
3697: FROM fnd_grants g,
3698: fnd_object_instance_sets instance_sets
3699: WHERE g.instance_type = 'SET'
3700: AND (g.grantee_type = 'GLOBAL')
3701: AND g.object_id = cp_object_id
3702: AND g.instance_set_id = instance_sets.instance_set_id