FND Design Data [Home] [Help]

View: QP_PREQ_LINE_ATTRS_TMP

Product: QP - Advanced Pricing
Description: Based on QP_PREQ_LINE_ATTRS_TMP_T. This view has the information pertaining to the current pricing engine call.
Implementation/DBA Data: ViewAPPS.QP_PREQ_LINE_ATTRS_TMP
View Text

SELECT QPT.LINE_INDEX
, QPT.LINE_DETAIL_INDEX
, QPT.ATTRIBUTE_LEVEL
, QPT.ATTRIBUTE_TYPE
, QPT.LIST_HEADER_ID
, QPT.LIST_LINE_ID
, QPT.CONTEXT
, QPT.ATTRIBUTE
, QPT.VALUE_FROM
, QPT.SETUP_VALUE_FROM
, QPT.VALUE_TO
, QPT.SETUP_VALUE_TO
, QPT.GROUPING_NUMBER
, QPT.NO_QUALIFIERS_IN_GRP
, QPT.COMPARISON_OPERATOR_TYPE_CODE
, QPT.VALIDATED_FLAG
, QPT.APPLIED_FLAG
, QPT.PRICING_STATUS_CODE
, QPT.PRICING_STATUS_TEXT
, QPT.QUALIFIER_PRECEDENCE
, QPT.PRICING_ATTR_FLAG
, QPT.QUALIFIER_TYPE
, QPT.DATATYPE
, QPT.PRODUCT_UOM_CODE
, QPT.PROCESSED_CODE
, QPT.EXCLUDER_FLAG
, QPT.GROUP_QUANTITY
, QPT.GROUP_AMOUNT
, QPT.DISTINCT_QUALIFIER_FLAG
, QPT.PRICING_PHASE_ID
, QPT.INCOMPATABILITY_GRP_CODE
, QPT.LINE_DETAIL_TYPE_CODE
, QPT.MODIFIER_LEVEL_CODE
, QPT.PRIMARY_UOM_FLAG
, QPT.REQUEST_ID
FROM QP_PREQ_LINE_ATTRS_TMP_T QPT
WHERE REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1)

Columns

Name
LINE_INDEX
LINE_DETAIL_INDEX
ATTRIBUTE_LEVEL
ATTRIBUTE_TYPE
LIST_HEADER_ID
LIST_LINE_ID
CONTEXT
ATTRIBUTE
VALUE_FROM
SETUP_VALUE_FROM
VALUE_TO
SETUP_VALUE_TO
GROUPING_NUMBER
NO_QUALIFIERS_IN_GRP
COMPARISON_OPERATOR_TYPE_CODE
VALIDATED_FLAG
APPLIED_FLAG
PRICING_STATUS_CODE
PRICING_STATUS_TEXT
QUALIFIER_PRECEDENCE
PRICING_ATTR_FLAG
QUALIFIER_TYPE
DATATYPE
PRODUCT_UOM_CODE
PROCESSED_CODE
EXCLUDER_FLAG
GROUP_QUANTITY
GROUP_AMOUNT
DISTINCT_QUALIFIER_FLAG
PRICING_PHASE_ID
INCOMPATABILITY_GRP_CODE
LINE_DETAIL_TYPE_CODE
MODIFIER_LEVEL_CODE
PRIMARY_UOM_FLAG
REQUEST_ID