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 2184: fnd_object_instance_sets instance_sets

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

Line 2221: fnd_object_instance_sets instance_sets

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

Line 2280: fnd_object_instance_sets instance_sets

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

Line 3363: fnd_object_instance_sets instance_sets

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

Line 3412: fnd_object_instance_sets instance_sets

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

Line 3444: fnd_object_instance_sets instance_sets

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

Line 3501: fnd_object_instance_sets instance_sets

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

Line 3538: fnd_object_instance_sets instance_sets

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

Line 3598: fnd_object_instance_sets instance_sets

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

Line 3628: FROM fnd_grants g, fnd_object_instance_sets instance_sets

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

Line 3669: fnd_object_instance_sets instance_sets

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

Line 3700: fnd_object_instance_sets instance_sets

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