VIEW: APPS.QP_LDETS_V

Source

View Text - Preformatted

SELECT A.LINE_DETAIL_INDEX,A.LINE_DETAIL_TYPE_CODE,A.LINE_INDEX,A.CREATED_FROM_LIST_HEADER_ID,A.CREATED_FROM_LIST_LINE_ID,A.CREATED_FROM_LIST_LINE_TYPE,A.PRICE_BREAK_TYPE_CODE,A.LINE_QUANTITY,A.ADJUSTMENT_AMOUNT,A.AUTOMATIC_FLAG,A.PRICING_PHASE_ID,A.OPERAND_CALCULATION_CODE,A.OPERAND_VALUE,A.PRICING_GROUP_SEQUENCE,A.CREATED_FROM_LIST_TYPE_CODE,A.APPLIED_FLAG,A.PRICING_STATUS_CODE,A.PRICING_STATUS_TEXT,A.LIMIT_CODE,A.LIMIT_TEXT,A.LIST_LINE_NO,A.GROUP_QUANTITY,A.UPDATED_FLAG,A.PROCESS_CODE,B.SUBSTITUTION_VALUE,B.SUBSTITUTION_ATTRIBUTE,B.ACCRUAL_FLAG,A.MODIFIER_LEVEL_CODE,B.ESTIM_GL_VALUE,B.ACCRUAL_CONVERSION_RATE,B.OVERRIDE_FLAG,B.PRINT_ON_INVOICE_FLAG,B.INVENTORY_ITEM_ID,B.ORGANIZATION_ID,B.RELATED_ITEM_ID,B.RELATIONSHIP_TYPE_ID,B.ESTIM_ACCRUAL_RATE,B.EXPIRATION_DATE,B.BENEFIT_PRICE_LIST_LINE_ID,B.RECURRING_FLAG,B.BENEFIT_LIMIT,A.CHARGE_TYPE_CODE,A.CHARGE_SUBTYPE_CODE,A.BENEFIT_QTY,B.BENEFIT_UOM_CODE,B.PRORATION_TYPE_CODE,B.INCLUDE_ON_RETURNS_FLAG,B.REBATE_TRANSACTION_TYPE_CODE,B.NUMBER_EXPIRATION_PERIODS,B.EXPIRATION_PERIOD_UOM,B.COMMENTS,A.CALCULATION_CODE,A.CHANGE_REASON_CODE,A.CHANGE_REASON_TEXT,A.PRICE_ADJUSTMENT_ID,A.NET_AMOUNT_FLAG,A.ORDER_QTY_OPERAND,A.ORDER_QTY_ADJ_AMT,A.ACCUM_CONTEXT,A.ACCUM_ATTRIBUTE,A.ACCUM_ATTR_RUN_SRC_FLAG,A.BREAK_UOM_CODE,A.BREAK_UOM_CONTEXT,A.BREAK_UOM_ATTRIBUTE FROM QP_PREQ_LDETS_TMP_T A,QP_LIST_LINES B WHERE a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID AND a.PRICING_STATUS_CODE = 'N' and a.REQUEST_ID = nvl(SYS_CONTEXT('QP_CONTEXT','REQUEST_ID'),1)

View Text - HTML Formatted

SELECT A.LINE_DETAIL_INDEX
, A.LINE_DETAIL_TYPE_CODE
, A.LINE_INDEX
, A.CREATED_FROM_LIST_HEADER_ID
, A.CREATED_FROM_LIST_LINE_ID
, A.CREATED_FROM_LIST_LINE_TYPE
, A.PRICE_BREAK_TYPE_CODE
, A.LINE_QUANTITY
, A.ADJUSTMENT_AMOUNT
, A.AUTOMATIC_FLAG
, A.PRICING_PHASE_ID
, A.OPERAND_CALCULATION_CODE
, A.OPERAND_VALUE
, A.PRICING_GROUP_SEQUENCE
, A.CREATED_FROM_LIST_TYPE_CODE
, A.APPLIED_FLAG
, A.PRICING_STATUS_CODE
, A.PRICING_STATUS_TEXT
, A.LIMIT_CODE
, A.LIMIT_TEXT
, A.LIST_LINE_NO
, A.GROUP_QUANTITY
, A.UPDATED_FLAG
, A.PROCESS_CODE
, B.SUBSTITUTION_VALUE
, B.SUBSTITUTION_ATTRIBUTE
, B.ACCRUAL_FLAG
, A.MODIFIER_LEVEL_CODE
, B.ESTIM_GL_VALUE
, B.ACCRUAL_CONVERSION_RATE
, B.OVERRIDE_FLAG
, B.PRINT_ON_INVOICE_FLAG
, B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.RELATED_ITEM_ID
, B.RELATIONSHIP_TYPE_ID
, B.ESTIM_ACCRUAL_RATE
, B.EXPIRATION_DATE
, B.BENEFIT_PRICE_LIST_LINE_ID
, B.RECURRING_FLAG
, B.BENEFIT_LIMIT
, A.CHARGE_TYPE_CODE
, A.CHARGE_SUBTYPE_CODE
, A.BENEFIT_QTY
, B.BENEFIT_UOM_CODE
, B.PRORATION_TYPE_CODE
, B.INCLUDE_ON_RETURNS_FLAG
, B.REBATE_TRANSACTION_TYPE_CODE
, B.NUMBER_EXPIRATION_PERIODS
, B.EXPIRATION_PERIOD_UOM
, B.COMMENTS
, A.CALCULATION_CODE
, A.CHANGE_REASON_CODE
, A.CHANGE_REASON_TEXT
, A.PRICE_ADJUSTMENT_ID
, A.NET_AMOUNT_FLAG
, A.ORDER_QTY_OPERAND
, A.ORDER_QTY_ADJ_AMT
, A.ACCUM_CONTEXT
, A.ACCUM_ATTRIBUTE
, A.ACCUM_ATTR_RUN_SRC_FLAG
, A.BREAK_UOM_CODE
, A.BREAK_UOM_CONTEXT
, A.BREAK_UOM_ATTRIBUTE
FROM QP_PREQ_LDETS_TMP_T A
, QP_LIST_LINES B
WHERE A.CREATED_FROM_LIST_LINE_ID = B.LIST_LINE_ID
AND A.PRICING_STATUS_CODE = 'N'
AND A.REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1)