VIEW: QP.QP_DEBUG_REQ_LDETS#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, LINE_DETAIL_INDEX LINE_DETAIL_INDEX, LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE, PRICE_BREAK_TYPE_CODE PRICE_BREAK_TYPE_CODE, LINE_INDEX LINE_INDEX, CREATED_FROM_LIST_HEADER_ID CREATED_FROM_LIST_HEADER_ID, CREATED_FROM_LIST_LINE_ID CREATED_FROM_LIST_LINE_ID, CREATED_FROM_LIST_LINE_TYPE CREATED_FROM_LIST_LINE_TYPE, CREATED_FROM_LIST_TYPE_CODE CREATED_FROM_LIST_TYPE_CODE, MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE, CREATED_FROM_SQL CREATED_FROM_SQL, PRICING_GROUP_SEQUENCE PRICING_GROUP_SEQUENCE, OPERAND_CALCULATION_CODE OPERAND_CALCULATION_CODE, OPERAND_VALUE OPERAND_VALUE, ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT, LINE_QUANTITY LINE_QUANTITY, SUBSTITUTION_TYPE_CODE SUBSTITUTION_TYPE_CODE, SUBSTITUTION_VALUE_FROM SUBSTITUTION_VALUE_FROM, SUBSTITUTION_VALUE_TO SUBSTITUTION_VALUE_TO, ASK_FOR_FLAG ASK_FOR_FLAG, PRICE_FORMULA_ID PRICE_FORMULA_ID, PROCESSED_FLAG PROCESSED_FLAG, PRICING_STATUS_CODE PRICING_STATUS_CODE, PRICING_STATUS_TEXT PRICING_STATUS_TEXT, PRODUCT_PRECEDENCE PRODUCT_PRECEDENCE, INCOMPATABILITY_GRP_CODE INCOMPATABILITY_GRP_CODE, BEST_PERCENT BEST_PERCENT, PRICING_PHASE_ID PRICING_PHASE_ID, APPLIED_FLAG APPLIED_FLAG, AUTOMATIC_FLAG AUTOMATIC_FLAG, OVERRIDE_FLAG OVERRIDE_FLAG, PRINT_ON_INVOICE_FLAG PRINT_ON_INVOICE_FLAG, PRIMARY_UOM_FLAG PRIMARY_UOM_FLAG, BENEFIT_QTY BENEFIT_QTY, BENEFIT_UOM_CODE BENEFIT_UOM_CODE, LIST_LINE_NO LIST_LINE_NO, ACCRUAL_FLAG ACCRUAL_FLAG, ACCRUAL_CONVERSION_RATE ACCRUAL_CONVERSION_RATE, ESTIM_ACCRUAL_RATE ESTIM_ACCRUAL_RATE, RECURRING_FLAG RECURRING_FLAG, SELECTED_VOLUME_ATTR SELECTED_VOLUME_ATTR, ROUNDING_FACTOR ROUNDING_FACTOR, SECONDARY_PRICELIST_IND SECONDARY_PRICELIST_IND, GROUP_QUANTITY GROUP_QUANTITY, GROUP_AMOUNT GROUP_AMOUNT, PROCESS_CODE PROCESS_CODE, UPDATED_FLAG UPDATED_FLAG, CHARGE_TYPE_CODE CHARGE_TYPE_CODE, CHARGE_SUBTYPE_CODE CHARGE_SUBTYPE_CODE, LIMIT_CODE LIMIT_CODE, LIMIT_TEXT LIMIT_TEXT, HEADER_LIMIT_EXISTS HEADER_LIMIT_EXISTS, LINE_LIMIT_EXISTS LINE_LIMIT_EXISTS from "QP"."QP_DEBUG_REQ_LDETS"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, LINE_DETAIL_INDEX LINE_DETAIL_INDEX
, LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE
, PRICE_BREAK_TYPE_CODE PRICE_BREAK_TYPE_CODE
, LINE_INDEX LINE_INDEX
, CREATED_FROM_LIST_HEADER_ID CREATED_FROM_LIST_HEADER_ID
, CREATED_FROM_LIST_LINE_ID CREATED_FROM_LIST_LINE_ID
, CREATED_FROM_LIST_LINE_TYPE CREATED_FROM_LIST_LINE_TYPE
, CREATED_FROM_LIST_TYPE_CODE CREATED_FROM_LIST_TYPE_CODE
, MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE
, CREATED_FROM_SQL CREATED_FROM_SQL
, PRICING_GROUP_SEQUENCE PRICING_GROUP_SEQUENCE
, OPERAND_CALCULATION_CODE OPERAND_CALCULATION_CODE
, OPERAND_VALUE OPERAND_VALUE
, ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT
, LINE_QUANTITY LINE_QUANTITY
, SUBSTITUTION_TYPE_CODE SUBSTITUTION_TYPE_CODE
, SUBSTITUTION_VALUE_FROM SUBSTITUTION_VALUE_FROM
, SUBSTITUTION_VALUE_TO SUBSTITUTION_VALUE_TO
, ASK_FOR_FLAG ASK_FOR_FLAG
, PRICE_FORMULA_ID PRICE_FORMULA_ID
, PROCESSED_FLAG PROCESSED_FLAG
, PRICING_STATUS_CODE PRICING_STATUS_CODE
, PRICING_STATUS_TEXT PRICING_STATUS_TEXT
, PRODUCT_PRECEDENCE PRODUCT_PRECEDENCE
, INCOMPATABILITY_GRP_CODE INCOMPATABILITY_GRP_CODE
, BEST_PERCENT BEST_PERCENT
, PRICING_PHASE_ID PRICING_PHASE_ID
, APPLIED_FLAG APPLIED_FLAG
, AUTOMATIC_FLAG AUTOMATIC_FLAG
, OVERRIDE_FLAG OVERRIDE_FLAG
, PRINT_ON_INVOICE_FLAG PRINT_ON_INVOICE_FLAG
, PRIMARY_UOM_FLAG PRIMARY_UOM_FLAG
, BENEFIT_QTY BENEFIT_QTY
, BENEFIT_UOM_CODE BENEFIT_UOM_CODE
, LIST_LINE_NO LIST_LINE_NO
, ACCRUAL_FLAG ACCRUAL_FLAG
, ACCRUAL_CONVERSION_RATE ACCRUAL_CONVERSION_RATE
, ESTIM_ACCRUAL_RATE ESTIM_ACCRUAL_RATE
, RECURRING_FLAG RECURRING_FLAG
, SELECTED_VOLUME_ATTR SELECTED_VOLUME_ATTR
, ROUNDING_FACTOR ROUNDING_FACTOR
, SECONDARY_PRICELIST_IND SECONDARY_PRICELIST_IND
, GROUP_QUANTITY GROUP_QUANTITY
, GROUP_AMOUNT GROUP_AMOUNT
, PROCESS_CODE PROCESS_CODE
, UPDATED_FLAG UPDATED_FLAG
, CHARGE_TYPE_CODE CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE CHARGE_SUBTYPE_CODE
, LIMIT_CODE LIMIT_CODE
, LIMIT_TEXT LIMIT_TEXT
, HEADER_LIMIT_EXISTS HEADER_LIMIT_EXISTS
, LINE_LIMIT_EXISTS LINE_LIMIT_EXISTS
FROM "QP"."QP_DEBUG_REQ_LDETS"