[Home] [Help] [Dependency Information]
Object Name: | QP_PTE_SEGMENTS |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_PTE_SEGMENTS |
Subobject Name: | |
Status: | VALID |
This table stores the attribute mapping methods, attribute mapping levels and various other information for a given attribute for all the Pricing Transaction Entities that it is linked to. Attributes are available to be used by various Pricing Setups once they are linked to a Pricing Transaction Entity.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_PTE_SEGMENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SEGMENT_PTE_ID |
QP_PTE_SEGMENTS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SEGMENT_ID
PTE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEGMENT_PTE_ID | NUMBER | Yes | System generated unique identifier | |
SEGMENT_ID | NUMBER | Yes | Foreign key reference to QP_SEGMENTS_B.SEGMENT_ID. SEGMENT_ID, PTE_CODE is unique key for this table. | |
PTE_CODE | VARCHAR2 | (30) | Yes | The Pricing Transaction Entity to which the given attribute is linked to. |
SEGMENT_LEVEL | VARCHAR2 | (10) | Yes | Indicates the level for the PTE-Attribute link. Valid values are 'ORDER', 'LINE' or 'BOTH'. |
SOURCING_ENABLED | VARCHAR2 | (1) | Yes | Indiactes whether the PTE-Attribute link is meant to be attriute sourced by the Build Sourcing Program. PTE-Attribute links having attribute mapping method 'ATTRIBUTE MAPPING' only can be enabled. |
SEEDED_SOURCING_METHOD | VARCHAR2 | (30) | Indicates the original attribute mapping method of the seeded PTE-Attribute links, even if they were changed by the user. Valid values are 'ATTRIBUTE MAPPING', 'CUSTOM SOURCED' or 'USER ENTERED'. | |
USER_SOURCING_METHOD | VARCHAR2 | (30) | Yes | Indicates the currentl attribute mapping method of the PTE-Attribute link. Valid values are 'ATTRIBUTE MAPPING', 'CUSTOM SOURCED' or 'USER ENTERED'. |
SOURCING_STATUS | VARCHAR2 | (1) | Yes | Indicates the Attribute Mapping status of the PTE-Attribute link. 'Y' indicates the PTE-Attribute link must have attribute mapping method as 'ATTRIBUTE MAPPING' and must have been attribute mapped by the Build Sourcing program successfully. |
LOV_ENABLED | VARCHAR2 | (1) | Yes | Indicates whether this attribute for the given PTE will appear in the list of values for the various Pricing setup user interfaces. |
LIMITS_ENABLED | VARCHAR2 | (1) | Yes | Indicates whether this attribute for the given PTE will appear the Constraint 1, Constraint 2 and Other Attributeslist of values in the Promotional Limits setup user interface. |
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield segment 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 | ||
USED_IN_SETUP | VARCHAR2 | (1) | Indicates whether the Attribute is attached to at least one Pricing Setup. |
Cut, paste (and edit) the following text to query this object:
SELECT SEGMENT_PTE_ID
, SEGMENT_ID
, PTE_CODE
, SEGMENT_LEVEL
, SOURCING_ENABLED
, SEEDED_SOURCING_METHOD
, USER_SOURCING_METHOD
, SOURCING_STATUS
, LOV_ENABLED
, LIMITS_ENABLED
, 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
, USED_IN_SETUP
FROM QP.QP_PTE_SEGMENTS;
QP.QP_PTE_SEGMENTS does not reference any database object
QP.QP_PTE_SEGMENTS is referenced by following:
|
|
|