View: QP_PREQ_LDETS_TMP

Product:	QP - Advanced Pricing
Description:	Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
Implementation/DBA Data:	APPS.QP_PREQ_LDETS_TMP

View Text

SELECT QPT.LINE_DETAIL_INDEX
, QPT.LINE_DETAIL_TYPE_CODE
, QPT.LINE_DETAIL_PBH_TYPE
, QPT.PRICE_BREAK_TYPE_CODE
, QPT.LINE_INDEX
, QPT.CREATED_FROM_LIST_HEADER_ID
, QPT.CREATED_FROM_LIST_LINE_ID
, QPT.CREATED_FROM_LIST_LINE_TYPE
, QPT.CREATED_FROM_LIST_TYPE_CODE
, QPT.MODIFIER_LEVEL_CODE
, QPT.CREATED_FROM_SQL
, QPT.PRICING_GROUP_SEQUENCE
, QPT.OPERAND_CALCULATION_CODE
, QPT.OPERAND_VALUE
, QPT.ADJUSTMENT_AMOUNT
, QPT.LINE_QUANTITY
, QPT.SUBSTITUTION_TYPE_CODE
, QPT.SUBSTITUTION_VALUE_FROM
, QPT.SUBSTITUTION_VALUE_TO
, QPT.ASK_FOR_FLAG
, QPT.PRICE_FORMULA_ID
, QPT.PROCESSED_FLAG
, QPT.PRICING_STATUS_CODE
, QPT.PRICING_STATUS_TEXT
, QPT.PRODUCT_PRECEDENCE
, QPT.INCOMPATABILITY_GRP_CODE
, QPT.BEST_PERCENT
, QPT.PRICING_PHASE_ID
, QPT.APPLIED_FLAG
, QPT.AUTOMATIC_FLAG
, QPT.OVERRIDE_FLAG
, QPT.PRINT_ON_INVOICE_FLAG
, QPT.PRIMARY_UOM_FLAG
, QPT.BENEFIT_QTY
, QPT.BENEFIT_UOM_CODE
, QPT.LIST_LINE_NO
, QPT.ACCRUAL_FLAG
, QPT.ACCRUAL_CONVERSION_RATE
, QPT.ESTIM_ACCRUAL_RATE
, QPT.RECURRING_FLAG
, QPT.SELECTED_VOLUME_ATTR
, QPT.ROUNDING_FACTOR
, QPT.SECONDARY_PRICELIST_IND
, QPT.GROUP_QUANTITY
, QPT.GROUP_AMOUNT
, QPT.PROCESS_CODE
, QPT.UPDATED_FLAG
, QPT.CHARGE_TYPE_CODE
, QPT.CHARGE_SUBTYPE_CODE
, QPT.LIMIT_CODE
, QPT.LIMIT_TEXT
, QPT.HEADER_LIMIT_EXISTS
, QPT.LINE_LIMIT_EXISTS
, QPT.CALCULATION_CODE
, QPT.CURRENCY_HEADER_ID
, QPT.PRICING_EFFECTIVE_DATE
, QPT.BASE_CURRENCY_CODE
, QPT.ORDER_CURRENCY
, QPT.CURRENCY_DETAIL_ID
, QPT.SELLING_ROUNDING_FACTOR
, QPT.CHANGE_REASON_CODE
, QPT.CHANGE_REASON_TEXT
, QPT.REQUEST_ID
, QPT.PRICE_ADJUSTMENT_ID
, QPT.RECURRING_VALUE
, QPT.NET_AMOUNT_FLAG
, QPT.ORDER_QTY_OPERAND
, QPT.ORDER_QTY_ADJ_AMT
FROM QP_PREQ_LDETS_TMP_T QPT
WHERE REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1)

Columns