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: IGI.IGI_SLS_SECURITY_GROUP_ALLOC

Object Details

Object Name:	IGI_SLS_SECURITY_GROUP_ALLOC
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_SLS_SECURITY_GROUP_ALLOC
Subobject Name:
Status:	VALID

IGI_SLS_SECURITY_GROUP_ALLOC maintains the unique combination of enabled subledger security groups and their enabled secure tables. This table is used internally to improve query performance.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_SLS_SEC_GROUP_ALLOC_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TABLE_NAME SLS_SECURITY_GROUP

Columns

Name	Datatype	Length	Mandatory	Comments
SLS_SECURITY_GROUP	VARCHAR2	(30)	Yes	SLS security group name
TABLE_NAME	VARCHAR2	(30)	Yes	Secure table name

Query Text

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


SELECT SLS_SECURITY_GROUP
,      TABLE_NAME
FROM IGI.IGI_SLS_SECURITY_GROUP_ALLOC;

Dependencies

[top of page]

IGI.IGI_SLS_SECURITY_GROUP_ALLOC does not reference any database object

IGI.IGI_SLS_SECURITY_GROUP_ALLOC is referenced by following:

APPS: IGI_SLS_SECURITY_GROUP_ALLOC