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_LINES

Object Details

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

This table contains information about the lines being priced.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_DEBUG_REQ_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID LINE_INDEX

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER		Yes	Request Id is the sequence number to uniquely identify the Debug Requests.
REQUEST_TYPE_CODE	VARCHAR2	(30)	Yes	Identifies the transaction system making the pricing request.
LINE_ID	NUMBER			Unique identifier of the request line in the calling application. Ex. Order Id/Quote Id/Contract Id.
LINE_INDEX	NUMBER		Yes	PL/SQL unique identifier for request line.
LINE_TYPE_CODE	VARCHAR2	(30)	Yes	Type of line within the request. Allowable values are: ORDER, LINE.
PRICING_EFFECTIVE_DATE	DATE			Date & Time for which the pricing engine calculates the prices.
LINE_QUANTITY	NUMBER			Pricing request line quantity.
LINE_UOM_CODE	VARCHAR2	(30)		Pricing request line unit of measure.
PRICED_QUANTITY	NUMBER			Quantity of pricing request line that pricing engine has priced.
PRICED_UOM_CODE	VARCHAR2	(30)		Unit of measure in which the pricing engine priced.
UOM_QUANTITY	NUMBER			This holds service duration expressed in 'Line UOM Code'. Unit of measure quantity, for example, in service pricing, LINE_UOM_CODE is Months and UOM_QUANTITY is 2.This field is used for service item pricing.
CURRENCY_CODE	VARCHAR2	(30)		Currency in which the pricing engine priced.
UNIT_PRICE	NUMBER			Unit price of the item which is expressed in 'Priced UOM Code'.
PERCENT_PRICE	NUMBER			Price calculated as a percentage of the price of another item.
ADJUSTED_UNIT_PRICE	NUMBER			Price per unit after the pricing engine applies discounts and surcharges. It indicates the unit price for the service item, which has the percent price.
PARENT_PRICE	NUMBER			When the pricing engine determines the price of an item from the price of another item, the price of the related item. This is used only for service items and it is populated from the serviceable item.
PARENT_QUANTITY	NUMBER			When the pricing engine determines the price of an item from the price of another item, the quantity of the related item.
PARENT_UOM_CODE	VARCHAR2	(30)		When the pricing engine determines the price of an item from the price of another item, the unit of measure of the related item.
PROCESSING_ORDER	NUMBER			This field is used for service pricing. It indicates the order in which pricing will be done for order lines related to service pricing.
PROCESSED_FLAG	VARCHAR2	(1)		Indicates whether line has been processed by engine or not. Possible values:* 'N' - Not processed* 'Y' - ProcessedUsed for internal engine use.
PROCESSED_CODE	VARCHAR2	(240)		Internal code which indicates the stage of engine processing when an error occurred.
PRICE_FLAG	VARCHAR2	(1)	Yes	Indicates the degree to which the price is frozen. Allowable values, based on lookup type CALCULATE_PRICE_FLAG are:* Y (Calculate Price): Apply all prices and modifiers to the request line.* N (Freeze Price): Do not apply any prices or modifiers to the request line. Consider the volume of the request line when processing LINEGROUP modifiers for other lines.* P (Partial Price): Apply prices and modifiers in phases whose freeze override flag is Y.
PRICING_STATUS_CODE	VARCHAR2	(30)		Returned status. Allowable values are:* 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.
START_DATE_ACTIVE_FIRST	DATE			In addition to the pricing effective date, you can specify two additional dates for the pricing engine to use to qualify pricing entities. The pricing engine compares this date against the first date range on the modifier list-QP_LIST_LINES.START_DATE_ACTIVE_FIRST and QP_LIST_LINES.END_DATE_ACTIVE_FIRST.
ACTIVE_DATE_FIRST_TYPE	VARCHAR2	(30)		The date type of ACTIVE_DATE_FIRST based on lookup type EFFECTIVE_DATE_ TYPES. Default value is 'date Ordered'.
START_DATE_ACTIVE_SECOND	DATE			In addition to the pricing effective date, you can specify two additional dates for the pricing engine to use to qualify pricing entities. The pricing engine compares this date against the first date range on the modifier list-QP_LIST_LINES.START_DATE_ACTIVE_SECOND and QP_LIST_LINES.END_DATE_ACTIVE_SECOND.
ACTIVE_DATE_SECOND_TYPE	VARCHAR2	(30)		The date type of ACTIVE_DATE_SECOND based on lookup type EFFECTIVE_DATE_ TYPES. Default value is 'Requested Ship Date'.
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.
LINE_AMOUNT	NUMBER			Price for the line quantity. Used for internal engine use.
ROUNDING_FLAG	VARCHAR2	(1)		Indicates whether the Pricing Engine uses the Rounding Factor or not. Allowable values: 'Y', 'N'.
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.
UPDATED_ADJUSTED_UNIT_PRICE	NUMBER			To update the adjusted unit price or to manually override the selling price, the calling application writes the new manual updated price into this field and calls the pricing engine. Pricing engine will try to apply the eligible manual adjustments if it can and calculate the new price or if it can't apply the manual adjustments then it will raise an error at that line.
PRICE_REQUEST_CODE	VARCHAR2	(240)		Unique identifier for order line used by limits processing. It will have the structure 'Request Type Code-Order Id-Line Id'. Used for internal engine use.
HOLD_CODE	VARCHAR2	(240)		Whenever the limit is adjusted or exceeded and 'limit_hold_flag' is 'Y' the engine sets value of this field to 'LIMIT'. Used for internal engine use.
HOLD_TEXT	VARCHAR2	(2000)		Whenever the limit is adjusted or exceeded and 'limit_hold_flag' is 'Y' the engine sets the value of the field 'HOLD_CODE' to 'LIMIT' and an appropriate message is set to 'HOLD_TEXT'. Used for internal engine use.
PRICE_LIST_HEADER_ID	NUMBER			Identifies the List Header.
VALIDATED_FLAG	VARCHAR2	(1)		This field is related to PRICE_LIST_HEADER_ID. 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.
QUALIFIERS_EXIST_FLAG	VARCHAR2	(1)		This field is related to PRICE_LIST_HEADER_ID. If set to 'Y', Indicates that the qualifiers exist for the price list. If set to 'N', Indicates that the qualifiers doesn't exist for the price list.
PRICING_ATTRS_EXIST_FLAG	VARCHAR2	(1)		This field is related to PRICE_LIST_HEADER_ID. If set to 'Y', Indicates that pricing attributes exist for the price list. If set to 'N', Indicates that pricing attributes doesn't exist for the price list.
PRIMARY_QUALIFIERS_MATCH_FLAG	VARCHAR2	(1)		This field is related to PRICE_LIST_HEADER_ID. If set to 'Y', Indicates that qualifiers exist for primary price list. If set to 'N', Indicates that qualifiers doesn't exist for primary price list.
USAGE_PRICING_TYPE	VARCHAR2	(30)		Indicates the usage pricing type. Allowable values are: Regular, Billing, Authoring.
LINE_NUMBER	VARCHAR2	(50)		Line Number for Calling Application

Query Text

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


SELECT REQUEST_ID
,      REQUEST_TYPE_CODE
,      LINE_ID
,      LINE_INDEX
,      LINE_TYPE_CODE
,      PRICING_EFFECTIVE_DATE
,      LINE_QUANTITY
,      LINE_UOM_CODE
,      PRICED_QUANTITY
,      PRICED_UOM_CODE
,      UOM_QUANTITY
,      CURRENCY_CODE
,      UNIT_PRICE
,      PERCENT_PRICE
,      ADJUSTED_UNIT_PRICE
,      PARENT_PRICE
,      PARENT_QUANTITY
,      PARENT_UOM_CODE
,      PROCESSING_ORDER
,      PROCESSED_FLAG
,      PROCESSED_CODE
,      PRICE_FLAG
,      PRICING_STATUS_CODE
,      PRICING_STATUS_TEXT
,      START_DATE_ACTIVE_FIRST
,      ACTIVE_DATE_FIRST_TYPE
,      START_DATE_ACTIVE_SECOND
,      ACTIVE_DATE_SECOND_TYPE
,      GROUP_QUANTITY
,      GROUP_AMOUNT
,      LINE_AMOUNT
,      ROUNDING_FLAG
,      ROUNDING_FACTOR
,      UPDATED_ADJUSTED_UNIT_PRICE
,      PRICE_REQUEST_CODE
,      HOLD_CODE
,      HOLD_TEXT
,      PRICE_LIST_HEADER_ID
,      VALIDATED_FLAG
,      QUALIFIERS_EXIST_FLAG
,      PRICING_ATTRS_EXIST_FLAG
,      PRIMARY_QUALIFIERS_MATCH_FLAG
,      USAGE_PRICING_TYPE
,      LINE_NUMBER
FROM QP.QP_DEBUG_REQ_LINES;

Dependencies

[top of page]

QP.QP_DEBUG_REQ_LINES does not reference any database object

QP.QP_DEBUG_REQ_LINES is referenced by following:

QP: QP_DEBUG_REQ_LINES#