View: QP_DEBUG_REQ_LDETS_V

Product:	QP - Advanced Pricing
Description:	View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine elimi
Implementation/DBA Data:	APPS.QP_DEBUG_REQ_LDETS_V

View Text

SELECT DISTINCT A.ROWID ROW_ID
, A.REQUEST_ID
, NVL(B.LINE_DETAIL_INDEX
, A.LINE_DETAIL_INDEX) PARENT_LINE_DETAIL_INDEX
, A.LINE_DETAIL_INDEX
, A.LINE_DETAIL_TYPE_CODE
, A.PRICE_BREAK_TYPE_CODE
, A.LINE_INDEX
, A.CREATED_FROM_LIST_HEADER_ID
, A.CREATED_FROM_LIST_LINE_ID
, A.CREATED_FROM_LIST_LINE_TYPE
, A.CREATED_FROM_LIST_TYPE_CODE
, A.MODIFIER_LEVEL_CODE
, A.CREATED_FROM_SQL
, A.PRICING_GROUP_SEQUENCE
, A.OPERAND_CALCULATION_CODE
, A.OPERAND_VALUE
, A.ADJUSTMENT_AMOUNT
, A.LINE_QUANTITY
, A.SUBSTITUTION_TYPE_CODE
, A.SUBSTITUTION_VALUE_FROM
, A.SUBSTITUTION_VALUE_TO
, A.ASK_FOR_FLAG
, A.PRICE_FORMULA_ID
, A.PROCESSED_FLAG
, A.PRICING_STATUS_CODE
, A.PRICING_STATUS_TEXT
, A.PRODUCT_PRECEDENCE
, A.INCOMPATABILITY_GRP_CODE
, A.BEST_PERCENT
, A.PRICING_PHASE_ID
, A.APPLIED_FLAG
, A.AUTOMATIC_FLAG
, A.OVERRIDE_FLAG
, A.PRINT_ON_INVOICE_FLAG
, A.PRIMARY_UOM_FLAG
, A.BENEFIT_QTY
, A.BENEFIT_UOM_CODE
, A.LIST_LINE_NO
, A.ACCRUAL_FLAG
, A.ACCRUAL_CONVERSION_RATE
, A.ESTIM_ACCRUAL_RATE
, A.RECURRING_FLAG
, A.SELECTED_VOLUME_ATTR
, A.ROUNDING_FACTOR
, A.SECONDARY_PRICELIST_IND
, A.GROUP_QUANTITY
, A.GROUP_AMOUNT
, A.PROCESS_CODE
, A.UPDATED_FLAG
, A.CHARGE_TYPE_CODE
, A.CHARGE_SUBTYPE_CODE
, A.LIMIT_CODE
, A.LIMIT_TEXT
, A.HEADER_LIMIT_EXISTS
, A.LINE_LIMIT_EXISTS
FROM QP_DEBUG_REQ_LDETS A
, QP_DEBUG_REQ_RLTD_LINES B
WHERE A.REQUEST_ID = B.REQUEST_ID (+)
AND A.LINE_DETAIL_INDEX = B.RELATED_LINE_DETAIL_INDEX (+)

Columns