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.AMW_VALID_INSTANCE_SET_GRANTS dependencies on FND_GRANTS

Line 30: fnd_grants grants,

26: grants.parameter10 parameter10,
27: sets.instance_set_id instance_set_id,
28: sets.predicate predicate
29: from
30: fnd_grants grants,
31: fnd_object_instance_sets sets,
32: fnd_objects obj
33: where obj.obj_name = p_obj_name
34: AND grants.object_id = obj.object_id

Line 199: fnd_grants grants,

195: l_param8,
196: l_param9,
197: l_param10
198: from
199: fnd_grants grants,
200: fnd_object_instance_sets sets,
201: fnd_objects obj
202: where obj.obj_name = p_obj_name
203: AND grants.object_id = obj.object_id

Line 393: fnd_grants grants,

389: inst_id,
390: pred,
391: db_obj_name
392: from
393: fnd_grants grants,
394: fnd_object_instance_sets sets,
395: fnd_objects obj
396: where grants.grant_guid = p_guid
397: AND sets.instance_set_id = grants.instance_set_id

Line 537: ' from fnd_grants gr, fnd_object_instance_sets inst, fnd_objects fo ' ||

533: ' select '||''''''||' PERSON_NAME, to_number(ltrim(gr.grantee_key, '||''''||'HZ_PARTY:'||''''||')) PERSON_ID, '||''''''||' COMPANY_NAME, gr.menu_id ROLE_ID ' ||
534: /**05.03.2006 npanandi: appending below in the SELECT clause for PLM's R12 SQL change**/
535: ',gr.object_id '||
536: /**05.03.2006 npanandi: ends**/
537: ' from fnd_grants gr, fnd_object_instance_sets inst, fnd_objects fo ' ||
538: ' where gr.object_id = fo.object_id ' ||
539: ' and fo.obj_name = ' || ''''||p_object_name ||''''||
540: ' and gr.instance_type = '||''''||'SET'||'''' ||
541: ' and grantee_type = '||''''||'USER'||'''' ||