VIEW: APPS.QP_PREQ_QUAL_TMP

Source

View Text - Preformatted

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,QPT.DERIVED_QUALIFIER_FLAG FROM QP_PREQ_QUAL_TMP_T QPT WHERE REQUEST_ID = nvl(sys_context('qp_context','request_id'),1)

View Text - HTML Formatted

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
, QPT.DERIVED_QUALIFIER_FLAG
FROM QP_PREQ_QUAL_TMP_T QPT
WHERE REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, 1)