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]

VIEW: APPS.QP_PREQ_LDETS_TMP

Object Details

Object Name:	QP_PREQ_LDETS_TMP
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QP.QP_PREQ_LDETS_TMP
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_DETAIL_INDEX	NUMBER		Yes	Unique Identifier of detail line.
LINE_DETAIL_TYPE_CODE	VARCHAR2	(30)	Yes	Type of detail line.
LINE_DETAIL_PBH_TYPE	VARCHAR2	(30)		Not Used.
PRICE_BREAK_TYPE_CODE	VARCHAR2	(30)		Type of price break based on lookup type PRICE_BREAK_TYPE_CODE. Possible Values: POINT, RANGE , RECURRING.
LINE_INDEX	NUMBER		Yes	Identifier of request line.
CREATED_FROM_LIST_HEADER_ID	NUMBER		Yes	Identifier of the list header (price list or modifier) used to create or update the pricing line.
CREATED_FROM_LIST_LINE_ID	NUMBER		Yes	Identifier of the list line(price or modifier list line) used to create or update the line being priced.
CREATED_FROM_LIST_LINE_TYPE	VARCHAR2	(30)	Yes	Type of price list or modifier list line. Possible values could be 'PLL','PBH','DIS','SUR','OID','PRG','TSN', 'IUE'. Check the list line lookup types for the complete list.
CREATED_FROM_LIST_TYPE_CODE	VARCHAR2	(30)		List type of the price list or modifier list . Possible values can be found from the lookup_type LIST_TYPE_CODE from qp_lookups table. Ex: 'Price List' , 'Agreement List' , 'Modifier List' etc.
MODIFIER_LEVEL_CODE	VARCHAR2	(30)		The level at which the list line qualified for the transaction. Based on lookup type MODIFIER_LEVEL_CODE. Possible Values are: 'LINE', 'ORDER', 'LINEGROUP'
CREATED_FROM_SQL	VARCHAR2	(30)		Internal purposes.
PRICING_GROUP_SEQUENCE	NUMBER			Indicates the pricing bucket in which the pricing engine applied this list line.
OPERAND_CALCULATION_CODE	VARCHAR2	(30)		Type of operand. Allowable values are:1. Adjustment percent (for discounts)2. Adjustment amount (for discounts)3. Adjustment New Price(for discounts)4. UNIT_PRICE( for price lists)5. PERCENT_PRICE (for price lists)
OPERAND_VALUE	NUMBER			Value of pricing request detail line, for example, 10 currency unit list price with 3% discount.
ADJUSTMENT_AMOUNT	NUMBER			It holds the value of the bucketed adjusted amount for line types like PLL, DIS, 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			Pricing request line quantity.
SUBSTITUTION_TYPE_CODE	VARCHAR2	(30)		Not used.
SUBSTITUTION_VALUE_FROM	VARCHAR2	(240)		Not used.
SUBSTITUTION_VALUE_TO	VARCHAR2	(240)		Value for terms substitution value.
ASK_FOR_FLAG	VARCHAR2	(1)		Indicates whether the user must ask for the "List", e.g. quote a promotion number, to get the benefits on the list. The pricing engine ignores any lists where 'Ask For = Y' if they have not been quoted on the pricing request.
PRICE_FORMULA_ID	NUMBER			Identifier for the formula associated with the list line.
PROCESSED_FLAG	VARCHAR2	(1)		Internal Purposes
PRICING_STATUS_CODE	VARCHAR2	(30)	Yes	Returned status. Possible Values:N: New record created (All 'N' records are returned back from the pricing engine. These are success records). Please check the Pricing Open Interfaces Manual API guide for list of possible values and explanation.
PRICING_STATUS_TEXT	VARCHAR2	(2000)		Returned message.
PRODUCT_PRECEDENCE	NUMBER			Precedence or selectivity for product. Used for resolving incompatibilities.
INCOMPATABILITY_GRP_CODE	VARCHAR2	(30)		Identifier of the incompatibility group that the modifier is assigned to.
BEST_PERCENT	NUMBER			Internal Purposes.
PRICING_PHASE_ID	NUMBER			Pricing Phase identifier. Please refer implementation guide for more details.
APPLIED_FLAG	VARCHAR2	(1)		The lists or list lines that this pricing event or a prior pricing event applied. Allowable values are1. Yes: Applicable when the attribute context is a list or list line2. No: Applicable when the attribute context is a list or list line3. Null
AUTOMATIC_FLAG	VARCHAR2	(1)		Indicates if the pricing engine should automatically apply 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)		Not used.
PRIMARY_UOM_FLAG	VARCHAR2	(1)		Indicates whether there should be uom conversion for price list lines.
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. This field is applicable in case of Coupon Issue kind of modifier line.
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			The discount or surcharge value of the modifier. Used to estimate the discount cost for non-monetary modifiers.
RECURRING_FLAG	VARCHAR2	(1)		Not used.
SELECTED_VOLUME_ATTR	VARCHAR2	(1)		Internal Purposes.
ROUNDING_FACTOR	NUMBER			Used in rounding the price to the precision indicated by ROUNDING_FACTOR..
SECONDARY_PRICELIST_IND	VARCHAR2	(1)		Will be 'Y' if the item is found on the secondary price list.
GROUP_QUANTITY	NUMBER			Internal Purposes.
GROUP_AMOUNT	NUMBER			Internal Purposes.
PROCESS_CODE	VARCHAR2	(30)		Internal Purposes.
UPDATED_FLAG	VARCHAR2	(1)		Internal Purposes.
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)		Identifier of the limit.
LIMIT_TEXT	VARCHAR2	(2000)		Warning or Error Message
HEADER_LIMIT_EXISTS	VARCHAR2	(1)		Indicates whether there are any limits set at the list header level.
LINE_LIMIT_EXISTS	VARCHAR2	(1)		Indicates whether there are any limits set at the list line level.
CALCULATION_CODE	VARCHAR2	(30)		Not Used.
CURRENCY_HEADER_ID	NUMBER			Identifier of the currency header used.
PRICING_EFFECTIVE_DATE	DATE			Date for which the pricing engine calculates the prices.
BASE_CURRENCY_CODE	VARCHAR2	(15)		Base currency code used for conversion.
ORDER_CURRENCY	VARCHAR2	(15)		Currency on the request line.
CURRENCY_DETAIL_ID	NUMBER			Identifier of currency detail.
SELLING_ROUNDING_FACTOR	NUMBER			Used in rounding the selling price indicated by the ROUNDING_FACTOR.
CHANGE_REASON_CODE	VARCHAR2	(30)		Internal Purposes
CHANGE_REASON_TEXT	VARCHAR2	(2000)		Internal Purposes
REQUEST_ID	NUMBER			Request line identifier distinguishes between any two pricing engine calls.
PRICE_ADJUSTMENT_ID	NUMBER			This column indicates the price_adjustment_id for the newadjustments the pricing engine has applied to be inserted into OE_PRICE_ADJUSTMENTS when Order Management makes a pricing engine request. We pick up the price_adjustment_id from the sequence OE_PRICE_ADJUSTMENTS_S
RECURRING_VALUE	NUMBER			Holds the recurring value in block price breaks
NET_AMOUNT_FLAG	VARCHAR2	(1)		Indicates whether to use bucketed item amount for Price Break Calculation. Applicable only in case of Price Breaks modifiers.
ORDER_QTY_OPERAND	NUMBER			The pricing engine calculates the operand in ordered quantity in this column. This column preserves the rounding that was lost when the calling application had to this.
ORDER_QTY_ADJ_AMT	NUMBER			The pricing engine calculates the adjustment amount in ordered quantity in this column. This column preserves the rounding that was lost when the calling application had to this.
ACCUM_CONTEXT	VARCHAR2	(30)		Context of accumulation attribute for price break
ACCUM_ATTRIBUTE	VARCHAR2	(240)		The pricing attribute designated as the accumulation attribute for the price break
ACCUM_ATTR_RUN_SRC_FLAG	VARCHAR2	(1)		Flag indicating whether or not to runtime source the accumulation value for the price break
BREAK_UOM_CODE	VARCHAR2	(3)		Unit of Measure code for the price break
BREAK_UOM_CONTEXT	VARCHAR2	(30)		Context to define the seeded context for break UOM
BREAK_UOM_ATTRIBUTE	VARCHAR2	(30)		Attribute in which the calling application is supposed to pass the break UOM of the volume attribute used in the price break

Query Text

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


SELECT LINE_DETAIL_INDEX
,      LINE_DETAIL_TYPE_CODE
,      LINE_DETAIL_PBH_TYPE
,      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
,      CALCULATION_CODE
,      CURRENCY_HEADER_ID
,      PRICING_EFFECTIVE_DATE
,      BASE_CURRENCY_CODE
,      ORDER_CURRENCY
,      CURRENCY_DETAIL_ID
,      SELLING_ROUNDING_FACTOR
,      CHANGE_REASON_CODE
,      CHANGE_REASON_TEXT
,      REQUEST_ID
,      PRICE_ADJUSTMENT_ID
,      RECURRING_VALUE
,      NET_AMOUNT_FLAG
,      ORDER_QTY_OPERAND
,      ORDER_QTY_ADJ_AMT
,      ACCUM_CONTEXT
,      ACCUM_ATTRIBUTE
,      ACCUM_ATTR_RUN_SRC_FLAG
,      BREAK_UOM_CODE
,      BREAK_UOM_CONTEXT
,      BREAK_UOM_ATTRIBUTE
FROM APPS.QP_PREQ_LDETS_TMP;

Dependencies

[top of page]

APPS.QP_PREQ_LDETS_TMP references the following:

APPS: QP_PREQ_LDETS_TMP_T

APPS.QP_PREQ_LDETS_TMP is referenced by following:

APPS: ASO_PRICING_CORE_PVT - show dependent code; OE_ADV_PRICE_PVT - show dependent code; OE_BULK_PRICEORDER_PVT - show dependent code; OE_OE_AVAILABILITY - show dependent code; OE_OE_FORM_LINE_ADJ - show dependent code; OE_OE_PRICING_AVAILABILITY - show dependent code; OE_ORDER_ADJ_PVT - show dependent code; OE_ORDER_PRICE_PVT - show dependent code; OE_RETROBILL_PVT - show dependent code; ONT_FREIGHT_UTIL - show dependent code; QP_PRICE_BOOK_PVT - show dependent code