[Home] [Help] [Dependency Information]
Object Name: | IGI_SLS_SECURE_TABLES |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_SLS_SECURE_TABLES |
Subobject Name: | |
Status: | VALID |
IGI_SLS_SECURE_TABLES contains information on secure tables. An update flag on a secure table indicates security is enabled when updating the secure table.
Further information is maintained about when each secure table is enabled, disabled, removed, or has security applied.
This table also contains information about the subledger extended tables, which are system-generated.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGI_SLS_SECURE_TAB_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TABLE_NAME
OWNER |
IGI_SLS_SECURE_TAB_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SLS_TABLE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Yes | Schema owner for the secure table |
TABLE_NAME | VARCHAR2 | (30) | Yes | Secure table name |
DESCRIPTION | VARCHAR2 | (60) | Secure table description | |
SLS_TABLE_NAME | VARCHAR2 | (30) | Yes | System-generated SLS extended table name |
UPDATE_ALLOWED | VARCHAR2 | (1) | Yes | Allow security for updating table |
DATE_ENABLED | DATE | Date security enabled for table | ||
DATE_DISABLED | DATE | Date security disabled for table | ||
DATE_REMOVED | DATE | Date security removed for table | ||
DATE_OBJECT_CREATED | DATE | Date SLS scripts generated for table | ||
DATE_SECURITY_APPLIED | DATE | Date security applied to table | ||
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
OPTIMISE_SQL | VARCHAR2 | (1) | Optimize SQL hint |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TABLE_NAME
, DESCRIPTION
, SLS_TABLE_NAME
, UPDATE_ALLOWED
, DATE_ENABLED
, DATE_DISABLED
, DATE_REMOVED
, DATE_OBJECT_CREATED
, DATE_SECURITY_APPLIED
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, OPTIMISE_SQL
FROM IGI.IGI_SLS_SECURE_TABLES;
IGI.IGI_SLS_SECURE_TABLES does not reference any database object
IGI.IGI_SLS_SECURE_TABLES is referenced by following:
|
|
|