[Home] [Help] [Dependency Information]
Object Name: | GL_ACCESS_SET_ASSIGNMENTS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_ACCESS_SET_ASSIGNMENTS |
Subobject Name: | |
Status: | VALID |
GL_ACCESS_SET_ASSIGNMENTS stores the access privilege information for each data access set. Each row includes the data access set, ledger, segment value, and the corresponding access privilege information. This table stores the flattened information from the GL_ACCESS_SET_NORM_ASSIGN table. Each ledger set or parent segment value stored in the GL_ACCESS_SET_NORM_ASSIGN table will be expanded into ledger or detail segment values before it is stored in this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_ACCESS_SET_ASSIGNMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ACCESS_SET_ID
LEDGER_ID |
GL_ACCESS_SET_ASSIGNMENTS_N2 | 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 |
SEGMENT_VALUE | VARCHAR2 | (25) | Yes | Segment value |
ACCESS_PRIVILEGE_CODE | VARCHAR2 | (1) | Yes | Access privilege |
PARENT_RECORD_ID | NUMBER | (15) | Yes | Parent 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 |
START_DATE | DATE | Start date | ||
END_DATE | DATE | End Date |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_SET_ID
, LEDGER_ID
, SEGMENT_VALUE
, ACCESS_PRIVILEGE_CODE
, PARENT_RECORD_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, START_DATE
, END_DATE
FROM GL.GL_ACCESS_SET_ASSIGNMENTS;
GL.GL_ACCESS_SET_ASSIGNMENTS does not reference any database object
GL.GL_ACCESS_SET_ASSIGNMENTS is referenced by following:
|
|
|