VIEW: APPS.QP_DEBUG_REQ_LINES_V

Source

View Text - Preformatted

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, a.LINE_NUMBER 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 (+)

View Text - HTML Formatted

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
, A.LINE_NUMBER
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 (+)