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_LDETS_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

These pricing details include the price list lines and modifiers resulting from the pricing engine request. These records contain both setup data and also relevant calculation information.

[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_INDEX	NUMBER		Yes	Identifier of request line.
LIST_HEADER_ID	NUMBER		Yes	Identifier of the list header (price list or modifier) used to create or update the pricing line.
LIST_LINE_ID	NUMBER		Yes	Identifier of the list line(price or modifier list line) used to create or update the line being priced.
LIST_LINE_TYPE_CODE	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.
PRICE_BREAK_TYPE_CODE	VARCHAR2	(30)		Type of price break based on lookup type PRICE_BREAK_TYPE_CODE. Possible Values: POINT, RANGE , RECURRING.
LINE_QUANTITY	NUMBER			Pricing request line quantity.
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.
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.
PRICING_PHASE_ID	NUMBER			Pricing Phase identifier. Please refer implementation guide for more details.
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.
PRICING_GROUP_SEQUENCE	NUMBER			Indicates the pricing bucket in which the pricing engine applied this list line.
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.
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
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.
LIMIT_CODE	VARCHAR2	(30)		Identifier of the limit.
LIMIT_TEXT	VARCHAR2	(2000)		Warning or Error Message
LIST_LINE_NO	VARCHAR2	(240)		Modifier number. This field is applicable in case of Coupon Issue kind of modifier line.
GROUP_QUANTITY	NUMBER			Internal Purposes.
UPDATED_FLAG	VARCHAR2	(1)		Internal Purposes.
PROCESS_CODE	VARCHAR2	(30)		Internal Purposes.
SUBSTITUTION_VALUE_TO	VARCHAR2	(240)		The value of the substitution attribute that will be substituted on the pricing request line, e.g. value '2% 30/net 60' for the Payment Terms attribute. Used for modfiers of type Term Substitution.
SUBSTITUTION_ATTRIBUTE	VARCHAR2	(30)		Identifies the attribute in the TERMS context that will be substituted, e.g. QUALIFIER_ATTRIBUTE1 - Payment Terms. Used for modfiers of type Term Substitution.
ACCRUAL_FLAG	VARCHAR2	(1)		Indicates whether the discount is an accrual or not, i.e whether it should be applied retrospectively.
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'
ESTIM_GL_VALUE	NUMBER			The discount or surcharge value of the modifier. Used to estimate the discount cost for non-monetary modifiers.
ACCRUAL_CONVERSION_RATE	NUMBER			The rate at which a non-monetary accrual is converted to a monetary value
OVERRIDE_FLAG	VARCHAR2	(1)		Indicates whether a modifier value can be overridden at the time of pricing a transaction.
PRINT_ON_INVOICE_FLAG	VARCHAR2	(1)		Reserved for future use.
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier in an item relationship - used for list line type Item Upgrade.
ORGANIZATION_ID	NUMBER			Organization identifier in an item relationship - used for list line type Item Upgrade.
RELATED_ITEM_ID	NUMBER			Related inventory item identifier in an item relationship - used for list line type Item Upgrade.
RELATIONSHIP_TYPE_ID	NUMBER			Relationship type identifier in an item relationship - used for list line type Item Upgrade.
ESTIM_ACCRUAL_RATE	NUMBER			Used to indicate the percentage rate at which to accrue (defaults to 100%) or in the case of a coupon the expected rate of redemption of the coupon. Liability would be the accrual or coupon value * ESTIM_ACCRUAL_RATE.
EXPIRATION_DATE	DATE			The expiration date of the accrual or coupon.
BENEFIT_PRICE_LIST_LINE_ID	NUMBER			The price list line identifier for modifiers of type 'Promotional Goods'. Used to derive the list price for the promotional goods before discount.
RECURRING_FLAG	VARCHAR2	(1)		Not used.
BENEFIT_LIMIT	NUMBER			Reserved for future 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.
BENEFIT_QTY	NUMBER			The accrual quantity for non-monetary accruals or, for promotional goods, item quantity.
BENEFIT_UOM_CODE	VARCHAR2	(3)		The accrual unit of measure for non-monetary accruals, or item unit of measure for promotional goods.
PRORATION_TYPE_CODE	VARCHAR2	(30)		Reserved for future use.
INCLUDE_ON_RETURNS_FLAG	VARCHAR2	(1)		Applicable to modifiers of type Freight/Special Charge to indicate whether the charge should be included on a return transaction. Not used by pricing engine, for transaction system use only.
REBATE_TRANSACTION_TYPE_CODE	VARCHAR2	(30)		Reserved for future use.
NUMBER_EXPIRATION_PERIODS	NUMBER			Used, as alternative to setting the EXPIRATION_DATE, to calculate the expiration date for accruals and coupons. The number of periods, of type EXPIRATION_PERIOD_UOM, in which the accrual or coupon expires.
EXPIRATION_PERIOD_UOM	VARCHAR2	(3)		Used, as alternative to setting the EXPIRATION_DATE, to calculate the expiration date for accruals and coupons. The type of Expiration period, e.g. 'week'.
COMMENTS	VARCHAR2	(2000)		Additional descriptive text used on Agreement Lines.
CALCULATION_CODE	VARCHAR2	(30)		Not Used.
CHANGE_REASON_CODE	VARCHAR2	(30)		Internal Purposes
CHANGE_REASON_TEXT	VARCHAR2	(2000)		Internal Purposes
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
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_INDEX
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      LIST_LINE_TYPE_CODE
,      PRICE_BREAK_TYPE_CODE
,      LINE_QUANTITY
,      ADJUSTMENT_AMOUNT
,      AUTOMATIC_FLAG
,      PRICING_PHASE_ID
,      OPERAND_CALCULATION_CODE
,      OPERAND_VALUE
,      PRICING_GROUP_SEQUENCE
,      CREATED_FROM_LIST_TYPE_CODE
,      APPLIED_FLAG
,      PRICING_STATUS_CODE
,      PRICING_STATUS_TEXT
,      LIMIT_CODE
,      LIMIT_TEXT
,      LIST_LINE_NO
,      GROUP_QUANTITY
,      UPDATED_FLAG
,      PROCESS_CODE
,      SUBSTITUTION_VALUE_TO
,      SUBSTITUTION_ATTRIBUTE
,      ACCRUAL_FLAG
,      MODIFIER_LEVEL_CODE
,      ESTIM_GL_VALUE
,      ACCRUAL_CONVERSION_RATE
,      OVERRIDE_FLAG
,      PRINT_ON_INVOICE_FLAG
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      RELATED_ITEM_ID
,      RELATIONSHIP_TYPE_ID
,      ESTIM_ACCRUAL_RATE
,      EXPIRATION_DATE
,      BENEFIT_PRICE_LIST_LINE_ID
,      RECURRING_FLAG
,      BENEFIT_LIMIT
,      CHARGE_TYPE_CODE
,      CHARGE_SUBTYPE_CODE
,      BENEFIT_QTY
,      BENEFIT_UOM_CODE
,      PRORATION_TYPE_CODE
,      INCLUDE_ON_RETURNS_FLAG
,      REBATE_TRANSACTION_TYPE_CODE
,      NUMBER_EXPIRATION_PERIODS
,      EXPIRATION_PERIOD_UOM
,      COMMENTS
,      CALCULATION_CODE
,      CHANGE_REASON_CODE
,      CHANGE_REASON_TEXT
,      PRICE_ADJUSTMENT_ID
,      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_LDETS_V;

Dependencies

[top of page]

APPS.QP_LDETS_V references the following:

APPS: QP_LIST_LINES; QP_PREQ_LDETS_TMP_T

APPS.QP_LDETS_V is referenced by following:

APPS: ASO_PRICING_CORE_PVT - show dependent code; FTE_QP_ENGINE - show dependent code; INL_CHARGE_PVT - show dependent code; OE_ADV_PRICE_PVT - show dependent code; OE_BULK_PRICEORDER_PVT - show dependent code; OE_FREIGHT_CHOICES_PVT - show dependent code; OE_ORDER_PRICE_PVT - show dependent code; OE_PRICE_ORDER_PVT - show dependent code; OE_PRICE_ORDER_PVT_OBSOLETE - show dependent code; OE_RETROBILL_PVT - show dependent code; OZF_ADJUSTMENT_EXT_PVT - show dependent code; OZF_ADJUSTMENT_EXT_PVT - show dependent code; OZF_ORDER_PRICE_PVT - show dependent code; OZF_ORDER_PRICE_PVT - show dependent code; OZF_TP_ACCRUAL_PVT - show dependent code; PO_ADVANCED_PRICE_PVT - show dependent code; PO_MANUAL_MODIFIERS_V; PO_PRICE_ADJUSTMENTS_PKG - show dependent code; PO_SOURCING2_SV - show dependent code; QP_CLEANUP_ADJUSTMENTS_PVT - show dependent code