Product: | QP - Advanced Pricing |
---|---|
Description: | Based on QP_PREQ_QUAL_TMP_T. This view has the information pertaining to the current pricing engine call. |
Implementation/DBA Data: | APPS.QP_PREQ_QUAL_TMP |
SELECT QPT.LIST_HEADER_ID
, QPT.LIST_LINE_ID
, QPT.LINE_INDEX
, QPT.QUALIFIER_ATTRIBUTE_LEVEL
, QPT.QUALIFIER_ATTRIBUTE_TYPE
, QPT.QUALIFIER_ATTRIBUTE_CONTEXT
, QPT.QUALIFIER_ATTRIBUTE
, QPT.QUALIFIER_ATTRIBUTE_VALUE
, QPT.QUALIFIER_GROUPING_NO
, QPT.QUALIFIER_PRECEDENCE
, QPT.QUALIFIER_DATATYPE
, QPT.QUALIFIER_PRICING_ATTR_FLAG
, QPT.QUALIFIER_OPERATOR_TYPE
, QPT.SETUP_VALUE_FROM
, QPT.SETUP_VALUE_TO
, QPT.ASK_FOR_FLAG
, QPT.CREATED_FROM_LIST_TYPE
, QPT.VALIDATED_FLAG
, QPT.APPLIED_FLAG
, QPT.QUALIFIER_TYPE
, QPT.QUALIFIER_GROUP_CNT
, QPT.HEADER_QUALS_EXIST_FLAG
, QPT.SEARCH_IND
, QPT.PRICING_STATUS_CODE
, QPT.START_DATE_ACTIVE
, QPT.END_DATE_ACTIVE
, QPT.LINE_TYPE_CODE
, QPT.START_DATE_ACTIVE_FIRST
, QPT.START_DATE_ACTIVE_SECOND
, QPT.PRICING_EFFECTIVE_DATE
, QPT.UNIQUE_KEY
, QPT.PRICING_PHASE_ID
, QPT.START_DATE_ACTIVE_H
, QPT.END_DATE_ACTIVE_H
, QPT.END_DATE_ACTIVE_FIRST
, QPT.END_DATE_ACTIVE_SECOND
, QPT.ACTIVE_DATE_FIRST_TYPE
, QPT.ACTIVE_DATE_SECOND_TYPE
, QPT.HEADER_LIMIT_EXISTS
, QPT.REQUEST_ID
, QPT.NULL_GROUP_CNT
, QPT.OTHER_GROUP_CNT
, QPT.OTHERS_GROUP_CNT
FROM QP_PREQ_QUAL_TMP_T QPT
WHERE REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1)