[Home] [Help] [Dependency Information]
Object Name: | FND_SECURITY_GROUPS_TL |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_SECURITY_GROUPS_TL |
Subobject Name: | |
Status: | VALID |
FND_SECURITY_GROUPS_TL stores translated information about
each of the security groups in FND_SECURITY_GROUPS.
Each row includes the language the row is translated to,
the name and description of the security group, and the
security group identifier that uniquely identifies each security
group. You need one row for each security group in each of
the installed languages.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_SECURITY_GROUPS_TL_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
SECURITY_GROUP_ID
LANGUAGE |
FND_SECURITY_GROUPS_TL_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
SECURITY_GROUP_NAME
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SECURITY_GROUP_ID | NUMBER | (15) | Yes | Security group identifier |
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
SECURITY_GROUP_NAME | VARCHAR2 | (80) | Yes | User name of security group |
DESCRIPTION | VARCHAR2 | (240) | Security group description | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SOURCE_LANG | VARCHAR2 | (4) | Yes | The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
Cut, paste (and edit) the following text to query this object:
SELECT SECURITY_GROUP_ID
, LANGUAGE
, SECURITY_GROUP_NAME
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SOURCE_LANG
FROM APPLSYS.FND_SECURITY_GROUPS_TL;
APPLSYS.FND_SECURITY_GROUPS_TL does not reference any database object
APPLSYS.FND_SECURITY_GROUPS_TL is referenced by following:
|
|
|