[Home] [Help] [Dependency Information]
Object Name: | QP_ATTRIBUTE_SOURCING |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_ATTRIBUTE_SOURCING |
Subobject Name: | |
Status: | VALID |
This table stores attribute mapping rules rules defined for an attribute for the Request types for each of the Pricing Transaction entity, it is linked to. The attribute mapping rules stored may be at Order, Line or both levels, depending on the value of Attribute mapping method of the PTE-Attribute link.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_ATTRIBUTE_SOURCING_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ATTRIBUTE_SOURCING_ID |
QP_ATTRIBUTE_SOURCING_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SEGMENT_ID
REQUEST_TYPE_CODE ATTRIBUTE_SOURCING_LEVEL |
QP_ATTRIBUTE_SOURCING_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | USER_VALUE_STRING |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ATTRIBUTE_SOURCING_ID | NUMBER | Yes | System generated unique identifier | |
SEGMENT_ID | NUMBER | Yes | Foreign key reference to QP_PTE_SEGMENTS.SEGMENT_ID. | |
REQUEST_TYPE_CODE | VARCHAR2 | (30) | Yes | This column stores individual request types that belong to the Pricing Transaction Entity, to which the attribute is linked to in QP_PTE_SEGMENTS. There are as many attribute mapping rules for as many request types. |
ATTRIBUTE_SOURCING_LEVEL | VARCHAR2 | (30) | Yes | Indicates the level of the Attribute mapping rule. Valid values are 'ORDER' or 'LINE'. |
APPLICATION_ID | NUMBER | Yes | Indicates the application that created the Attribute Mapping rule. Typical applications that create attribute mapping rules are Oracle Pricing, Oracle Marketing, Oracle Contracts core. | |
SEEDED_SOURCING_TYPE | VARCHAR2 | (30) | Indicates the Sourcing type. Valid values are API, API_MULTIREC, CONSTANT, PROFILE_OPTION or SYSTEM. | |
USER_SOURCING_TYPE | VARCHAR2 | (30) | Yes | Indicates the current sourcing type of seeded and user entered attribute mapping rules. Valid values are API, API_MULTIREC, CONSTANT, PROFILE_OPTION or SYSTEM. |
SEEDED_VALUE_STRING | VARCHAR2 | (2000) | This column contains the original value for the seeded attribute mapping rule. | |
USER_VALUE_STRING | VARCHAR2 | (2000) | Yes | This column contains the current attribute mapping rule for seeded as well as user entered attributes. |
SEEDED_FLAG | VARCHAR2 | (1) | Yes | Indicates if the Attribute mapping rule is a part of seed data or not. |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates if the Attribute mapping rule is enabled or not. Currently, this feature is not implemented. |
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 | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard WHO Column | ||
PROGRAM_ID | NUMBER | Standard WHO Column | ||
PROGRAM_UPDATE_DATE | DATE | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT ATTRIBUTE_SOURCING_ID
, SEGMENT_ID
, REQUEST_TYPE_CODE
, ATTRIBUTE_SOURCING_LEVEL
, APPLICATION_ID
, SEEDED_SOURCING_TYPE
, USER_SOURCING_TYPE
, SEEDED_VALUE_STRING
, USER_VALUE_STRING
, SEEDED_FLAG
, ENABLED_FLAG
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM QP.QP_ATTRIBUTE_SOURCING;
QP.QP_ATTRIBUTE_SOURCING does not reference any database object
QP.QP_ATTRIBUTE_SOURCING is referenced by following:
|
|
|