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_REC_INTF

Object Details

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

This table stores recommended values created using WebADI. Upon creation, each batch of entries is imported into ITA_SETUP_REC_VALUES_B/TL.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ITA_SETUP_REC_INTF_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REC_INTERFACE_ID
ITA_SETUP_REC_INTF_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARAMETER_CODE DEFAULT_FLAG
ITA_SETUP_REC_INTF_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATED_BY BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER			Upload session identifier
REC_INTERFACE_ID	NUMBER		Yes	Entity identifier
SETUP_GROUP_CODE	VARCHAR2	(81)	Yes	Setup group identifier
PARAMETER_CODE	VARCHAR2	(111)	Yes	Parameter identifier
CONTEXT_ORG_ID	NUMBER			Organization identifier
CONTEXT_ORG_NAME	VARCHAR2	(240)		Organization name
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
DEFAULT_FLAG	VARCHAR2	(1)		Default flag
IMAGE_FILE	VARCHAR2	(240)		Currently not used
REC_VALUE	VARCHAR2	(3000)		Recommended value
IMPORTED_FLAG	VARCHAR2	(1)		Already imported flag
STATUS_TXT	VARCHAR2	(3000)		Upload status information
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

Query Text

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


SELECT BATCH_ID
,      REC_INTERFACE_ID
,      SETUP_GROUP_CODE
,      PARAMETER_CODE
,      CONTEXT_ORG_ID
,      CONTEXT_ORG_NAME
,      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
,      DEFAULT_FLAG
,      IMAGE_FILE
,      REC_VALUE
,      IMPORTED_FLAG
,      STATUS_TXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM ITA.ITA_SETUP_REC_INTF;

Dependencies

[top of page]

ITA.ITA_SETUP_REC_INTF does not reference any database object

ITA.ITA_SETUP_REC_INTF is referenced by following:

APPS: ITA_SETUP_REC_INTF