[Home] [Help] [Dependency Information]
Object Name: | QP_PRICE_REQ_SOURCES |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_PRICE_REQ_SOURCES |
Subobject Name: | |
Status: | VALID |
QP_PRICE_REQ_SOURCES stores the mapping between Pricing Request Types and Source Systems. The pricing engine uses the request type to source system mapping you define to determine the source or sources of pricing data that should be used to price a particular type of transaction. The request type is used to identify the type of transaction being priced, e.g. a contract. The source system is recorded on all price and modifier lists and is used to identify which application created this pricing data, e.g. iMarketing.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_PRICE_REQ_SOURCES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REQUEST_TYPE_CODE
SOURCE_SYSTEM_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_TYPE_CODE | VARCHAR2 | (30) | Yes | The type of request or transaction being priced, based on lookup type REQUEST_TYPE. |
SOURCE_SYSTEM_CODE | VARCHAR2 | (30) | Yes | The source system of the pricing data to be used to price the request type, based on lookup type SOURCE_SYSTEM. |
SEEDED_FLAG | VARCHAR2 | (1) | Indicates if the record was created as seed data. | |
CREATION_DATE | DATE | Yes | Standard Who column. | |
CREATED_BY | NUMBER | Yes | Standard Who column. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column. | ||
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_TYPE_CODE
, SOURCE_SYSTEM_CODE
, SEEDED_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM QP.QP_PRICE_REQ_SOURCES;
QP.QP_PRICE_REQ_SOURCES does not reference any database object
QP.QP_PRICE_REQ_SOURCES is referenced by following:
|
|
|