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_REC_VALUES_VL

Object Details

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

View Type

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

This view renders recommended values for a parameter within a particular organization context.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
REC_VALUE_ID	NUMBER			Entity identifier
PARAMETER_CODE	VARCHAR2	(111)	Yes	Parameter identifier
CONTEXT_ORG_ID	NUMBER			Organization identifier
CONTEXT_ORG_NAME	VARCHAR2	(240)		Organization name
RECOMMENDED_VALUE	VARCHAR2	(3000)		Recommended value
DEFAULT_FLAG	VARCHAR2	(1)		Default instance flag
IMAGE_FILE	VARCHAR2	(240)		Currently not used
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
PK1_VALUE	VARCHAR2	(3000)		Organization identifier
PK2_VALUE	VARCHAR2	(3000)		Organization name
PK3_VALUE	VARCHAR2	(3000)		Currently not used
PK4_VALUE	VARCHAR2	(3000)		Currently not used
PK5_VALUE	VARCHAR2	(3000)		Currently not used
PK6_VALUE	VARCHAR2	(3000)		Currently not used
PK7_VALUE	VARCHAR2	(3000)		Currently not used
PK8_VALUE	VARCHAR2	(3000)		Currently not used
PK9_VALUE	VARCHAR2	(3000)		Currently not used
PK10_VALUE	VARCHAR2	(3000)		Currently not used
PK11_VALUE	VARCHAR2	(3000)		Currently not used
PK12_VALUE	VARCHAR2	(3000)		Currently not used
PK13_VALUE	VARCHAR2	(3000)		Currently not used
PK14_VALUE	VARCHAR2	(3000)		Currently not used
PK15_VALUE	VARCHAR2	(3000)		Currently not used
PK16_VALUE	VARCHAR2	(3000)		Currently not used
PK17_VALUE	VARCHAR2	(3000)		Currently not used
PK18_VALUE	VARCHAR2	(3000)		Currently not used
PK19_VALUE	VARCHAR2	(3000)		Currently not used
PK20_VALUE	VARCHAR2	(3000)		Currently not used
REC_INTERFACE_ID	NUMBER			WebADI interface entry identifier
REQUEST_ID	NUMBER			Standard concurrent processing column
PROGRAM_APPLICATION_ID	NUMBER			Standard concurrent processing column
PROGRAM_ID	NUMBER			Standard concurrent processing column
PROGRAM_UPDATE_DATE	DATE			Standard concurrent processing column

Query Text

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


SELECT ROW_ID
,      REC_VALUE_ID
,      PARAMETER_CODE
,      CONTEXT_ORG_ID
,      CONTEXT_ORG_NAME
,      RECOMMENDED_VALUE
,      DEFAULT_FLAG
,      IMAGE_FILE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      PK6_VALUE
,      PK7_VALUE
,      PK8_VALUE
,      PK9_VALUE
,      PK10_VALUE
,      PK11_VALUE
,      PK12_VALUE
,      PK13_VALUE
,      PK14_VALUE
,      PK15_VALUE
,      PK16_VALUE
,      PK17_VALUE
,      PK18_VALUE
,      PK19_VALUE
,      PK20_VALUE
,      REC_INTERFACE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.ITA_SETUP_REC_VALUES_VL;

Dependencies

[top of page]

APPS.ITA_SETUP_REC_VALUES_VL references the following:

APPS: ITA_SETUP_REC_VALUES_B; ITA_SETUP_REC_VALUES_TL

APPS.ITA_SETUP_REC_VALUES_VL is referenced by following:

APPS: ITA_SETUP_REC_VALUES_PKG - show dependent code