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: | APPS.QP_PREQ_LINE_ATTRS_TMP |
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)