Product: | QP - Advanced Pricing |
---|---|
Description: | Based on QP_PREQ_RLTD_LINES_TMP_T. This view has the information pertaining to the current pricing engine call. |
Implementation/DBA Data: | APPS.QP_PREQ_RLTD_LINES_TMP |
SELECT QPT.REQUEST_TYPE_CODE
, QPT.LINE_INDEX
, QPT.LINE_DETAIL_INDEX
, QPT.RELATIONSHIP_TYPE_CODE
, QPT.RELATED_LINE_INDEX
, QPT.RELATED_LINE_DETAIL_INDEX
, QPT.PRICING_STATUS_CODE
, QPT.PRICING_STATUS_TEXT
, QPT.LIST_LINE_ID
, QPT.RELATED_LIST_LINE_ID
, QPT.RELATED_LIST_LINE_TYPE
, QPT.OPERAND_CALCULATION_CODE
, QPT.OPERAND
, QPT.PRICING_GROUP_SEQUENCE
, QPT.RELATIONSHIP_TYPE_DETAIL
, QPT.SETUP_VALUE_FROM
, QPT.SETUP_VALUE_TO
, QPT.QUALIFIER_VALUE
, QPT.ADJUSTMENT_AMOUNT
, QPT.SATISFIED_RANGE_VALUE
, QPT.REQUEST_ID
FROM QP_PREQ_RLTD_LINES_TMP_T QPT
WHERE REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1)