eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: QP.QP_QUALIFIERS

Object Details

Object Name:	QP_QUALIFIERS
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_QUALIFIERS
Subobject Name:
Status:	VALID

QP_QUALIFIERS stores qualifier attribute information. Qualifiers are attributes in the Qualifier Descriptive Flexfield which allow the user to specify the rules which determine whether a price or modifier is applied to a pricing request. Qualifiers maybe grouped into predefined, re-usable Qualifier Rules, grouped by QP_QUALIFIER_RULES, or maybe associated with list headers, QP_LIST_HEADERS_B or list lines, QP_LIST_LINES (Only for Modifiers) .
The AND , OR relationship between qualifiers is defined using the QUALIFIER_GROUPING_NO, i.e. qualifiers which have an AND relationship have the same grouping number, an OR relationship is defined by assigning a different grouping number.
.
Complex or commonly used qualifier rules can be pre-defined (i.e. grouped into rules by QP_QUALIFIER_RULES) and then repeatedly copied for use on list headers and list lines (Only for Modifiers). Note: once assigned to a list header or list line, although an audit trail is kept as to which rule the qualifiers were copied from (using column CREATED_FROM_RULE_ID), any changes made to the original rule are not reflected in any rules which have been created from it.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_QUALIFIERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUALIFIER_ID
QP_QUALIFIERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_HEADER_ID LIST_LINE_ID QUALIFIER_GROUPING_NO COMPARISON_OPERATOR_CODE SEARCH_IND ACTIVE_FLAG QUALIFIER_GROUP_CNT
QP_QUALIFIERS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_SYS_HEADER_REF ORIG_SYS_QUALIFIER_REF
QP_QUALIFIERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_LINE_ID
QP_QUALIFIERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUALIFIER_RULE_ID
QP_QUALIFIERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUALIFIER_CONTEXT QUALIFIER_ATTRIBUTE QUALIFIER_ATTR_VALUE COMPARISON_OPERATOR_CODE ACTIVE_FLAG SEARCH_IND
QP_QUALIFIERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUALIFIER_CONTEXT QUALIFIER_ATTRIBUTE COMPARISON_OPERATOR_CODE ACTIVE_FLAG QUALIFIER_ATTR_VALUE QUALIFIER_ATTR_VALUE_TO SEARCH_IND QUALIFIER_DATATYPE
QP_QUALIFIERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUALIFIER_CONTEXT QUALIFIER_ATTRIBUTE COMPARISON_OPERATOR_CODE ACTIVE_FLAG QUAL_ATTR_VALUE_FROM_NUMBER QUAL_ATTR_VALUE_TO_NUMBER QUALIFIER_DATATYPE SEARCH_IND
QP_QUALIFIERS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUALIFIER_CONTEXT QUALIFIER_ATTRIBUTE LIST_HEADER_ID ACTIVE_FLAG QUALIFIER_ATTR_VALUE COMPARISON_OPERATOR_CODE
QP_QUALIFIERS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_SYS_HEADER_REF ORIG_SYS_LINE_REF LIST_HEADER_ID
QP_QUALIFIERS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_SYS_QUALIFIER_REF

Columns

Name	Datatype	Length	Mandatory	Comments
QUALIFIER_ID	NUMBER		Yes	Identifies the Qualifier. System generated identifier.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
REQUEST_ID	NUMBER			Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
QUALIFIER_GROUPING_NO	NUMBER			Used to group qualifiers together to create AND / OR relationships.
QUALIFIER_CONTEXT	VARCHAR2	(30)	Yes	Context in the Qualifier descriptive flexfield
QUALIFIER_ATTRIBUTE	VARCHAR2	(30)	Yes	The attribute in the Qualifier Descriptive Flexfield
QUALIFIER_ATTR_VALUE	VARCHAR2	(240)		The value for the QUALIFIER_ATTRIBUTE. Maybe the low value in a range if the COMPARISON_OPERATOR_CODE is BETWEEN.
COMPARISON_OPERATOR_CODE	VARCHAR2	(30)	Yes	The relational operator code used to define how the pricing engine should evaluate the qualifier attributes, based on lookup type 'COMPARISON_OPERATOR'.
EXCLUDER_FLAG	VARCHAR2	(1)	Yes	Not longer used.
QUALIFIER_RULE_ID	NUMBER			Qualifier rule identifier. Groups qualifiers to create re-usable qualifier rules.
START_DATE_ACTIVE	DATE			Date the qualifier becomes effective
END_DATE_ACTIVE	DATE			Date the qualifier becomes ineffective.
CREATED_FROM_RULE_ID	NUMBER			Qualifier rule identifier. Identifies the rule that a qualfier was copied from - used as an audit trail.
QUALIFIER_PRECEDENCE	NUMBER			The precedence number, or selectivity, of the qualifier attribute in the Qualifier Descriptive Flexfield. Used by the pricing engine for incompatibility resolution.
LIST_HEADER_ID	NUMBER			List header identifier.
LIST_LINE_ID	NUMBER			List Line Identifier.
QUALIFIER_DATATYPE	VARCHAR2	(10)		Identifies the datatype of the QUALIFIER_ATTR_VALUE and QUALIFIER_ATTR_VALUE_TO .
QUALIFIER_ATTR_VALUE_TO	VARCHAR2	(240)		The high value for the QUALIFIER_ATTRIBUTE if the COMPARISON_OPERATOR_CODE is BETWEEN.
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment
ACTIVE_FLAG	VARCHAR2	(1)		Denormalized from QP_LIST_HEADERS_B.ACTIVE_FLAG
LIST_TYPE_CODE	VARCHAR2	(30)		Denormalized from QP_LIST_LINES.LIST_TYPE_CODE
QUAL_ATTR_VALUE_FROM_NUMBER	NUMBER			Contains the value of QUALIFIER_ATTR_VALUE when QUALIFIER_DATATYPE='N' and COMPARISON_OPERATOR_CODE='BETWEEN'
QUAL_ATTR_VALUE_TO_NUMBER	NUMBER			Contains the value of QUALIFIER_ATTR_VALUE_TO when QUALIFIER_DATATYPE='N' and COMPARISON_OPERATOR_CODE='BETWEEN'
SEARCH_IND	NUMBER			stores 1 if the this is a primary qualifier . 2 if secondary qualifier
QUALIFIER_GROUP_CNT	NUMBER			Stores the count of qualifiers in the group
HEADER_QUALS_EXIST_FLAG	VARCHAR2	(1)		Stores Y if header has qualifiers, Otherwise stores N
DISTINCT_ROW_COUNT	NUMBER			Contains number of each type of qualifiers within a group - like customer qualifiers in a group
OTHERS_GROUP_CNT	NUMBER			This column holds the count for all the distinct qualifier groups other than null group within the same group, i.e. same list_header_id and list_line_id. It is used in l_get_line_index_for_quals cursor for qualifiers grouping count comparison in qp_preq_qual_tmp table to select the qualified modifiers.
SEGMENT_ID	NUMBER			Identifier for the qualifier context and attribute. Maps to qp_segments_b.segment_id.
ORIG_SYS_QUALIFIER_REF	VARCHAR2	(50)		The unique identification of the equivalent of the Qualifier table in the external system from where the data is imported.
ORIG_SYS_HEADER_REF	VARCHAR2	(50)		Unique identification of the price list in the external application from where the price list is imported.
ORIG_SYS_LINE_REF	VARCHAR2	(50)		The combination of ORIG_SYS_HEADER_REF, ORIG_SYS_LINE_REF, is the primary key of the equivalent of the price list line table of the external system from where the price data is loaded. This value is filled if the qualifier is attached in the line level.
QUALIFY_HIER_DESCENDENTS_FLAG	VARCHAR2	(1)		Indicates that the Pricelist or Modifier is available to the hierarchy of each Qualifier attached to a Pricelist or Modifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUALIFIER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      QUALIFIER_GROUPING_NO
,      QUALIFIER_CONTEXT
,      QUALIFIER_ATTRIBUTE
,      QUALIFIER_ATTR_VALUE
,      COMPARISON_OPERATOR_CODE
,      EXCLUDER_FLAG
,      QUALIFIER_RULE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATED_FROM_RULE_ID
,      QUALIFIER_PRECEDENCE
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      QUALIFIER_DATATYPE
,      QUALIFIER_ATTR_VALUE_TO
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ACTIVE_FLAG
,      LIST_TYPE_CODE
,      QUAL_ATTR_VALUE_FROM_NUMBER
,      QUAL_ATTR_VALUE_TO_NUMBER
,      SEARCH_IND
,      QUALIFIER_GROUP_CNT
,      HEADER_QUALS_EXIST_FLAG
,      DISTINCT_ROW_COUNT
,      OTHERS_GROUP_CNT
,      SEGMENT_ID
,      ORIG_SYS_QUALIFIER_REF
,      ORIG_SYS_HEADER_REF
,      ORIG_SYS_LINE_REF
,      QUALIFY_HIER_DESCENDENTS_FLAG
FROM QP.QP_QUALIFIERS;

Dependencies

[top of page]

QP.QP_QUALIFIERS does not reference any database object

QP.QP_QUALIFIERS is referenced by following:

QP: QP_QUALIFIERS#