VIEW: APPS.QP_PREQ_LINES_TMP

Source

View Text - Preformatted

SELECT QPT.REQUEST_TYPE_CODE,QPT.LINE_ID,QPT.LINE_INDEX,QPT.LINE_TYPE_CODE,QPT.PRICING_EFFECTIVE_DATE,QPT.LINE_QUANTITY,QPT.LINE_UOM_CODE,QPT.PRICED_QUANTITY,QPT.PRICED_UOM_CODE,QPT.UOM_QUANTITY,QPT.CURRENCY_CODE,QPT.UNIT_PRICE,QPT.PERCENT_PRICE,QPT.ADJUSTED_UNIT_PRICE,QPT.PARENT_PRICE,QPT.PARENT_QUANTITY,QPT.PARENT_UOM_CODE,QPT.PROCESSING_ORDER,QPT.PROCESSED_FLAG,QPT.PROCESSED_CODE,QPT.PRICE_FLAG,QPT.PRICING_STATUS_CODE,QPT.PRICING_STATUS_TEXT,QPT.START_DATE_ACTIVE_FIRST,QPT.ACTIVE_DATE_FIRST_TYPE,QPT.START_DATE_ACTIVE_SECOND,QPT.ACTIVE_DATE_SECOND_TYPE,QPT.GROUP_QUANTITY,QPT.GROUP_AMOUNT,QPT.LINE_AMOUNT,QPT.ROUNDING_FLAG,QPT.ROUNDING_FACTOR,QPT.UPDATED_ADJUSTED_UNIT_PRICE,QPT.PRICE_REQUEST_CODE,QPT.HOLD_CODE,QPT.HOLD_TEXT,QPT.PRICE_LIST_HEADER_ID,QPT.VALIDATED_FLAG,QPT.QUALIFIERS_EXIST_FLAG,QPT.PRICING_ATTRS_EXIST_FLAG,QPT.PRIMARY_QUALIFIERS_MATCH_FLAG,QPT.USAGE_PRICING_TYPE,QPT.LINE_CATEGORY,QPT.CONTRACT_START_DATE,QPT.CONTRACT_END_DATE,QPT.LINE_UNIT_PRICE,QPT.REQUEST_ID,QPT.PROCESS_STATUS,QPT.EXTENDED_PRICE,QPT.ORDER_UOM_SELLING_PRICE,QPT.CATCHWEIGHT_QTY,QPT.ACTUAL_ORDER_QUANTITY,QPT.HEADER_ID,QPT.PRICING_EVENT,QPT.CALCULATE_FLAG,QPT.SIMULATION_FLAG,QPT.GSA_CHECK_FLAG,QPT.GSA_DUP_CHECK_FLAG,QPT.MANUAL_DISCOUNT_FLAG,QPT.SOURCE_ORDER_AMOUNT_FLAG,QPT.MANUAL_ADJUSTMENTS_CALL_FLAG,QPT.GET_FREIGHT_FLAG,QPT.VIEW_CODE,QPT.CHECK_CUST_VIEW_FLAG,QPT.FULL_PRICING_CALL,QPT.USE_MULTI_CURRENCY,QPT.USER_CONVERSION_RATE,QPT.USER_CONVERSION_TYPE,QPT.FUNCTION_CURRENCY,QPT.LIST_PRICE_OVERRIDE_FLAG,QPT.CHARGE_PERIODICITY_CODE, QPT.service_duration ,QPT.service_period FROM QP_PREQ_LINES_TMP_T QPT WHERE REQUEST_ID = nvl(sys_context('qp_context','request_id'),1)

View Text - HTML Formatted

SELECT QPT.REQUEST_TYPE_CODE
, QPT.LINE_ID
, QPT.LINE_INDEX
, QPT.LINE_TYPE_CODE
, QPT.PRICING_EFFECTIVE_DATE
, QPT.LINE_QUANTITY
, QPT.LINE_UOM_CODE
, QPT.PRICED_QUANTITY
, QPT.PRICED_UOM_CODE
, QPT.UOM_QUANTITY
, QPT.CURRENCY_CODE
, QPT.UNIT_PRICE
, QPT.PERCENT_PRICE
, QPT.ADJUSTED_UNIT_PRICE
, QPT.PARENT_PRICE
, QPT.PARENT_QUANTITY
, QPT.PARENT_UOM_CODE
, QPT.PROCESSING_ORDER
, QPT.PROCESSED_FLAG
, QPT.PROCESSED_CODE
, QPT.PRICE_FLAG
, QPT.PRICING_STATUS_CODE
, QPT.PRICING_STATUS_TEXT
, QPT.START_DATE_ACTIVE_FIRST
, QPT.ACTIVE_DATE_FIRST_TYPE
, QPT.START_DATE_ACTIVE_SECOND
, QPT.ACTIVE_DATE_SECOND_TYPE
, QPT.GROUP_QUANTITY
, QPT.GROUP_AMOUNT
, QPT.LINE_AMOUNT
, QPT.ROUNDING_FLAG
, QPT.ROUNDING_FACTOR
, QPT.UPDATED_ADJUSTED_UNIT_PRICE
, QPT.PRICE_REQUEST_CODE
, QPT.HOLD_CODE
, QPT.HOLD_TEXT
, QPT.PRICE_LIST_HEADER_ID
, QPT.VALIDATED_FLAG
, QPT.QUALIFIERS_EXIST_FLAG
, QPT.PRICING_ATTRS_EXIST_FLAG
, QPT.PRIMARY_QUALIFIERS_MATCH_FLAG
, QPT.USAGE_PRICING_TYPE
, QPT.LINE_CATEGORY
, QPT.CONTRACT_START_DATE
, QPT.CONTRACT_END_DATE
, QPT.LINE_UNIT_PRICE
, QPT.REQUEST_ID
, QPT.PROCESS_STATUS
, QPT.EXTENDED_PRICE
, QPT.ORDER_UOM_SELLING_PRICE
, QPT.CATCHWEIGHT_QTY
, QPT.ACTUAL_ORDER_QUANTITY
, QPT.HEADER_ID
, QPT.PRICING_EVENT
, QPT.CALCULATE_FLAG
, QPT.SIMULATION_FLAG
, QPT.GSA_CHECK_FLAG
, QPT.GSA_DUP_CHECK_FLAG
, QPT.MANUAL_DISCOUNT_FLAG
, QPT.SOURCE_ORDER_AMOUNT_FLAG
, QPT.MANUAL_ADJUSTMENTS_CALL_FLAG
, QPT.GET_FREIGHT_FLAG
, QPT.VIEW_CODE
, QPT.CHECK_CUST_VIEW_FLAG
, QPT.FULL_PRICING_CALL
, QPT.USE_MULTI_CURRENCY
, QPT.USER_CONVERSION_RATE
, QPT.USER_CONVERSION_TYPE
, QPT.FUNCTION_CURRENCY
, QPT.LIST_PRICE_OVERRIDE_FLAG
, QPT.CHARGE_PERIODICITY_CODE
, QPT.SERVICE_DURATION
, QPT.SERVICE_PERIOD
FROM QP_PREQ_LINES_TMP_T QPT
WHERE REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1)