eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	QP.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_PRICING_PHASES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRICING_PHASE_ID
QP_PRICING_PHASES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	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.

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
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:

APPS: QP_PRICING_PHASES