[Home] [Help] [Dependency Information]
Object Name: | QP_PRICING_ATTRIBUTES_TEMP |
---|---|
Object Type: | TABLE |
Owner: | QP |
Subobject Name: | |
Status: | VALID |
QP.QP_PRICING_ATTRIBUTES_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 |
---|---|---|---|---|
ACCUMULATEFLAG | VARCHAR2 | (1) | ||
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) | ||
ATTRIBUTEGROUPINGNO | NUMBER | |||
CONTEXT | VARCHAR2 | (30) | ||
CREATEDBY | NUMBER | |||
CREATIONDATE | DATE | |||
EXCLUDERFLAG | VARCHAR2 | (1) | ||
LASTUPDATEDBY | NUMBER | |||
LASTUPDATEDATE | DATE | |||
LASTUPDATELOGIN | NUMBER | |||
LISTLINEID | NUMBER | |||
PRICINGATTRIBUTE | VARCHAR2 | (30) | ||
PRICINGATTRIBUTECONTEXT | VARCHAR2 | (30) | ||
PRICINGATTRIBUTEID | NUMBER | |||
PRICINGATTRVALUEFROM | VARCHAR2 | (240) | ||
PRICINGATTRVALUETO | VARCHAR2 | (240) | ||
PRODUCTATTRIBUTE | VARCHAR2 | (30) | ||
PRODUCTATTRIBUTECONTEXT | VARCHAR2 | (30) | ||
PRODUCTATTRVALUE | VARCHAR2 | (240) | ||
PRODUCTUOMCODE | VARCHAR2 | (3) | ||
PROGRAMAPPLICATIONID | NUMBER | |||
PROGRAMID | NUMBER | |||
PROGRAMUPDATEDATE | DATE | |||
PRODUCTATTRIBUTEDATATYPE | VARCHAR2 | (30) | ||
PRICINGATTRIBUTEDATATYPE | VARCHAR2 | (30) | ||
COMPARISONOPERATORCODE | VARCHAR2 | (30) | ||
LISTHEADERID | NUMBER | |||
PRICINGPHASEID | NUMBER | |||
REQUESTID | NUMBER | |||
PRICINGATTRVALUEFROMNUMBER | NUMBER | |||
PRICINGATTRVALUETONUMBER | NUMBER | |||
QUALIFICATIONIND | NUMBER | |||
LISTLINENO | VARCHAR2 | (30) | ||
LISTLINEHEADERNAME | VARCHAR2 | (240) | ||
LISTLINEHEADERVERSIONNO | VARCHAR2 | (30) | ||
LISTHEADERNAME | VARCHAR2 | (240) | ||
LISTHEADERVERSIONNO | VARCHAR2 | (30) | ||
PRICINGPHASENAME | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCUMULATEFLAG
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTEGROUPINGNO
, CONTEXT
, CREATEDBY
, CREATIONDATE
, EXCLUDERFLAG
, LASTUPDATEDBY
, LASTUPDATEDATE
, LASTUPDATELOGIN
, LISTLINEID
, PRICINGATTRIBUTE
, PRICINGATTRIBUTECONTEXT
, PRICINGATTRIBUTEID
, PRICINGATTRVALUEFROM
, PRICINGATTRVALUETO
, PRODUCTATTRIBUTE
, PRODUCTATTRIBUTECONTEXT
, PRODUCTATTRVALUE
, PRODUCTUOMCODE
, PROGRAMAPPLICATIONID
, PROGRAMID
, PROGRAMUPDATEDATE
, PRODUCTATTRIBUTEDATATYPE
, PRICINGATTRIBUTEDATATYPE
, COMPARISONOPERATORCODE
, LISTHEADERID
, PRICINGPHASEID
, REQUESTID
, PRICINGATTRVALUEFROMNUMBER
, PRICINGATTRVALUETONUMBER
, QUALIFICATIONIND
, LISTLINENO
, LISTLINEHEADERNAME
, LISTLINEHEADERVERSIONNO
, LISTHEADERNAME
, LISTHEADERVERSIONNO
, PRICINGPHASENAME
FROM QP.QP_PRICING_ATTRIBUTES_TEMP;
QP.QP_PRICING_ATTRIBUTES_TEMP does not reference any database object
QP.QP_PRICING_ATTRIBUTES_TEMP is referenced by following:
|
|
|