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]

VIEW: APPS.ITA_SETUP_PARAMETERS_VL

Object Details

Object Name:	ITA_SETUP_PARAMETERS_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
PARAMETER_CODE	VARCHAR2	(111)	Yes	Entity identifier
PARAMETER_NAME	VARCHAR2	(240)		Entity name
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 ROW_ID
,      PARAMETER_CODE
,      PARAMETER_NAME
,      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 APPS.ITA_SETUP_PARAMETERS_VL;

Dependencies

[top of page]

APPS.ITA_SETUP_PARAMETERS_VL references the following:

APPS: ITA_SETUP_PARAMETERS_B; ITA_SETUP_PARAMETERS_TL

APPS.ITA_SETUP_PARAMETERS_VL is referenced by following:

APPS: ITA_NOTIFICATION_PKG - show dependent code; ITA_RECORD_CURR_STATUS_PKG - show dependent code; ITA_SETUP_REC_VALUES_PKG - show dependent code