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: ITA.ITA_SETUP_PARAMETERS_B

Object Details

Object Name:	ITA_SETUP_PARAMETERS_B
Object Type:	TABLE
Owner:	ITA
Subobject Name:
Status:	VALID

This table stores information about a column in a database table for which we track changes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ITA_SETUP_PARAMETERS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARAMETER_CODE
ITA_SETUP_PARAMETERS_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SETUP_GROUP_CODE CONTEXT_PREDICATE_FLAG
ITA_SETUP_PARAMETERS_B_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SETUP_GROUP_CODE COLUMN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PARAMETER_CODE	VARCHAR2	(111)	Yes	Entity identifier
SETUP_GROUP_CODE	VARCHAR2	(81)		Setup group identifier
COLUMN_ID	NUMBER	(15)		Column identifier
CONTEXT_PREDICATE_FLAG	VARCHAR2	(1)		Context parameter flag
CONTEXT_SEQUENCE_NUM	NUMBER			Context sequence number
AUDIT_ENABLED_FLAG	VARCHAR2	(1)		Change tracking enabled flag
FK_TABLE_ID	NUMBER	(15)		Currently not used
FK_TABLE_APP_ID	NUMBER			Currently not used
FK_COLUMN_ID	NUMBER	(15)		Currently not used
SELECT_CLAUSE	VARCHAR2	(3000)		Foreign-key query select clause
FROM_CLAUSE	VARCHAR2	(3000)		Foreign-key query from clause
WHERE_CLAUSE	VARCHAR2	(3000)		Foreign-key query where clause
END_DATE	DATE			Identifies if this parameter has been obsoleted or if it has moved to another table.
MIGRATED_FLAG	VARCHAR2	(1)		Identifies if this parameter has been moved to another table.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
SECURITY_GROUP_ID	NUMBER			Standard Applications column
OBJECT_VERSION_NUMBER	NUMBER			Standard Applications column
COLUMN_REFERENCE1	VARCHAR2	(255)		Profile option identifier
COLUMN_REFERENCE2	VARCHAR2	(255)		Application identifier for profile option

Query Text

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


SELECT PARAMETER_CODE
,      SETUP_GROUP_CODE
,      COLUMN_ID
,      CONTEXT_PREDICATE_FLAG
,      CONTEXT_SEQUENCE_NUM
,      AUDIT_ENABLED_FLAG
,      FK_TABLE_ID
,      FK_TABLE_APP_ID
,      FK_COLUMN_ID
,      SELECT_CLAUSE
,      FROM_CLAUSE
,      WHERE_CLAUSE
,      END_DATE
,      MIGRATED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      COLUMN_REFERENCE1
,      COLUMN_REFERENCE2
FROM ITA.ITA_SETUP_PARAMETERS_B;

Dependencies

[top of page]

ITA.ITA_SETUP_PARAMETERS_B does not reference any database object

ITA.ITA_SETUP_PARAMETERS_B is referenced by following:

APPS: ITA_SETUP_PARAMETERS_B