View: QP_PREQ_LINES_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_LINES_TMP

View Text

SELECT QPT.REQUEST_TYPE_CODE
, QPT.LINE_ID
, QPT.LINE_INDEX
, QPT.LINE_TYPE_CODE
, QPT.PRICING_EFFECTIVE_DATE
, QPT.LINE_QUANTITY
, QPT.LINE_UOM_CODE
, QPT.PRICED_QUANTITY
, QPT.PRICED_UOM_CODE
, QPT.UOM_QUANTITY
, QPT.CURRENCY_CODE
, QPT.UNIT_PRICE
, QPT.PERCENT_PRICE
, QPT.ADJUSTED_UNIT_PRICE
, QPT.PARENT_PRICE
, QPT.PARENT_QUANTITY
, QPT.PARENT_UOM_CODE
, QPT.PROCESSING_ORDER
, QPT.PROCESSED_FLAG
, QPT.PROCESSED_CODE
, QPT.PRICE_FLAG
, QPT.PRICING_STATUS_CODE
, QPT.PRICING_STATUS_TEXT
, QPT.START_DATE_ACTIVE_FIRST
, QPT.ACTIVE_DATE_FIRST_TYPE
, QPT.START_DATE_ACTIVE_SECOND
, QPT.ACTIVE_DATE_SECOND_TYPE
, QPT.GROUP_QUANTITY
, QPT.GROUP_AMOUNT
, QPT.LINE_AMOUNT
, QPT.ROUNDING_FLAG
, QPT.ROUNDING_FACTOR
, QPT.UPDATED_ADJUSTED_UNIT_PRICE
, QPT.PRICE_REQUEST_CODE
, QPT.HOLD_CODE
, QPT.HOLD_TEXT
, QPT.PRICE_LIST_HEADER_ID
, QPT.VALIDATED_FLAG
, QPT.QUALIFIERS_EXIST_FLAG
, QPT.PRICING_ATTRS_EXIST_FLAG
, QPT.PRIMARY_QUALIFIERS_MATCH_FLAG
, QPT.USAGE_PRICING_TYPE
, QPT.LINE_CATEGORY
, QPT.CONTRACT_START_DATE
, QPT.CONTRACT_END_DATE
, QPT.LINE_UNIT_PRICE
, QPT.REQUEST_ID
, QPT.PROCESS_STATUS
, QPT.EXTENDED_PRICE
, QPT.ORDER_UOM_SELLING_PRICE
, QPT.CATCHWEIGHT_QTY
FROM QP_PREQ_LINES_TMP_T QPT
WHERE REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1)

Columns