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_QUALIFIERS_TEMP

Object Details

Object Name:	QP_QUALIFIERS_TEMP
Object Type:	TABLE
Owner:	QP
Subobject Name:
Status:	VALID

Temporary Table Details

QP.QP_QUALIFIERS_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
ATTRIBUTE1	VARCHAR2	(240)
ATTRIBUTE10	VARCHAR2	(240)
ATTRIBUTE11	VARCHAR2	(240)
ATTRIBUTE12	VARCHAR2	(240)
ATTRIBUTE13	VARCHAR2	(240)
ATTRIBUTE14	VARCHAR2	(240)
ATTRIBUTE15	VARCHAR2	(240)
ATTRIBUTE2	VARCHAR2	(240)
ATTRIBUTE3	VARCHAR2	(240)
ATTRIBUTE4	VARCHAR2	(240)
ATTRIBUTE5	VARCHAR2	(240)
ATTRIBUTE6	VARCHAR2	(240)
ATTRIBUTE7	VARCHAR2	(240)
ATTRIBUTE8	VARCHAR2	(240)
ATTRIBUTE9	VARCHAR2	(240)
COMPARISONOPERATORCODE	VARCHAR2	(30)
CONTEXT	VARCHAR2	(30)
CREATEDBY	NUMBER
CREATEDFROMRULEID	NUMBER
CREATIONDATE	DATE
ENDDATEACTIVE	DATE
EXCLUDERFLAG	VARCHAR2	(1)
LASTUPDATEDBY	NUMBER
LASTUPDATEDATE	DATE
LASTUPDATELOGIN	NUMBER
LISTHEADERID	NUMBER
LISTLINEID	NUMBER
PROGRAMAPPLICATIONID	NUMBER
PROGRAMID	NUMBER
PROGRAMUPDATEDATE	DATE
QUALIFIERATTRIBUTE	VARCHAR2	(30)
QUALIFIERATTRVALUE	VARCHAR2	(240)
QUALIFIERATTRVALUETO	VARCHAR2	(240)
QUALIFIERCONTEXT	VARCHAR2	(30)
QUALIFIERDATATYPE	VARCHAR2	(10)
QUALIFIERGROUPINGNO	NUMBER
QUALIFIERID	NUMBER
QUALIFIERPRECEDENCE	NUMBER
QUALIFIERRULEID	NUMBER
REQUESTID	NUMBER
STARTDATEACTIVE	DATE
LISTTYPECODE	VARCHAR2	(30)
QUALATTRVALUEFROMNUMBER	NUMBER
QUALATTRVALUETONUMBER	NUMBER
ACTIVEFLAG	VARCHAR2	(1)
SEARCHIND	NUMBER
QUALIFIERGROUPCNT	NUMBER
HEADERQUALSEXISTFLAG	VARCHAR2	(1)
DISTINCTROWCOUNT	NUMBER
QUALIFIERFROMRULENAME	VARCHAR2	(240)
CREATEDFROMRULENAME	VARCHAR2	(240)
LISTHEADERNAME	VARCHAR2	(240)
LISTHEADERVERSIONNO	VARCHAR2	(30)
LISTLINENO	VARCHAR2	(30)
LISTLINEHEADERNAME	VARCHAR2	(240)
LISTLINEHEADERVERSIONNO	VARCHAR2	(30)

Query Text

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


SELECT ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      COMPARISONOPERATORCODE
,      CONTEXT
,      CREATEDBY
,      CREATEDFROMRULEID
,      CREATIONDATE
,      ENDDATEACTIVE
,      EXCLUDERFLAG
,      LASTUPDATEDBY
,      LASTUPDATEDATE
,      LASTUPDATELOGIN
,      LISTHEADERID
,      LISTLINEID
,      PROGRAMAPPLICATIONID
,      PROGRAMID
,      PROGRAMUPDATEDATE
,      QUALIFIERATTRIBUTE
,      QUALIFIERATTRVALUE
,      QUALIFIERATTRVALUETO
,      QUALIFIERCONTEXT
,      QUALIFIERDATATYPE
,      QUALIFIERGROUPINGNO
,      QUALIFIERID
,      QUALIFIERPRECEDENCE
,      QUALIFIERRULEID
,      REQUESTID
,      STARTDATEACTIVE
,      LISTTYPECODE
,      QUALATTRVALUEFROMNUMBER
,      QUALATTRVALUETONUMBER
,      ACTIVEFLAG
,      SEARCHIND
,      QUALIFIERGROUPCNT
,      HEADERQUALSEXISTFLAG
,      DISTINCTROWCOUNT
,      QUALIFIERFROMRULENAME
,      CREATEDFROMRULENAME
,      LISTHEADERNAME
,      LISTHEADERVERSIONNO
,      LISTLINENO
,      LISTLINEHEADERNAME
,      LISTLINEHEADERVERSIONNO
FROM QP.QP_QUALIFIERS_TEMP;

Dependencies

[top of page]

QP.QP_QUALIFIERS_TEMP does not reference any database object

QP.QP_QUALIFIERS_TEMP is referenced by following:

APPS: QP_QUALIFIERS_TEMP