VIEW: QP.QP_INT_LDETS_T#

Source

View Text - Preformatted

select LINE_DETAIL_INDEX LINE_DETAIL_INDEX, LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE, LINE_DETAIL_PBH_TYPE LINE_DETAIL_PBH_TYPE, 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, CALCULATION_CODE CALCULATION_CODE, CURRENCY_HEADER_ID CURRENCY_HEADER_ID, PRICING_EFFECTIVE_DATE PRICING_EFFECTIVE_DATE, BASE_CURRENCY_CODE BASE_CURRENCY_CODE, ORDER_CURRENCY ORDER_CURRENCY, CURRENCY_DETAIL_ID CURRENCY_DETAIL_ID, SELLING_ROUNDING_FACTOR SELLING_ROUNDING_FACTOR, CHANGE_REASON_CODE CHANGE_REASON_CODE, CHANGE_REASON_TEXT CHANGE_REASON_TEXT, PRICE_ADJUSTMENT_ID PRICE_ADJUSTMENT_ID, REQUEST_ID REQUEST_ID, RECURRING_VALUE RECURRING_VALUE, NET_AMOUNT_FLAG NET_AMOUNT_FLAG, ORDER_QTY_OPERAND ORDER_QTY_OPERAND, ORDER_QTY_ADJ_AMT ORDER_QTY_ADJ_AMT, ACCUM_CONTEXT ACCUM_CONTEXT, ACCUM_ATTRIBUTE ACCUM_ATTRIBUTE, ACCUM_ATTR_RUN_SRC_FLAG ACCUM_ATTR_RUN_SRC_FLAG, BREAK_UOM_CODE BREAK_UOM_CODE, BREAK_UOM_CONTEXT BREAK_UOM_CONTEXT, BREAK_UOM_ATTRIBUTE BREAK_UOM_ATTRIBUTE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SERVICE_DURATION SERVICE_DURATION, SERVICE_PERIOD SERVICE_PERIOD from "QP"."QP_INT_LDETS_T"

View Text - HTML Formatted

SELECT LINE_DETAIL_INDEX LINE_DETAIL_INDEX
, LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE
, LINE_DETAIL_PBH_TYPE LINE_DETAIL_PBH_TYPE
, 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
, CALCULATION_CODE CALCULATION_CODE
, CURRENCY_HEADER_ID CURRENCY_HEADER_ID
, PRICING_EFFECTIVE_DATE PRICING_EFFECTIVE_DATE
, BASE_CURRENCY_CODE BASE_CURRENCY_CODE
, ORDER_CURRENCY ORDER_CURRENCY
, CURRENCY_DETAIL_ID CURRENCY_DETAIL_ID
, SELLING_ROUNDING_FACTOR SELLING_ROUNDING_FACTOR
, CHANGE_REASON_CODE CHANGE_REASON_CODE
, CHANGE_REASON_TEXT CHANGE_REASON_TEXT
, PRICE_ADJUSTMENT_ID PRICE_ADJUSTMENT_ID
, REQUEST_ID REQUEST_ID
, RECURRING_VALUE RECURRING_VALUE
, NET_AMOUNT_FLAG NET_AMOUNT_FLAG
, ORDER_QTY_OPERAND ORDER_QTY_OPERAND
, ORDER_QTY_ADJ_AMT ORDER_QTY_ADJ_AMT
, ACCUM_CONTEXT ACCUM_CONTEXT
, ACCUM_ATTRIBUTE ACCUM_ATTRIBUTE
, ACCUM_ATTR_RUN_SRC_FLAG ACCUM_ATTR_RUN_SRC_FLAG
, BREAK_UOM_CODE BREAK_UOM_CODE
, BREAK_UOM_CONTEXT BREAK_UOM_CONTEXT
, BREAK_UOM_ATTRIBUTE BREAK_UOM_ATTRIBUTE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SERVICE_DURATION SERVICE_DURATION
, SERVICE_PERIOD SERVICE_PERIOD
FROM "QP"."QP_INT_LDETS_T"