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: GMD.GMD_FORMULA_SECURITY

Object Details

Object Name:	GMD_FORMULA_SECURITY
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.GMD_FORMULA_SECURITY
Subobject Name:
Status:	VALID

Formula Security Details, containing the access granted to individual Formulas

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMD_FORMULA_SECURITY_PK	NORMAL	UNIQUE	APPS_TS_SEED	FORMULA_SECURITY_ID
GMD_FORMULA_SECURITY_U1	NORMAL	UNIQUE	APPS_TS_SEED	ORGN_CODE USER_ID RESPONSIBILITY_ID FORMULA_ID OTHER_ORGN
GMD_FORMULA_SECURITY_I1	NORMAL	NONUNIQUE	APPS_TS_SEED	FORMULA_ID
GMD_FORMULA_SECURITY_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	USER_ID
GMD_FORMULA_SECURITY_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	RESPONSIBILITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FORMULA_SECURITY_ID	NUMBER	(15)	Yes	Formula Security Unique Identifier
FORMULA_ID	NUMBER	(15)	Yes	Formula Identifier
ACCESS_TYPE_IND	VARCHAR2	(10)	Yes	Specifies the user's access is Update or View
ORGN_CODE	VARCHAR2	(4)		Formula's Owning Organization. Formula Security access is controlled by the Formula's Owning Organization.
USER_ID	NUMBER	(15)		User Identifier. Formula Security can be contorlled at the user level. User specified must be associated with the Formula's Owning Organization or Other Organization if specified.
RESPONSIBILITY_ID	NUMBER	(15)		Responsibility Identifier
OTHER_ORGN	VARCHAR2	(4)		Organization other than the formula's owning organization. A user can be given access to the owning organization's formula if they are associated with the other organization specified.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
ORGANIZATION_ID	NUMBER	(15)		This is the organization id column for the security profile
OTHER_ORGANIZATION_ID	NUMBER	(15)		This is the other organization id column for the security profile

Query Text

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


SELECT FORMULA_SECURITY_ID
,      FORMULA_ID
,      ACCESS_TYPE_IND
,      ORGN_CODE
,      USER_ID
,      RESPONSIBILITY_ID
,      OTHER_ORGN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      OTHER_ORGANIZATION_ID
FROM GMD.GMD_FORMULA_SECURITY;

Dependencies

[top of page]

GMD.GMD_FORMULA_SECURITY does not reference any database object

GMD.GMD_FORMULA_SECURITY is referenced by following:

APPS: GMD_FORMULA_SECURITY