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_LDETS

Object Details

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

This table contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine eliminates.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_DEBUG_REQ_LDETS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID LINE_INDEX 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_DETAIL_INDEX	NUMBER		Yes	PL/SQL unique identifier. Unique identifier of 'request line detail' in calling application.
LINE_DETAIL_TYPE_CODE	VARCHAR2	(30)	Yes	Type of line detail within the request.
PRICE_BREAK_TYPE_CODE	VARCHAR2	(30)		Type of price break. Used for modifiers of type Price Break Header or any single line product modifier with a qualifying condition containing an attribute in the VOLUME context.
LINE_INDEX	NUMBER		Yes	PL/SQL unique identifier for request line.
CREATED_FROM_LIST_HEADER_ID	NUMBER		Yes	Identifies the List Header.
CREATED_FROM_LIST_LINE_ID	NUMBER		Yes	Identifies the List Line.
CREATED_FROM_LIST_LINE_TYPE	VARCHAR2	(30)	Yes	Line type of the list line used to update the pricing line.
CREATED_FROM_LIST_TYPE_CODE	VARCHAR2	(30)		List type of the line used.
MODIFIER_LEVEL_CODE	VARCHAR2	(30)		The level at which the list line qualified for the transaction. Based on lookup type MODIFIER_LEVEL_CODE.
CREATED_FROM_SQL	VARCHAR2	(30)		Indicates which cursor was used by the engine to select the modifier. Used for internal engine use. Possible values:* PRODUCT_ONLY* EXCLUDED_PRODUCT_ONLY* QUALIFIER_ONLY* PRODUCT_QUALIFIER_ONLY* PRODUCT_PRICING_ONLY* PRODUCT_QUALIFIER_PRICING_ONLY* INSERTED IN SECONDARY LIST HEADER SEARCH* INSERTED IN VALIDATED LIST_HEADER_SEARCH1* INSERTED IN NOT VALIDATED LIST_HEADER_SEARCH1* INSERTED IN VALIDATED ASKED FOR PROMOTION SEARCH* INSERTED IN NOT VALIDATED QUAL_LIST_HEADER_SEARCH* INSERTED BY CREATE_QUALIFIER_FROM_LIST.
PRICING_GROUP_SEQUENCE	NUMBER			Indicates the pricing bucket in which the pricing engine applied this list line. If 'MODIFIER_LEVEL' is 'ORDER' or if 'AUTOMATIC_FLAG' is set to 'N', the value in this field can't be modified.
OPERAND_CALCULATION_CODE	VARCHAR2	(30)		Type of operand. Allowable values are: Adjustment percent (for discounts), Adjustment amount (for discounts), Adjustment NewPrice (for discounts), UNIT_PRICE (for price lists), PERCENT_PRICE (for price lists), LUMPSUM.
OPERAND_VALUE	NUMBER			Value of pricing request detail line, for example, 10 currency unit list price with 3% discount.
ADJUSTMENT_AMOUNT	NUMBER			It indicates the dollar value of the adjusted amount. It holds the value of the bucketed adjusted amount for line types like PLL, DIS, and SUR etc. For price break (PBH) child lines, the field is populated if the pricing engine derived the value of the request line or request line detail from a price break.
LINE_QUANTITY	NUMBER			Quantity on the price break line. Populated if the pricing engine derived the value of the request line or request line detail from a price break. A not null value indicates that this particular break line was used in the calculation.
SUBSTITUTION_TYPE_CODE	VARCHAR2	(30)		Not used.
SUBSTITUTION_VALUE_FROM	VARCHAR2	(240)		Not used.
SUBSTITUTION_VALUE_TO	VARCHAR2	(240)		Not used.
ASK_FOR_FLAG	VARCHAR2	(1)		Used for internal engine use. If set to 'Y' it indicates that the selected modifier is 'ASK FOR' modifier.
PRICE_FORMULA_ID	NUMBER			Formula attached to the price list line or modifier line.
PROCESSED_FLAG	VARCHAR2	(1)		Used for internal engine use. Indicates whether line has been processed by engine or not. Possible values: 'N' - Not processed, 'Y' - Processed.
PRICING_STATUS_CODE	VARCHAR2	(30)		Returned status. Possible Values:* N: New record created (All 'N' records are returned back from the pricing engine. These are success records)* X: Unchanged (Default status when the line is passed to the pricing engine for processing)* D: Deleted* U: Updated* IPL: Invalid price list (When passed in price list is not found, then an error is given)* GSA: GSA violation* FER: Error processing formula* OER: Other error* CALC: Error in calculation engine* UOM: Failed to price using unit of measure* INVALID_UOM: Invalid unit of measure* DUPLICATE_PRICE_LIST: Duplicate price list* INVALID_UOM_CONV: Unit of measure conversion not found* INVALID_INCOMP: Could not resolve incompatibility* INVALID_BEST_PRICE: Could not resolve best price.
PRICING_STATUS_TEXT	VARCHAR2	(2000)		Returned message from Pricing Engine.
PRODUCT_PRECEDENCE	NUMBER			It indicates the rank of preference given for the Qualifiers/Pricing Attributes. For the same item if there are more than one incompatible discounts qualifying then the discount with the higher precedence if given.
INCOMPATABILITY_GRP_CODE	VARCHAR2	(30)		This specifies that the discount is incompatible with all other discounts in this incompatibility group. Incompatibilities can be specified for discounts across Modifier types.
BEST_PERCENT	NUMBER			Modifier percentage which gives the best price. Used for internal engine use.
PRICING_PHASE_ID	NUMBER			The pricing phase which created the request line detail.
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: Not applicable when the attribute context is a list or list line.
AUTOMATIC_FLAG	VARCHAR2	(1)		If set to 'Y' it indicates that the pricing engine automatically applied the request line detail to the request line. The engine derives the value from the list line.
OVERRIDE_FLAG	VARCHAR2	(1)		Indicates if a user in the calling application can override the modifier value.
PRINT_ON_INVOICE_FLAG	VARCHAR2	(1)		Reserved for future use.
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. Applicable only to price lists.
BENEFIT_QTY	NUMBER			The accrual quantity for non-monetary accruals or, for promotional goods, item quantity.
BENEFIT_UOM_CODE	VARCHAR2	(30)		The accrual unit of measure for non-monetary accruals, or, for promotional goods, item unit of measure.
LIST_LINE_NO	VARCHAR2	(240)		Modifier Number. In the case of Ask For modifiers, this reference must be quoted on the pricing transaction in order to receive the modifier benefit.
ACCRUAL_FLAG	VARCHAR2	(1)		Indicates whether the discount is an accrual.
ACCRUAL_CONVERSION_RATE	NUMBER			The rate to use when converting a non-monetary accrual to a monetary value.
ESTIM_ACCRUAL_RATE	NUMBER			Indicates the percentage at which to accrue or, for a coupon, the expected rate of redemption of the coupon. Liability is defined as: ACCRUAL OR COUPON VALUE * ESTIM_ ACCRUAL_RATE. Default Value: 100.
RECURRING_FLAG	VARCHAR2	(1)		Not in use.
SELECTED_VOLUME_ATTR	VARCHAR2	(1)		Not in use.
ROUNDING_FACTOR	NUMBER			If ROUNDING_FLAG = Y and the pricing event does not include the base price phase, the rounding factor that the pricing engine should use. This value is passed in by the calling application.
SECONDARY_PRICELIST_IND	VARCHAR2	(1)		Indicates that the pricing used a secondary price list instead of the price list that the calling application requested. Applicable only to price lists.
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.
PROCESS_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.
UPDATED_FLAG	VARCHAR2	(1)		This value is passed in by the calling application. Used for internal engine use.
CHARGE_TYPE_CODE	VARCHAR2	(30)		Indicates the type of charge based on lookup type FREIGHT_CHARGES_TYPE. Used for Freight/Special Charge-type modifiers.
CHARGE_SUBTYPE_CODE	VARCHAR2	(30)		Indicates the type of charge based on lookup type CHARGE_TYPE_CODE.
LIMIT_CODE	VARCHAR2	(30)		The value of this field is set to 'ADJUSTED' when limit is adjusted, set to 'EXCEEDED' when the limit is exceeded. Used for internal engine use.
LIMIT_TEXT	VARCHAR2	(2000)		Returned message from Pricing Engine whenever limit is Exceeded or Adjusted.
HEADER_LIMIT_EXISTS	VARCHAR2	(1)		Value is set to Y if the Header Limit exists.
LINE_LIMIT_EXISTS	VARCHAR2	(1)		Value is set to Y if the Line Limit exists.

Query Text

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


SELECT REQUEST_ID
,      LINE_DETAIL_INDEX
,      LINE_DETAIL_TYPE_CODE
,      PRICE_BREAK_TYPE_CODE
,      LINE_INDEX
,      CREATED_FROM_LIST_HEADER_ID
,      CREATED_FROM_LIST_LINE_ID
,      CREATED_FROM_LIST_LINE_TYPE
,      CREATED_FROM_LIST_TYPE_CODE
,      MODIFIER_LEVEL_CODE
,      CREATED_FROM_SQL
,      PRICING_GROUP_SEQUENCE
,      OPERAND_CALCULATION_CODE
,      OPERAND_VALUE
,      ADJUSTMENT_AMOUNT
,      LINE_QUANTITY
,      SUBSTITUTION_TYPE_CODE
,      SUBSTITUTION_VALUE_FROM
,      SUBSTITUTION_VALUE_TO
,      ASK_FOR_FLAG
,      PRICE_FORMULA_ID
,      PROCESSED_FLAG
,      PRICING_STATUS_CODE
,      PRICING_STATUS_TEXT
,      PRODUCT_PRECEDENCE
,      INCOMPATABILITY_GRP_CODE
,      BEST_PERCENT
,      PRICING_PHASE_ID
,      APPLIED_FLAG
,      AUTOMATIC_FLAG
,      OVERRIDE_FLAG
,      PRINT_ON_INVOICE_FLAG
,      PRIMARY_UOM_FLAG
,      BENEFIT_QTY
,      BENEFIT_UOM_CODE
,      LIST_LINE_NO
,      ACCRUAL_FLAG
,      ACCRUAL_CONVERSION_RATE
,      ESTIM_ACCRUAL_RATE
,      RECURRING_FLAG
,      SELECTED_VOLUME_ATTR
,      ROUNDING_FACTOR
,      SECONDARY_PRICELIST_IND
,      GROUP_QUANTITY
,      GROUP_AMOUNT
,      PROCESS_CODE
,      UPDATED_FLAG
,      CHARGE_TYPE_CODE
,      CHARGE_SUBTYPE_CODE
,      LIMIT_CODE
,      LIMIT_TEXT
,      HEADER_LIMIT_EXISTS
,      LINE_LIMIT_EXISTS
FROM QP.QP_DEBUG_REQ_LDETS;

Dependencies

[top of page]

QP.QP_DEBUG_REQ_LDETS does not reference any database object

QP.QP_DEBUG_REQ_LDETS is referenced by following:

APPS: QP_DEBUG_REQ_LDETS