View: MTL_CATEGORY_GRANTS_V

Product:	INV - Inventory
Description:	Provides information regarding parties and roles on categories
Implementation/DBA Data:	APPS.MTL_CATEGORY_GRANTS_V

View Text

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_PK2_VALUE CATEGORY_SET_ID
, GRANTS.INSTANCE_PK1_VALUE CATEGORY_ID
, 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
AND OBJECTS.OBJ_NAME = 'INV_CATEGORY'

Columns