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_DEBUG_REQ_LINE_ATTRS

Object Details

Object Name:	QP_DEBUG_REQ_LINE_ATTRS
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_DEBUG_REQ_LINE_ATTRS
Subobject Name:
Status:	VALID

This table contains information on the pricing attributes that the attribute mapping functionality passed to the pricing engine. The pricing engine uses these attributes to qualify a line or an order for benefits.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_DEBUG_REQ_LINE_ATTRS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID LINE_INDEX
QP_DEBUG_REQ_LINE_ATTRS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID LINE_DETAIL_INDEX

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER		Yes	Request Id is the sequence number to uniquely identify the Debug Requests.
LINE_INDEX	NUMBER		Yes	PL/SQL unique identifier for request line.
LINE_DETAIL_INDEX	NUMBER			PL/SQL unique identifier. Unique identifier of 'request line detail' in calling application.
LINE_ATTRIBUTE_ID	NUMBER		Yes	Line Attributet Id is the sequence number to uniquely identify the Debug Line Attributes.
ATTRIBUTE_LEVEL	VARCHAR2	(30)		Level of attribute. Allowable values are: Line, Detail, Order.
ATTRIBUTE_TYPE	VARCHAR2	(30)		Type of Attribute. Allowable values are: Qualifier, Product, Pricing.
LIST_HEADER_ID	NUMBER			Identifies the List Header.
LIST_LINE_ID	NUMBER			Identifies the List Line.
CONTEXT	VARCHAR2	(30)	Yes	Context for a product or pricing attribute, for example, Product Hierarchy.
ATTRIBUTE	VARCHAR2	(30)	Yes	Product or pricing attribute, for example, PRICING_ATTRIBUTE11: Customer Item ID.
VALUE_FROM	VARCHAR2	(240)	Yes	Passed in value for product or pricing attribute.
SETUP_VALUE_FROM	VARCHAR2	(240)		Setup value for product or pricing attribute.
VALUE_TO	VARCHAR2	(240)		Passed in value for product or pricing attribute.
SETUP_VALUE_TO	VARCHAR2	(240)		Setup value for product or pricing attribute.
GROUPING_NUMBER	NUMBER			It indicates the qualifier grouping number which is used to group qualifiers together to create AND/OR relationships.
NO_QUALIFIERS_IN_GRP	NUMBER			Indicates the count of the Qualifiers in the group.
COMPARISON_OPERATOR_TYPE_CODE	VARCHAR2	(30)		The relational operator code used to define how the pricing engine should evaluate the pricing attributes or qualifier attributes, based on lookup type 'COMPARISON_OPERATOR'.
VALIDATED_FLAG	VARCHAR2	(1)		If set to 'Y', Indicates that the price list is validated and no qualification check is necessary. If set to 'N', Indicates that the price list is not validated.
APPLIED_FLAG	VARCHAR2	(1)		The lists or list lines that this pricing event or a prior pricing event applied. Allowable values are:* Yes: Applicable when the attribute context is a list or list line, * No: Applicable when the attribute context is a list or list line. During simulation, if the user wants an un-applied or rejected line to be considered by the engine for pricing, user can check this flag and re-price.
PRICING_STATUS_CODE	VARCHAR2	(30)		Returned status from the pricing engine.
PRICING_STATUS_TEXT	VARCHAR2	(240)		Returned message from Pricing Engine.
QUALIFIER_PRECEDENCE	NUMBER			The precedence number, or selectivity of the qualifier attribute in the Qualifier Descriptive Flexfield. It is used by the pricing engine for in-compatability resolution.
PRICING_ATTR_FLAG	VARCHAR2	(30)		Pricing Attribute Flag.
QUALIFIER_TYPE	VARCHAR2	(30)		Type of Qualifier.
DATATYPE	VARCHAR2	(30)		Date Type of Attribute Value.
PRODUCT_UOM_CODE	VARCHAR2	(3)		unit of measure of the item, product group etc. for which the price or modifier is defined.
PROCESSED_CODE	VARCHAR2	(30)		This is set by the engine and used for selecting lines for calculation. Used for internal engine use. Possible values: N - New, D - Deleted, X - Unchanged.
EXCLUDER_FLAG	VARCHAR2	(1)		Excluder Flag.
GROUP_QUANTITY	NUMBER			Sum of the quantity of group of lines. Used for internal engine use.
GROUP_AMOUNT	NUMBER			Sum of the price of group of lines. Used for internal engine use.
DISTINCT_QUALIFIER_FLAG	VARCHAR2	(1)		To determine qualification engine sets this flag to indicate that this is unique qualifier.
PRICING_PHASE_ID	NUMBER			The pricing phase which created the line attributel.
INCOMPATABILITY_GRP_CODE	VARCHAR2	(30)		References the Incompatibility Group that the modifier is assigned to , based on lookup type INCOMPATIBILITY GROUPS.
LINE_DETAIL_TYPE_CODE	VARCHAR2	(30)		Type of line detail within the request.
MODIFIER_LEVEL_CODE	VARCHAR2	(30)		The level at which the list line qualified for the transaction. Based on lookup type MODIFIER_LEVEL_CODE.
PRIMARY_UOM_FLAG	VARCHAR2	(1)		If set to 'Y' it indicates that if the price cannot be found for a product in the UOM passed from the calling application, the pricing engine will convert the transaction quantity to the primary UOM specified.

Query Text

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


SELECT REQUEST_ID
,      LINE_INDEX
,      LINE_DETAIL_INDEX
,      LINE_ATTRIBUTE_ID
,      ATTRIBUTE_LEVEL
,      ATTRIBUTE_TYPE
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      CONTEXT
,      ATTRIBUTE
,      VALUE_FROM
,      SETUP_VALUE_FROM
,      VALUE_TO
,      SETUP_VALUE_TO
,      GROUPING_NUMBER
,      NO_QUALIFIERS_IN_GRP
,      COMPARISON_OPERATOR_TYPE_CODE
,      VALIDATED_FLAG
,      APPLIED_FLAG
,      PRICING_STATUS_CODE
,      PRICING_STATUS_TEXT
,      QUALIFIER_PRECEDENCE
,      PRICING_ATTR_FLAG
,      QUALIFIER_TYPE
,      DATATYPE
,      PRODUCT_UOM_CODE
,      PROCESSED_CODE
,      EXCLUDER_FLAG
,      GROUP_QUANTITY
,      GROUP_AMOUNT
,      DISTINCT_QUALIFIER_FLAG
,      PRICING_PHASE_ID
,      INCOMPATABILITY_GRP_CODE
,      LINE_DETAIL_TYPE_CODE
,      MODIFIER_LEVEL_CODE
,      PRIMARY_UOM_FLAG
FROM QP.QP_DEBUG_REQ_LINE_ATTRS;

Dependencies

[top of page]

QP.QP_DEBUG_REQ_LINE_ATTRS does not reference any database object

QP.QP_DEBUG_REQ_LINE_ATTRS is referenced by following:

QP: QP_DEBUG_REQ_LINE_ATTRS#