FND Design Data [Home] [Help]

View: QP_PREQ_RLTD_LINES_TMP

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: ViewAPPS.QP_PREQ_RLTD_LINES_TMP
View Text

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)

Columns

Name
REQUEST_TYPE_CODE
LINE_INDEX
LINE_DETAIL_INDEX
RELATIONSHIP_TYPE_CODE
RELATED_LINE_INDEX
RELATED_LINE_DETAIL_INDEX
PRICING_STATUS_CODE
PRICING_STATUS_TEXT
LIST_LINE_ID
RELATED_LIST_LINE_ID
RELATED_LIST_LINE_TYPE
OPERAND_CALCULATION_CODE
OPERAND
PRICING_GROUP_SEQUENCE
RELATIONSHIP_TYPE_DETAIL
SETUP_VALUE_FROM
SETUP_VALUE_TO
QUALIFIER_VALUE
ADJUSTMENT_AMOUNT
SATISFIED_RANGE_VALUE
REQUEST_ID