VIEW: APPS.QP_DEBUG_REQ_LDETS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)