[Home] [Help] [Dependency Information]
Object Name: | GL_ACCESS_SET_NORM_ASSIGN |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_ACCESS_SET_NORM_ASSIGN |
Subobject Name: | |
Status: | VALID |
GL_ACCESS_SET_NORM_ASSIGN stores the access privilege information for each data access set. Each row includes the data access set, ledger or ledger set, segment value, and the corresponding access privilege information. This table corresponds to the Access Details section in the Data Access Set screen. There is a one-to-many relationship between the data access set
information stored in the GL_ACCESS_SETS table and the access details information stored in this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_ACCESS_SET_NORM_ASSIGN_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ACCESS_SET_ID
SEGMENT_VALUE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_SET_ID | NUMBER | (15) | Yes | Access set defining column |
LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
ALL_SEGMENT_VALUE_FLAG | VARCHAR2 | (1) | Yes | All segment values flag |
SEGMENT_VALUE_TYPE_CODE | VARCHAR2 | (1) | Yes | Segment value type |
ACCESS_PRIVILEGE_CODE | VARCHAR2 | (1) | Yes | Access privilege |
RECORD_ID | NUMBER | (15) | Yes | Record defining 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 | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
SEGMENT_VALUE | VARCHAR2 | (25) | Segment value | |
START_DATE | DATE | Start date | ||
END_DATE | DATE | End date | ||
STATUS_CODE | VARCHAR2 | (1) | Status code | |
LINK_ID | NUMBER | (15) | Link defining column | |
REQUEST_ID | NUMBER | (15) | Request defining column | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_SET_ID
, LEDGER_ID
, ALL_SEGMENT_VALUE_FLAG
, SEGMENT_VALUE_TYPE_CODE
, ACCESS_PRIVILEGE_CODE
, RECORD_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, SEGMENT_VALUE
, START_DATE
, END_DATE
, STATUS_CODE
, LINK_ID
, REQUEST_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM GL.GL_ACCESS_SET_NORM_ASSIGN;
GL.GL_ACCESS_SET_NORM_ASSIGN does not reference any database object
GL.GL_ACCESS_SET_NORM_ASSIGN is referenced by following:
|
|
|