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_ORG_HIERARCHY_PKG dependencies on FND_MENUS

Line 930: fnd_menus granted_menu,

926: obj.obj_name object_name,
927: granted_menu.menu_id menu_id,
928: grants.end_date end_date
929: FROM fnd_grants grants,
930: fnd_menus granted_menu,
931: fnd_objects obj
932: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
933: AND grants.object_id = obj.object_id
934: AND grants.grantee_type ='USER'

Line 7049: fnd_menus granted_menu,

7045: obj.obj_name object_name,
7046: granted_menu.menu_id menu_id,
7047: grants.end_date end_date
7048: FROM fnd_grants grants,
7049: fnd_menus granted_menu,
7050: fnd_objects obj
7051: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7052: AND grants.object_id = obj.object_id
7053: AND grants.grantee_type ='USER'

Line 7070: fnd_menus granted_menu,

7066:
7067: cursor org_only_party_list(org_id number, process_id number, org_menu_name varchar2, rl_menu_name varchar2) is
7068: SELECT grants.grant_guid grant_guid
7069: FROM fnd_grants grants,
7070: fnd_menus granted_menu,
7071: fnd_objects obj
7072: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
7073: AND grants.object_id = obj.object_id
7074: AND grants.grantee_type ='USER'

Line 7091: fnd_menus granted_menu,

7087: AND grants.instance_pk5_value = '*NULL*'
7088: and granted_menu.menu_name = org_menu_name
7089: and (grants.grantee_key, obj.object_id ,grants.menu_id ) not in (select grants.grantee_key,obj.object_id, grants.menu_id
7090: FROM fnd_grants grants,
7091: fnd_menus granted_menu,
7092: fnd_objects obj
7093: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7094: AND grants.object_id = obj.object_id
7095: AND grants.grantee_type ='USER'

Line 7273: fnd_menus granted_menu,

7269:
7270: SELECT grants.grant_guid grant_guid
7271: BULK COLLECT INTO l_grant_guid
7272: FROM fnd_grants grants,
7273: fnd_menus granted_menu,
7274: fnd_objects obj
7275: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
7276: AND grants.object_id = obj.object_id
7277: AND grants.grantee_type ='USER'

Line 7290: fnd_menus granted_menu,

7286: AND grants.instance_pk5_value = '*NULL*'
7287: and granted_menu.menu_name = p_org_menu_name
7288: and (grants.grantee_key) not in ( select grants.grantee_key
7289: FROM fnd_grants grants,
7290: fnd_menus granted_menu,
7291: fnd_objects obj
7292: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7293: AND grants.object_id = obj.object_id
7294: AND grants.grantee_type ='USER'

Line 7363: fnd_menus granted_menu,

7359: grants.end_date end_date
7360: BULK COLLECT INTO l_party_id,
7361: l_end_date
7362: FROM fnd_grants grants,
7363: fnd_menus granted_menu,
7364: fnd_objects obj
7365: WHERE obj.obj_name = 'AMW_PROCESS_APPR_ETTY'
7366: AND grants.object_id = obj.object_id
7367: AND grants.grantee_type ='USER'

Line 7380: fnd_menus granted_menu,

7376: AND grants.instance_pk5_value = '*NULL*'
7377: and granted_menu.menu_name = p_rl_menu_name
7378: and (grants.grantee_key) not in ( select grants.grantee_key
7379: FROM fnd_grants grants,
7380: fnd_menus granted_menu,
7381: fnd_objects obj
7382: WHERE obj.obj_name = 'AMW_PROCESS_ORGANIZATION'
7383: AND grants.object_id = obj.object_id
7384: AND grants.grantee_type ='USER'