View: QP_DEBUG_REQ_LINES_V

Product:	QP - Advanced Pricing
Description:	View that joins QP_DEBUG_REQ_LINES and QP_DEBUG_REQ_RLTD_LINES. It contains information about the lines being priced.
Implementation/DBA Data:	APPS.QP_DEBUG_REQ_LINES_V

View Text

SELECT DISTINCT A.ROWID ROW_ID
, A.REQUEST_ID
, A.REQUEST_TYPE_CODE
, A.LINE_ID
, A.LINE_INDEX
, NVL(B.RELATED_LINE_INDEX
, A.LINE_INDEX) RELATED_LINE_INDEX
, A.LINE_TYPE_CODE
, A.PRICING_EFFECTIVE_DATE
, A.LINE_QUANTITY
, A.LINE_UOM_CODE
, A.PRICED_QUANTITY
, A.PRICED_UOM_CODE
, A.UOM_QUANTITY
, A.CURRENCY_CODE
, A.UNIT_PRICE
, A.PERCENT_PRICE
, A.ADJUSTED_UNIT_PRICE
, A.PARENT_PRICE
, A.PARENT_QUANTITY
, A.PARENT_UOM_CODE
, A.PROCESSING_ORDER
, A.PROCESSED_FLAG
, A.PROCESSED_CODE
, A.PRICE_FLAG
, A.PRICING_STATUS_CODE
, A.PRICING_STATUS_TEXT
, A.START_DATE_ACTIVE_FIRST
, A.ACTIVE_DATE_FIRST_TYPE
, A.START_DATE_ACTIVE_SECOND
, A.ACTIVE_DATE_SECOND_TYPE
, A.GROUP_QUANTITY
, A.GROUP_AMOUNT
, A.LINE_AMOUNT
, A.ROUNDING_FLAG
, A.ROUNDING_FACTOR
, A.UPDATED_ADJUSTED_UNIT_PRICE
, A.PRICE_REQUEST_CODE
, A.HOLD_CODE
, A.HOLD_TEXT
, A.PRICE_LIST_HEADER_ID
, A.VALIDATED_FLAG
, A.QUALIFIERS_EXIST_FLAG
, A.PRICING_ATTRS_EXIST_FLAG
, A.PRIMARY_QUALIFIERS_MATCH_FLAG
, A.USAGE_PRICING_TYPE
FROM QP_DEBUG_REQ_LINES A
, QP_DEBUG_REQ_RLTD_LINES B
WHERE A.REQUEST_ID = B.REQUEST_ID (+)
AND A.LINE_INDEX = B.LINE_INDEX (+)

Columns