VIEW: APPS.MTL_OBJECT_GRANTS_V

Source

View Text - Preformatted

SELECT menus.menu_name role_name, menus.menu_id role_id, Hz_parties.party_name party_name, Hz_parties.party_id party_id, Grants.start_date start_date, Grants.end_date end_date, Grants.instance_pk1_value instance_pk1_value, Grants.instance_pk2_value instance_pk2_value, Grants.grantee_type grantee_type, Grants.grantee_key grantee_key, Grants.grant_guid grant_guid, Grants.object_id object_id, Grants.last_update_date last_update_date, Grants.last_updated_by last_updated_by, Grants.creation_date creation_date, Grants.created_by created_by, Grants.last_update_login last_update_login, Objects.obj_name object_name FROM Fnd_menus menus, Hz_parties hz_parties, fnd_grants grants, fnd_objects_vl objects WHERE ((grants.grantee_type = 'USER' AND grants.grantee_key = 'HZ_PARTY:' || hz_parties.party_id) OR (grants.grantee_type = 'GROUP' AND grants.grantee_key = 'HZ_GROUP:' || hz_parties.party_id)) AND grants.menu_id = menus.menu_id AND grants.instance_type = 'INSTANCE' AND grants.object_id = objects.object_id

View Text - HTML Formatted

SELECT MENUS.MENU_NAME ROLE_NAME
, MENUS.MENU_ID ROLE_ID
, HZ_PARTIES.PARTY_NAME PARTY_NAME
, HZ_PARTIES.PARTY_ID PARTY_ID
, GRANTS.START_DATE START_DATE
, GRANTS.END_DATE END_DATE
, GRANTS.INSTANCE_PK1_VALUE INSTANCE_PK1_VALUE
, GRANTS.INSTANCE_PK2_VALUE INSTANCE_PK2_VALUE
, GRANTS.GRANTEE_TYPE GRANTEE_TYPE
, GRANTS.GRANTEE_KEY GRANTEE_KEY
, GRANTS.GRANT_GUID GRANT_GUID
, GRANTS.OBJECT_ID OBJECT_ID
, GRANTS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GRANTS.LAST_UPDATED_BY LAST_UPDATED_BY
, GRANTS.CREATION_DATE CREATION_DATE
, GRANTS.CREATED_BY CREATED_BY
, GRANTS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECTS.OBJ_NAME OBJECT_NAME
FROM FND_MENUS MENUS
, HZ_PARTIES HZ_PARTIES
, FND_GRANTS GRANTS
, FND_OBJECTS_VL OBJECTS
WHERE ((GRANTS.GRANTEE_TYPE = 'USER'
AND GRANTS.GRANTEE_KEY = 'HZ_PARTY:' || HZ_PARTIES.PARTY_ID) OR (GRANTS.GRANTEE_TYPE = 'GROUP'
AND GRANTS.GRANTEE_KEY = 'HZ_GROUP:' || HZ_PARTIES.PARTY_ID))
AND GRANTS.MENU_ID = MENUS.MENU_ID
AND GRANTS.INSTANCE_TYPE = 'INSTANCE'
AND GRANTS.OBJECT_ID = OBJECTS.OBJECT_ID