DBA Data[Home] [Help] [Dependency Information]

TABLE: QP.QP_PRICING_PHASES

Object Details
Object Name: QP_PRICING_PHASES
Object Type: TABLE
Owner: QP
FND Design Data: TableQP.QP_PRICING_PHASES
Subobject Name:
Status: VALID


QP_PRICING_PHASES stores all pricing phases. A pricing phase controls what modifiers are considered by the search engine and in what sequence they should be applied to the request. The attributes of a pricing phase allow you to control which modifiers can be placed in a phase. A Modifier can only be assigned to one Phase. All Price Lists Lines are automatically placed in the seeded Phase 0 - List Line Base Price and cannot be assigned to any other Phase.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_PRICING_PHASES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICING_PHASE_ID
ColumnZD_EDITION_NAME
QP_PRICING_PHASES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
MODIFIER_LEVEL_CODE VARCHAR2 (30)
The level of qualification and application of a modifier. Used to restrict the modifiers in a phase to modifiers of a particular modifier level. Based on lookup type MODIFIER_LEVEL_CODE.
PHASE_SEQUENCE NUMBER
Yes This number is used by the pricing engine to determine the order of execution of the phases when there are multiple phases in an event.
PRICING_PHASE_ID NUMBER
Yes Identifies the Pricing Phase. System Generated Identifier.
INCOMPAT_RESOLVE_CODE VARCHAR2 (30)
This is the method which will be used for this pricing phase to determine which modifier should be selected when multiple modifiers in the same exclusivity or incompatibility group are eligible to be applied to the same pricing request line. Based on Lookup Type INCOMPAT_RESOLVE_CODE.
NAME VARCHAR2 (240) Yes Name of the pricing phase
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
LIST_TYPE_CODE VARCHAR2 (30)
This stores the type of modifier list. Used to restrict the modifiers in a phase to modifiers belonging to a list of a particular type. Based on lookup type LIST_TYPE_CODE.
LIST_LINE_TYPE_CODE VARCHAR2 (30)
This stores the type of modifier. Used to restrict the modifiers in a phase to modifiers of a particular type. Based on lookup type LIST_LINE_TYPE_CODE.
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
CONTEXT VARCHAR2 (30)
Descriptive Flexfield structure defining column
ATTRIBUTE1 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
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
FREEZE_OVERRIDE_FLAG VARCHAR2 (1)
Used to provide additional control over freezing lines on a transaction. If the Calculate Price flag on the request line is set to P , the pricing engine looks at this flag. If it is Y then the pricing engine will apply eligible modifiers in this phase to the request line, if not then modifiers in this phase will not be considered for application to the request line.
USER_FREEZE_OVERRIDE_FLAG VARCHAR2 (1)
This is the user selected value for freeze_override for this phase
USER_INCOMPAT_RESOLVE_CODE VARCHAR2 (30)
This is the user selected value for INCOMPAT_RESOLVE_CODE for this phase.
LINE_GROUP_EXISTS VARCHAR2 (1)
This column will indicate whether LINE_GROUP modifier level exists for this particular phase
OID_EXISTS VARCHAR2 (1)
This column will indicate whether OID/PRG modifier type exists for this particular phase
RLTD_EXISTS VARCHAR2 (1)
This column will indicate whether additional buy products exist for a OID/PRG modifier type for this particular phase.
FREIGHT_EXISTS VARCHAR2 (1)
Indicates that there exists at least one Freight charge line for the corresponding phase.
MANUAL_MODIFIER_FLAG VARCHAR2 (1)
This column can have values 'A', 'B', 'M', or NULL. Phase will be selected during price request based on the value of this column.
PATTERN_SEARCH_PATH NUMBER (1)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MODIFIER_LEVEL_CODE
,      PHASE_SEQUENCE
,      PRICING_PHASE_ID
,      INCOMPAT_RESOLVE_CODE
,      NAME
,      SEEDED_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LIST_TYPE_CODE
,      LIST_LINE_TYPE_CODE
,      LAST_UPDATE_LOGIN
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      FREEZE_OVERRIDE_FLAG
,      USER_FREEZE_OVERRIDE_FLAG
,      USER_INCOMPAT_RESOLVE_CODE
,      LINE_GROUP_EXISTS
,      OID_EXISTS
,      RLTD_EXISTS
,      FREIGHT_EXISTS
,      MANUAL_MODIFIER_FLAG
,      PATTERN_SEARCH_PATH
,      ZD_EDITION_NAME
FROM QP.QP_PRICING_PHASES;

Dependencies

[top of page]

QP.QP_PRICING_PHASES does not reference any database object

QP.QP_PRICING_PHASES is referenced by following:

SchemaQP
ViewQP_PRICING_PHASES#