[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QP_LIST_LINES_TEMP |
|---|---|
| Object Type: | TABLE |
| Owner: | QP |
| FND Design Data: |  QP.QP_LIST_LINES_TEMP
|
| Subobject Name: | |
| Status: | VALID |
QP.QP_LIST_LINES_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 |
|---|---|---|---|---|
| ARITHMETICOPERATOR | VARCHAR2 | (30) | ||
| 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) | ||
| EFFECTIVEPERIODUOM | VARCHAR2 | (3) | ||
| ENDDATEACTIVE | VARCHAR2 | (19) | ||
| ESTIMACCRUALRATE | VARCHAR2 | (150) | ||
| GENERATEUSINGFORMULAID | NUMBER | |||
| INVENTORYITEMID | NUMBER | |||
| LASTUPDATEDBY | NUMBER | |||
| LASTUPDATEDATE | VARCHAR2 | (19) | ||
| LASTUPDATELOGIN | NUMBER | |||
| LISTHEADERID | NUMBER | |||
| LISTLINEID | NUMBER | |||
| LISTLINETYPECODE | VARCHAR2 | (30) | ||
| LISTPRICE | VARCHAR2 | (150) | ||
| MODIFIERLEVELCODE | VARCHAR2 | (30) | ||
| NUMBEREFFECTIVEPERIODS | VARCHAR2 | (150) | ||
| OPERAND | VARCHAR2 | (150) | ||
| ORGANIZATIONID | NUMBER | |||
| OVERRIDEFLAG | VARCHAR2 | (1) | ||
| PERCENTPRICE | VARCHAR2 | (150) | ||
| PRICEBREAKTYPECODE | VARCHAR2 | (30) | ||
| PRICEBYFORMULAID | NUMBER | |||
| PRIMARYUOMFLAG | VARCHAR2 | (1) | ||
| PRINTONINVOICEFLAG | VARCHAR2 | (1) | ||
| PROGRAMAPPLICATIONID | NUMBER | |||
| PROGRAMID | NUMBER | |||
| PROGRAMUPDATEDATE | VARCHAR2 | (19) | ||
| REBATETRANSACTIONTYPECODE | VARCHAR2 | (30) | ||
| RELATEDITEMID | NUMBER | |||
| RELATIONSHIPTYPEID | NUMBER | |||
| REPRICEFLAG | VARCHAR2 | (1) | ||
| REQUESTID | NUMBER | |||
| REVISION | VARCHAR2 | (50) | ||
| REVISIONDATE | VARCHAR2 | (19) | ||
| REVISIONREASONCODE | VARCHAR2 | (30) | ||
| STARTDATEACTIVE | VARCHAR2 | (19) | ||
| SUBSTITUTIONATTRIBUTE | VARCHAR2 | (30) | ||
| SUBSTITUTIONCONTEXT | VARCHAR2 | (30) | ||
| SUBSTITUTIONVALUE | VARCHAR2 | (240) | ||
| ACCRUALFLAG | VARCHAR2 | (1) | ||
| PRICINGGROUPSEQUENCE | VARCHAR2 | (150) | ||
| INCOMPATIBILITYGRPCODE | VARCHAR2 | (30) | ||
| LISTLINENO | VARCHAR2 | (30) | ||
| PRICINGPHASEID | NUMBER | |||
| PRODUCTPRECEDENCE | VARCHAR2 | (150) | ||
| EXPIRATIONPERIODSTARTDATE | VARCHAR2 | (19) | ||
| NUMBEREXPIRATIONPERIODS | VARCHAR2 | (150) | ||
| EXPIRATIONPERIODUOM | VARCHAR2 | (3) | ||
| EXPIRATIONDATE | VARCHAR2 | (19) | ||
| ESTIMGLVALUE | VARCHAR2 | (150) | ||
| BENEFITPRICELISTLINEID | NUMBER | |||
| BENEFITLIMIT | VARCHAR2 | (150) | ||
| CHARGETYPECODE | VARCHAR2 | (30) | ||
| CHARGESUBTYPECODE | VARCHAR2 | (30) | ||
| BENEFITQTY | VARCHAR2 | (150) | ||
| BENEFITUOMCODE | VARCHAR2 | (30) | ||
| ACCRUALCONVERSIONRATE | VARCHAR2 | (150) | ||
| PRORATIONTYPECODE | VARCHAR2 | (30) | ||
| INCLUDEONRETURNSFLAG | VARCHAR2 | (1) | ||
| RETURNSTATUS | VARCHAR2 | (1) | ||
| DBFLAG | VARCHAR2 | (1) | ||
| OPERATION | VARCHAR2 | (30) | ||
| MODIFIERPARENTINDEX | NUMBER | |||
| QUALIFICATIONIND | NUMBER | |||
| LISTHEADERNAME | VARCHAR2 | (240) | ||
| VERSIONNO | VARCHAR2 | (30) | ||
| PRICEBYFORMULA | VARCHAR2 | (240) | ||
| INVENTORYITEMCODE | VARCHAR2 | (81) | ||
| ORGANIZATIONCODE | VARCHAR2 | (3) | ||
| GENERATEUSINGFORMULA | VARCHAR2 | (240) | ||
| RELATEDITEMCODE | VARCHAR2 | (81) | ||
| BENEFITPRICELISTLINENO | VARCHAR2 | (30) | ||
| BENEFITPLLHEADERNAME | VARCHAR2 | (240) | ||
| BENEFITPLLHEADERVERSIONNO | VARCHAR2 | (30) | ||
| LANGUAGE | VARCHAR2 | (4) | ||
| NETAMOUNTFLAG | VARCHAR2 | (1) | ||
| ACCUMATTRIBUTE | VARCHAR2 | (240) | ||
| CONTINUOUSPRICEBREAKFLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ARITHMETICOPERATOR
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATICFLAG
, COMMENTS
, CONTEXT
, CREATEDBY
, CREATIONDATE
, EFFECTIVEPERIODUOM
, ENDDATEACTIVE
, ESTIMACCRUALRATE
, GENERATEUSINGFORMULAID
, INVENTORYITEMID
, LASTUPDATEDBY
, LASTUPDATEDATE
, LASTUPDATELOGIN
, LISTHEADERID
, LISTLINEID
, LISTLINETYPECODE
, LISTPRICE
, MODIFIERLEVELCODE
, NUMBEREFFECTIVEPERIODS
, OPERAND
, ORGANIZATIONID
, OVERRIDEFLAG
, PERCENTPRICE
, PRICEBREAKTYPECODE
, PRICEBYFORMULAID
, PRIMARYUOMFLAG
, PRINTONINVOICEFLAG
, PROGRAMAPPLICATIONID
, PROGRAMID
, PROGRAMUPDATEDATE
, REBATETRANSACTIONTYPECODE
, RELATEDITEMID
, RELATIONSHIPTYPEID
, REPRICEFLAG
, REQUESTID
, REVISION
, REVISIONDATE
, REVISIONREASONCODE
, STARTDATEACTIVE
, SUBSTITUTIONATTRIBUTE
, SUBSTITUTIONCONTEXT
, SUBSTITUTIONVALUE
, ACCRUALFLAG
, PRICINGGROUPSEQUENCE
, INCOMPATIBILITYGRPCODE
, LISTLINENO
, PRICINGPHASEID
, PRODUCTPRECEDENCE
, EXPIRATIONPERIODSTARTDATE
, NUMBEREXPIRATIONPERIODS
, EXPIRATIONPERIODUOM
, EXPIRATIONDATE
, ESTIMGLVALUE
, BENEFITPRICELISTLINEID
, BENEFITLIMIT
, CHARGETYPECODE
, CHARGESUBTYPECODE
, BENEFITQTY
, BENEFITUOMCODE
, ACCRUALCONVERSIONRATE
, PRORATIONTYPECODE
, INCLUDEONRETURNSFLAG
, RETURNSTATUS
, DBFLAG
, OPERATION
, MODIFIERPARENTINDEX
, QUALIFICATIONIND
, LISTHEADERNAME
, VERSIONNO
, PRICEBYFORMULA
, INVENTORYITEMCODE
, ORGANIZATIONCODE
, GENERATEUSINGFORMULA
, RELATEDITEMCODE
, BENEFITPRICELISTLINENO
, BENEFITPLLHEADERNAME
, BENEFITPLLHEADERVERSIONNO
, LANGUAGE
, NETAMOUNTFLAG
, ACCUMATTRIBUTE
, CONTINUOUSPRICEBREAKFLAG
FROM QP.QP_LIST_LINES_TEMP;
QP.QP_LIST_LINES_TEMP does not reference any database object
QP.QP_LIST_LINES_TEMP is referenced by following:
APPS
QP_LIST_LINES_TEMP
|
|
|
|