Product: | QP - Advanced Pricing |
---|---|
Description: | This view is for OM to get the post-pricing adjustment/modifier details. |
Implementation/DBA Data: | APPS.QP_LDETS_V |
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
, B.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
FROM QP_PREQ_LDETS_TMP A
, QP_LIST_LINES B
WHERE A.CREATED_FROM_LIST_LINE_ID = B.LIST_LINE_ID
AND A.PRICING_STATUS_CODE = 'N'