VIEW: QP.QP_INT_LINES_T#

Source

View Text - Preformatted

select 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_CATEGORY LINE_CATEGORY, CONTRACT_START_DATE CONTRACT_START_DATE, CONTRACT_END_DATE CONTRACT_END_DATE, LINE_UNIT_PRICE LINE_UNIT_PRICE, REQUEST_ID REQUEST_ID, PROCESS_STATUS PROCESS_STATUS, EXTENDED_PRICE EXTENDED_PRICE, ORDER_UOM_SELLING_PRICE ORDER_UOM_SELLING_PRICE, CATCHWEIGHT_QTY CATCHWEIGHT_QTY, ACTUAL_ORDER_QUANTITY ACTUAL_ORDER_QUANTITY, HEADER_ID HEADER_ID, PRICING_EVENT PRICING_EVENT, CALCULATE_FLAG CALCULATE_FLAG, SIMULATION_FLAG SIMULATION_FLAG, GSA_CHECK_FLAG GSA_CHECK_FLAG, GSA_DUP_CHECK_FLAG GSA_DUP_CHECK_FLAG, MANUAL_DISCOUNT_FLAG MANUAL_DISCOUNT_FLAG, SOURCE_ORDER_AMOUNT_FLAG SOURCE_ORDER_AMOUNT_FLAG, MANUAL_ADJUSTMENTS_CALL_FLAG MANUAL_ADJUSTMENTS_CALL_FLAG, GET_FREIGHT_FLAG GET_FREIGHT_FLAG, VIEW_CODE VIEW_CODE, CHECK_CUST_VIEW_FLAG CHECK_CUST_VIEW_FLAG, FULL_PRICING_CALL FULL_PRICING_CALL, USE_MULTI_CURRENCY USE_MULTI_CURRENCY, USER_CONVERSION_RATE USER_CONVERSION_RATE, USER_CONVERSION_TYPE USER_CONVERSION_TYPE, FUNCTION_CURRENCY FUNCTION_CURRENCY, LIST_PRICE_OVERRIDE_FLAG LIST_PRICE_OVERRIDE_FLAG, 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, CHARGE_PERIODICITY_CODE CHARGE_PERIODICITY_CODE from "QP"."QP_INT_LINES_T"

View Text - HTML Formatted

SELECT 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_CATEGORY LINE_CATEGORY
, CONTRACT_START_DATE CONTRACT_START_DATE
, CONTRACT_END_DATE CONTRACT_END_DATE
, LINE_UNIT_PRICE LINE_UNIT_PRICE
, REQUEST_ID REQUEST_ID
, PROCESS_STATUS PROCESS_STATUS
, EXTENDED_PRICE EXTENDED_PRICE
, ORDER_UOM_SELLING_PRICE ORDER_UOM_SELLING_PRICE
, CATCHWEIGHT_QTY CATCHWEIGHT_QTY
, ACTUAL_ORDER_QUANTITY ACTUAL_ORDER_QUANTITY
, HEADER_ID HEADER_ID
, PRICING_EVENT PRICING_EVENT
, CALCULATE_FLAG CALCULATE_FLAG
, SIMULATION_FLAG SIMULATION_FLAG
, GSA_CHECK_FLAG GSA_CHECK_FLAG
, GSA_DUP_CHECK_FLAG GSA_DUP_CHECK_FLAG
, MANUAL_DISCOUNT_FLAG MANUAL_DISCOUNT_FLAG
, SOURCE_ORDER_AMOUNT_FLAG SOURCE_ORDER_AMOUNT_FLAG
, MANUAL_ADJUSTMENTS_CALL_FLAG MANUAL_ADJUSTMENTS_CALL_FLAG
, GET_FREIGHT_FLAG GET_FREIGHT_FLAG
, VIEW_CODE VIEW_CODE
, CHECK_CUST_VIEW_FLAG CHECK_CUST_VIEW_FLAG
, FULL_PRICING_CALL FULL_PRICING_CALL
, USE_MULTI_CURRENCY USE_MULTI_CURRENCY
, USER_CONVERSION_RATE USER_CONVERSION_RATE
, USER_CONVERSION_TYPE USER_CONVERSION_TYPE
, FUNCTION_CURRENCY FUNCTION_CURRENCY
, LIST_PRICE_OVERRIDE_FLAG LIST_PRICE_OVERRIDE_FLAG
, 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
, CHARGE_PERIODICITY_CODE CHARGE_PERIODICITY_CODE
FROM "QP"."QP_INT_LINES_T"