VIEW: APPS.QP_PREQ_LDETS_TMP

Source

View Text - Preformatted

SELECT QPT.LINE_DETAIL_INDEX,QPT.LINE_DETAIL_TYPE_CODE,QPT.LINE_DETAIL_PBH_TYPE,QPT.PRICE_BREAK_TYPE_CODE,QPT.LINE_INDEX,QPT.CREATED_FROM_LIST_HEADER_ID,QPT.CREATED_FROM_LIST_LINE_ID,QPT.CREATED_FROM_LIST_LINE_TYPE,QPT.CREATED_FROM_LIST_TYPE_CODE,QPT.MODIFIER_LEVEL_CODE,QPT.CREATED_FROM_SQL,QPT.PRICING_GROUP_SEQUENCE,QPT.OPERAND_CALCULATION_CODE,QPT.OPERAND_VALUE,QPT.ADJUSTMENT_AMOUNT,QPT.LINE_QUANTITY,QPT.SUBSTITUTION_TYPE_CODE,QPT.SUBSTITUTION_VALUE_FROM,QPT.SUBSTITUTION_VALUE_TO,QPT.ASK_FOR_FLAG,QPT.PRICE_FORMULA_ID,QPT.PROCESSED_FLAG,QPT.PRICING_STATUS_CODE,QPT.PRICING_STATUS_TEXT,QPT.PRODUCT_PRECEDENCE,QPT.INCOMPATABILITY_GRP_CODE,QPT.BEST_PERCENT,QPT.PRICING_PHASE_ID,QPT.APPLIED_FLAG,QPT.AUTOMATIC_FLAG,QPT.OVERRIDE_FLAG,QPT.PRINT_ON_INVOICE_FLAG,QPT.PRIMARY_UOM_FLAG,QPT.BENEFIT_QTY,QPT.BENEFIT_UOM_CODE,QPT.LIST_LINE_NO,QPT.ACCRUAL_FLAG,QPT.ACCRUAL_CONVERSION_RATE,QPT.ESTIM_ACCRUAL_RATE,QPT.RECURRING_FLAG,QPT.SELECTED_VOLUME_ATTR,QPT.ROUNDING_FACTOR,QPT.SECONDARY_PRICELIST_IND,QPT.GROUP_QUANTITY,QPT.GROUP_AMOUNT,QPT.PROCESS_CODE,QPT.UPDATED_FLAG,QPT.CHARGE_TYPE_CODE,QPT.CHARGE_SUBTYPE_CODE,QPT.LIMIT_CODE,QPT.LIMIT_TEXT,QPT.HEADER_LIMIT_EXISTS,QPT.LINE_LIMIT_EXISTS,QPT.CALCULATION_CODE,QPT.CURRENCY_HEADER_ID,QPT.PRICING_EFFECTIVE_DATE,QPT.BASE_CURRENCY_CODE,QPT.ORDER_CURRENCY,QPT.CURRENCY_DETAIL_ID,QPT.SELLING_ROUNDING_FACTOR,QPT.CHANGE_REASON_CODE,QPT.CHANGE_REASON_TEXT,QPT.REQUEST_ID,QPT.PRICE_ADJUSTMENT_ID,QPT.RECURRING_VALUE,QPT.NET_AMOUNT_FLAG,QPT.ORDER_QTY_OPERAND,QPT.ORDER_QTY_ADJ_AMT,QPT.ACCUM_CONTEXT,QPT.ACCUM_ATTRIBUTE,QPT.ACCUM_ATTR_RUN_SRC_FLAG,QPT.BREAK_UOM_CODE,QPT.BREAK_UOM_CONTEXT,QPT.BREAK_UOM_ATTRIBUTE,QPT.SERVICE_DURATION,QPT.SERVICE_PERIOD from QP_PREQ_LDETS_TMP_T QPT WHERE REQUEST_ID = nvl(SYS_CONTEXT('QP_CONTEXT','REQUEST_ID'),1)

View Text - HTML Formatted

SELECT QPT.LINE_DETAIL_INDEX
, QPT.LINE_DETAIL_TYPE_CODE
, QPT.LINE_DETAIL_PBH_TYPE
, QPT.PRICE_BREAK_TYPE_CODE
, QPT.LINE_INDEX
, QPT.CREATED_FROM_LIST_HEADER_ID
, QPT.CREATED_FROM_LIST_LINE_ID
, QPT.CREATED_FROM_LIST_LINE_TYPE
, QPT.CREATED_FROM_LIST_TYPE_CODE
, QPT.MODIFIER_LEVEL_CODE
, QPT.CREATED_FROM_SQL
, QPT.PRICING_GROUP_SEQUENCE
, QPT.OPERAND_CALCULATION_CODE
, QPT.OPERAND_VALUE
, QPT.ADJUSTMENT_AMOUNT
, QPT.LINE_QUANTITY
, QPT.SUBSTITUTION_TYPE_CODE
, QPT.SUBSTITUTION_VALUE_FROM
, QPT.SUBSTITUTION_VALUE_TO
, QPT.ASK_FOR_FLAG
, QPT.PRICE_FORMULA_ID
, QPT.PROCESSED_FLAG
, QPT.PRICING_STATUS_CODE
, QPT.PRICING_STATUS_TEXT
, QPT.PRODUCT_PRECEDENCE
, QPT.INCOMPATABILITY_GRP_CODE
, QPT.BEST_PERCENT
, QPT.PRICING_PHASE_ID
, QPT.APPLIED_FLAG
, QPT.AUTOMATIC_FLAG
, QPT.OVERRIDE_FLAG
, QPT.PRINT_ON_INVOICE_FLAG
, QPT.PRIMARY_UOM_FLAG
, QPT.BENEFIT_QTY
, QPT.BENEFIT_UOM_CODE
, QPT.LIST_LINE_NO
, QPT.ACCRUAL_FLAG
, QPT.ACCRUAL_CONVERSION_RATE
, QPT.ESTIM_ACCRUAL_RATE
, QPT.RECURRING_FLAG
, QPT.SELECTED_VOLUME_ATTR
, QPT.ROUNDING_FACTOR
, QPT.SECONDARY_PRICELIST_IND
, QPT.GROUP_QUANTITY
, QPT.GROUP_AMOUNT
, QPT.PROCESS_CODE
, QPT.UPDATED_FLAG
, QPT.CHARGE_TYPE_CODE
, QPT.CHARGE_SUBTYPE_CODE
, QPT.LIMIT_CODE
, QPT.LIMIT_TEXT
, QPT.HEADER_LIMIT_EXISTS
, QPT.LINE_LIMIT_EXISTS
, QPT.CALCULATION_CODE
, QPT.CURRENCY_HEADER_ID
, QPT.PRICING_EFFECTIVE_DATE
, QPT.BASE_CURRENCY_CODE
, QPT.ORDER_CURRENCY
, QPT.CURRENCY_DETAIL_ID
, QPT.SELLING_ROUNDING_FACTOR
, QPT.CHANGE_REASON_CODE
, QPT.CHANGE_REASON_TEXT
, QPT.REQUEST_ID
, QPT.PRICE_ADJUSTMENT_ID
, QPT.RECURRING_VALUE
, QPT.NET_AMOUNT_FLAG
, QPT.ORDER_QTY_OPERAND
, QPT.ORDER_QTY_ADJ_AMT
, QPT.ACCUM_CONTEXT
, QPT.ACCUM_ATTRIBUTE
, QPT.ACCUM_ATTR_RUN_SRC_FLAG
, QPT.BREAK_UOM_CODE
, QPT.BREAK_UOM_CONTEXT
, QPT.BREAK_UOM_ATTRIBUTE
, QPT.SERVICE_DURATION
, QPT.SERVICE_PERIOD
FROM QP_PREQ_LDETS_TMP_T QPT
WHERE REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1)