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_UPG_ITF

Object Details

Object Name:	IGI_SLS_UPG_ITF
Object Type:	TABLE
Owner:	IGI
Subobject Name:
Status:	VALID

This table stores information that is used for upgrading Subledger Security to Release 12.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
OLD_TABLE_NAME	VARCHAR2	(50)	This column stores secured tables that were obsolete in R12
OLD_OWNER	VARCHAR2	(10)	This column stores the owner of secured tables that were obsolete in R12
OLD_ALLOCATION	VARCHAR2	(50)	This column stores table IGI table allocated for the obsolete tables in R12
NEW_TABLE_NAME	VARCHAR2	(50)	This column stores corresponding new tables that are to be secured in R12
NEW_OWNER	VARCHAR2	(10)	This column stores corresponding new tables owner
NEW_ALLOCATION	VARCHAR2	(50)	This column stores IGI table allocated to this new table allocation
SLS_GROUPS	VARCHAR2	(1000)	This column stores all the security groups for which this table is allocated to
WHERE_CLAUSE	VARCHAR2	(2000)	The where clause
FROM_CLAUSE	VARCHAR2	(500)	From clause

Query Text

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


SELECT OLD_TABLE_NAME
,      OLD_OWNER
,      OLD_ALLOCATION
,      NEW_TABLE_NAME
,      NEW_OWNER
,      NEW_ALLOCATION
,      SLS_GROUPS
,      WHERE_CLAUSE
,      FROM_CLAUSE
FROM IGI.IGI_SLS_UPG_ITF;

Dependencies

[top of page]

IGI.IGI_SLS_UPG_ITF does not reference any database object

IGI.IGI_SLS_UPG_ITF is referenced by following:

APPS: IGI_SLS_UPG_ITF; IGI_SLS_UPG_PKG - show dependent code