[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QP_LIST_HEADER_TEMP |
|---|---|
| Object Type: | TABLE |
| Owner: | QP |
| Subobject Name: | |
| Status: | VALID |
QP.QP_LIST_HEADER_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.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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) | ||
| AUTOMATICFLAG | VARCHAR2 | (1) | ||
| COMMENTS | VARCHAR2 | (2000) | ||
| CONTEXT | VARCHAR2 | (30) | ||
| CREATEDBY | NUMBER | |||
| CREATIONDATE | VARCHAR2 | (19) | ||
| CURRENCYCODE | VARCHAR2 | (30) | ||
| DISCOUNTLINESFLAG | VARCHAR2 | (1) | ||
| ENDDATEACTIVE | VARCHAR2 | (19) | ||
| FREIGHTTERMSCODE | VARCHAR2 | (30) | ||
| GSAINDICATOR | VARCHAR2 | (1) | ||
| LASTUPDATEDBY | NUMBER | |||
| LASTUPDATEDATE | VARCHAR2 | (19) | ||
| LASTUPDATELOGIN | NUMBER | |||
| LISTHEADERID | NUMBER | |||
| LISTTYPECODE | VARCHAR2 | (30) | ||
| PROGRAMAPPLICATIONID | NUMBER | |||
| PROGRAMID | NUMBER | |||
| PROGRAMUPDATEDATE | VARCHAR2 | (19) | ||
| PRORATEFLAG | VARCHAR2 | (30) | ||
| REQUESTID | NUMBER | |||
| ROUNDINGFACTOR | VARCHAR2 | (150) | ||
| SHIPMETHODCODE | VARCHAR2 | (30) | ||
| STARTDATEACTIVE | VARCHAR2 | (19) | ||
| TERMSID | NUMBER | |||
| SOURCESYSTEMCODE | VARCHAR2 | (30) | ||
| ACTIVEFLAG | VARCHAR2 | (1) | ||
| PARENTLISTHEADERID | NUMBER | |||
| STARTDATEACTIVEFIRST | VARCHAR2 | (19) | ||
| ENDDATEACTIVEFIRST | VARCHAR2 | (19) | ||
| ACTIVEDATEFIRSTTYPE | VARCHAR2 | (30) | ||
| STARTDATEACTIVESECOND | VARCHAR2 | (19) | ||
| GLOBALFLAG | VARCHAR2 | (1) | ||
| ENDDATEACTIVESECOND | VARCHAR2 | (19) | ||
| ACTIVEDATESECONDTYPE | VARCHAR2 | (30) | ||
| ASKFORFLAG | VARCHAR2 | (1) | ||
| NAME | VARCHAR2 | (240) | ||
| DESCRIPTION | VARCHAR2 | (2000) | ||
| VERSIONNO | VARCHAR2 | (30) | ||
| PTECODE | VARCHAR2 | (30) | ||
| TERMSNAME | VARCHAR2 | (15) | ||
| PARENTNAME | VARCHAR2 | (240) | ||
| PARENTVERSIONNO | VARCHAR2 | (30) | ||
| LANGUAGE | VARCHAR2 | (4) | ||
| SHAREABLEFLAG | VARCHAR2 | (1) | ||
| ORIGSYSTEMHEADERREF | VARCHAR2 | (50) | ||
| LISTSOURCECODE | VARCHAR2 | (30) |
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
, AUTOMATICFLAG
, COMMENTS
, CONTEXT
, CREATEDBY
, CREATIONDATE
, CURRENCYCODE
, DISCOUNTLINESFLAG
, ENDDATEACTIVE
, FREIGHTTERMSCODE
, GSAINDICATOR
, LASTUPDATEDBY
, LASTUPDATEDATE
, LASTUPDATELOGIN
, LISTHEADERID
, LISTTYPECODE
, PROGRAMAPPLICATIONID
, PROGRAMID
, PROGRAMUPDATEDATE
, PRORATEFLAG
, REQUESTID
, ROUNDINGFACTOR
, SHIPMETHODCODE
, STARTDATEACTIVE
, TERMSID
, SOURCESYSTEMCODE
, ACTIVEFLAG
, PARENTLISTHEADERID
, STARTDATEACTIVEFIRST
, ENDDATEACTIVEFIRST
, ACTIVEDATEFIRSTTYPE
, STARTDATEACTIVESECOND
, GLOBALFLAG
, ENDDATEACTIVESECOND
, ACTIVEDATESECONDTYPE
, ASKFORFLAG
, NAME
, DESCRIPTION
, VERSIONNO
, PTECODE
, TERMSNAME
, PARENTNAME
, PARENTVERSIONNO
, LANGUAGE
, SHAREABLEFLAG
, ORIGSYSTEMHEADERREF
, LISTSOURCECODE
FROM QP.QP_LIST_HEADER_TEMP;
QP.QP_LIST_HEADER_TEMP does not reference any database object
QP.QP_LIST_HEADER_TEMP is referenced by following:
APPS
QP_LIST_HEADER_TEMP
|
|
|
|