VIEW: QP.QP_DEBUG_REQ_LINES#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, REQUEST_TYPE_CODE REQUEST_TYPE_CODE, LINE_ID LINE_ID, LINE_INDEX LINE_INDEX, LINE_TYPE_CODE LINE_TYPE_CODE, PRICING_EFFECTIVE_DATE PRICING_EFFECTIVE_DATE, LINE_QUANTITY LINE_QUANTITY, LINE_UOM_CODE LINE_UOM_CODE, PRICED_QUANTITY PRICED_QUANTITY, PRICED_UOM_CODE PRICED_UOM_CODE, UOM_QUANTITY UOM_QUANTITY, CURRENCY_CODE CURRENCY_CODE, UNIT_PRICE UNIT_PRICE, PERCENT_PRICE PERCENT_PRICE, ADJUSTED_UNIT_PRICE ADJUSTED_UNIT_PRICE, PARENT_PRICE PARENT_PRICE, PARENT_QUANTITY PARENT_QUANTITY, PARENT_UOM_CODE PARENT_UOM_CODE, PROCESSING_ORDER PROCESSING_ORDER, PROCESSED_FLAG PROCESSED_FLAG, PROCESSED_CODE PROCESSED_CODE, PRICE_FLAG PRICE_FLAG, PRICING_STATUS_CODE PRICING_STATUS_CODE, PRICING_STATUS_TEXT PRICING_STATUS_TEXT, START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, ACTIVE_DATE_FIRST_TYPE ACTIVE_DATE_FIRST_TYPE, START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, ACTIVE_DATE_SECOND_TYPE ACTIVE_DATE_SECOND_TYPE, GROUP_QUANTITY GROUP_QUANTITY, GROUP_AMOUNT GROUP_AMOUNT, LINE_AMOUNT LINE_AMOUNT, ROUNDING_FLAG ROUNDING_FLAG, ROUNDING_FACTOR ROUNDING_FACTOR, UPDATED_ADJUSTED_UNIT_PRICE UPDATED_ADJUSTED_UNIT_PRICE, PRICE_REQUEST_CODE PRICE_REQUEST_CODE, HOLD_CODE HOLD_CODE, HOLD_TEXT HOLD_TEXT, PRICE_LIST_HEADER_ID PRICE_LIST_HEADER_ID, VALIDATED_FLAG VALIDATED_FLAG, QUALIFIERS_EXIST_FLAG QUALIFIERS_EXIST_FLAG, PRICING_ATTRS_EXIST_FLAG PRICING_ATTRS_EXIST_FLAG, PRIMARY_QUALIFIERS_MATCH_FLAG PRIMARY_QUALIFIERS_MATCH_FLAG, USAGE_PRICING_TYPE USAGE_PRICING_TYPE, LINE_NUMBER LINE_NUMBER from "QP"."QP_DEBUG_REQ_LINES"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, REQUEST_TYPE_CODE REQUEST_TYPE_CODE
, LINE_ID LINE_ID
, LINE_INDEX LINE_INDEX
, LINE_TYPE_CODE LINE_TYPE_CODE
, PRICING_EFFECTIVE_DATE PRICING_EFFECTIVE_DATE
, LINE_QUANTITY LINE_QUANTITY
, LINE_UOM_CODE LINE_UOM_CODE
, PRICED_QUANTITY PRICED_QUANTITY
, PRICED_UOM_CODE PRICED_UOM_CODE
, UOM_QUANTITY UOM_QUANTITY
, CURRENCY_CODE CURRENCY_CODE
, UNIT_PRICE UNIT_PRICE
, PERCENT_PRICE PERCENT_PRICE
, ADJUSTED_UNIT_PRICE ADJUSTED_UNIT_PRICE
, PARENT_PRICE PARENT_PRICE
, PARENT_QUANTITY PARENT_QUANTITY
, PARENT_UOM_CODE PARENT_UOM_CODE
, PROCESSING_ORDER PROCESSING_ORDER
, PROCESSED_FLAG PROCESSED_FLAG
, PROCESSED_CODE PROCESSED_CODE
, PRICE_FLAG PRICE_FLAG
, PRICING_STATUS_CODE PRICING_STATUS_CODE
, PRICING_STATUS_TEXT PRICING_STATUS_TEXT
, START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST
, ACTIVE_DATE_FIRST_TYPE ACTIVE_DATE_FIRST_TYPE
, START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND
, ACTIVE_DATE_SECOND_TYPE ACTIVE_DATE_SECOND_TYPE
, GROUP_QUANTITY GROUP_QUANTITY
, GROUP_AMOUNT GROUP_AMOUNT
, LINE_AMOUNT LINE_AMOUNT
, ROUNDING_FLAG ROUNDING_FLAG
, ROUNDING_FACTOR ROUNDING_FACTOR
, UPDATED_ADJUSTED_UNIT_PRICE UPDATED_ADJUSTED_UNIT_PRICE
, PRICE_REQUEST_CODE PRICE_REQUEST_CODE
, HOLD_CODE HOLD_CODE
, HOLD_TEXT HOLD_TEXT
, PRICE_LIST_HEADER_ID PRICE_LIST_HEADER_ID
, VALIDATED_FLAG VALIDATED_FLAG
, QUALIFIERS_EXIST_FLAG QUALIFIERS_EXIST_FLAG
, PRICING_ATTRS_EXIST_FLAG PRICING_ATTRS_EXIST_FLAG
, PRIMARY_QUALIFIERS_MATCH_FLAG PRIMARY_QUALIFIERS_MATCH_FLAG
, USAGE_PRICING_TYPE USAGE_PRICING_TYPE
, LINE_NUMBER LINE_NUMBER
FROM "QP"."QP_DEBUG_REQ_LINES"