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: QP.QP_INT_PROFS_T

Object Details

Object Name:	QP_INT_PROFS_T
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_INT_PROFS_T
Subobject Name:
Status:	VALID

Interface table for Profile name and value pairs per request. These profiles do not include only SITE-level updatable ones which Java Engine already cached.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_INT_PROFS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID PROFILE_OPTION_NAME PROFILE_OPTION_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER		Yes	Unique key to identify each request to Java Engine
PROFILE_OPTION_NAME	VARCHAR2	(80)	Yes	Profile name.
PROFILE_OPTION_VALUE	VARCHAR2	(240)		Profile value.
CREATED_BY	NUMBER	(15)		Standard WHO column
CREATION_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column

Query Text

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


SELECT REQUEST_ID
,      PROFILE_OPTION_NAME
,      PROFILE_OPTION_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM QP.QP_INT_PROFS_T;

Dependencies

[top of page]

QP.QP_INT_PROFS_T does not reference any database object

QP.QP_INT_PROFS_T is referenced by following:

QP: QP_INT_PROFS_T#