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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_GRANTS

Object Details

Object Name:	FND_GRANTS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_GRANTS
Subobject Name:
Status:	VALID

Grants are rows that indicate a user or group has permission to execute
a menu (role) of functions, under a specific context

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_GRANTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GRANT_GUID
FND_GRANTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRANTEE_TYPE GRANTEE_KEY
FND_GRANTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MENU_ID
FND_GRANTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID INSTANCE_TYPE INSTANCE_SET_ID
FND_GRANTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRANTEE_ORIG_SYSTEM GRANTEE_ORIG_SYSTEM_ID
FND_GRANTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTANCE_PK1_VALUE INSTANCE_PK2_VALUE INSTANCE_PK3_VALUE INSTANCE_PK4_VALUE INSTANCE_PK5_VALUE
FND_GRANTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARAMETER1 PARAMETER2 PARAMETER3 PARAMETER4 PARAMETER5
FND_GRANTS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID INSTANCE_PK1_VALUE GRANTEE_KEY MENU_ID
FND_GRANTS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID INSTANCE_SET_ID GRANTEE_KEY MENU_ID
FND_GRANTS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID GRANTEE_KEY INSTANCE_PK1_VALUE INSTANCE_SET_ID MENU_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GRANT_GUID	RAW	(16)	Yes	PK Grant ID
GRANTEE_TYPE	VARCHAR2	(8)	Yes	USER, GROUP, GLOBAL
GRANTEE_KEY	VARCHAR2	(240)	Yes	FK to WF_ROLES.NAME
MENU_ID	NUMBER	(15)	Yes	FK: FND_MENUS. Which menu of functions is granted.
START_DATE	DATE		Yes	Start Date of Grant
END_DATE	DATE			End Date of Grant
OBJECT_ID	NUMBER	(15)	Yes	Object ID granted
INSTANCE_TYPE	VARCHAR2	(8)	Yes	GLOBAL,INSTANCE or SET
INSTANCE_SET_ID	NUMBER			K to instance set if SET (else NULL)
INSTANCE_PK1_VALUE	VARCHAR2	(256)		Primary Key value column 1, if INSTANCE_TYPE= 'INSTANCE', else NULL
INSTANCE_PK2_VALUE	VARCHAR2	(256)		Primary Key value column 2, if INSTANCE_TYPE= 'INSTANCE', else NULL
INSTANCE_PK3_VALUE	VARCHAR2	(256)		Primary Key value column 3, if INSTANCE_TYPE= 'INSTANCE', else NULL
INSTANCE_PK4_VALUE	VARCHAR2	(256)		Primary Key value column 4, if INSTANCE_TYPE= 'INSTANCE', else NULL
INSTANCE_PK5_VALUE	VARCHAR2	(256)		Primary Key value column 5, if INSTANCE_TYPE= 'INSTANCE', else NULL
PROGRAM_NAME	VARCHAR2	(30)		The program or UI that maintains this row in FND_GRANTS
PROGRAM_TAG	VARCHAR2	(30)		This field is for use of the program or UI that maintains row.
CREATED_BY	NUMBER	(15)	Yes	CREATED_BY
CREATION_DATE	DATE		Yes	CREATION_DATE
LAST_UPDATED_BY	NUMBER	(15)	Yes	LAST_UPDATED_BY
LAST_UPDATE_DATE	DATE		Yes	LAST_UPDATE_DATE
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	LAST_UPDATE_LOGIN
GRANTEE_ORIG_SYSTEM	VARCHAR2	(48)		1st part of 2 part FK to WF_ROLES.ORIG_SYSTEM. Type of user.
GRANTEE_ORIG_SYSTEM_ID	NUMBER	(15)		2nd part of 2 part FK to WF_ROLES.ORIG_SYSTEM_ID. Actual user's id.
CTX_SECGRP_ID	NUMBER	(15)	Yes	Grant only applies when in this Security Group; -1 means grant applies when in any Security Group.
CTX_RESP_ID	NUMBER	(15)	Yes	Along with CTX_RESP_APPL_ID: Grant applies when in this Resp. -1 means grant applies when in any Resp.
CTX_RESP_APPL_ID	NUMBER		Yes	Along with CTX_RESP_ID: Grant applies when in this Resp. -1 means grant applies when in any Resp.
CTX_ORG_ID	NUMBER		Yes	Grant only applies when in this Organization; -1 means grant applies when in any Org.
PARAMETER1	VARCHAR2	(256)		Parameter values for grants
PARAMETER2	VARCHAR2	(256)		if INSTANCE_TYPE= 'SET'
PARAMETER3	VARCHAR2	(256)		(else NULL)
PARAMETER4	VARCHAR2	(256)		Optional Parameter value 4 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER5	VARCHAR2	(256)		Optional Parameter value 5 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER6	VARCHAR2	(256)		Optional Parameter value 6 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER7	VARCHAR2	(256)		Optional Parameter value 7 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER8	VARCHAR2	(256)		Optional Parameter value 8 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER9	VARCHAR2	(256)		Optional Parameter value 9 for grants, if INSTANCE_TYPE= 'SET', else NULL
PARAMETER10	VARCHAR2	(256)		Optional Parameter value 10 for grants, if INSTANCE_TYPE= 'SET', else NULL
NAME	VARCHAR2	(80)		name of grant for admins to pick
DESCRIPTION	VARCHAR2	(240)		description of what grant does

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GRANT_GUID
,      GRANTEE_TYPE
,      GRANTEE_KEY
,      MENU_ID
,      START_DATE
,      END_DATE
,      OBJECT_ID
,      INSTANCE_TYPE
,      INSTANCE_SET_ID
,      INSTANCE_PK1_VALUE
,      INSTANCE_PK2_VALUE
,      INSTANCE_PK3_VALUE
,      INSTANCE_PK4_VALUE
,      INSTANCE_PK5_VALUE
,      PROGRAM_NAME
,      PROGRAM_TAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GRANTEE_ORIG_SYSTEM
,      GRANTEE_ORIG_SYSTEM_ID
,      CTX_SECGRP_ID
,      CTX_RESP_ID
,      CTX_RESP_APPL_ID
,      CTX_ORG_ID
,      PARAMETER1
,      PARAMETER2
,      PARAMETER3
,      PARAMETER4
,      PARAMETER5
,      PARAMETER6
,      PARAMETER7
,      PARAMETER8
,      PARAMETER9
,      PARAMETER10
,      NAME
,      DESCRIPTION
FROM APPLSYS.FND_GRANTS;

Dependencies

[top of page]

APPLSYS.FND_GRANTS does not reference any database object

APPLSYS.FND_GRANTS is referenced by following:

APPS: FND_GRANTS