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

TABLE: QP.QP_ARCH_QUALIFIERS

Object Details
Object Name: QP_ARCH_QUALIFIERS
Object Type: TABLE
Owner: QP
FND Design Data: TableQP.QP_ARCH_QUALIFIERS
Subobject Name:
Status: VALID


This table stores the archived Qualifiers.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
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.
QUALIFIER_ATTR_VALUE_TO VARCHAR2 (240)
The high value for the QUALIFIER_ATTRIBUTE if the COMPARISON_OPERATOR_CODE is BETWEEN.
QUALIFIER_DATATYPE VARCHAR2 (10)
Identifies the datatype of the QUALIFIER_ATTR_VALUE and QUALIFIER_ATTR_VALUE_TO .
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.
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.
START_DATE_ACTIVE DATE

Date the qualifier becomes effective
END_DATE_ACTIVE DATE

Date the qualifier becomes ineffective.
LIST_HEADER_ID NUMBER

List header identifier.
LIST_LINE_ID NUMBER

List Line Identifier.
QUALIFIER_RULE_ID NUMBER

Qualifier rule identifier. Groups qualifiers to create re-usable qualifier rules.
CREATED_FROM_RULE_ID NUMBER

Qualifier rule identifier. Identifies the rule that a qualfier was copied from - used as an audit trail.
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
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
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.
ARCH_PURG_REQUEST_ID NUMBER
Yes Stores the request ID
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
,      QUALIFIER_ATTR_VALUE_TO
,      QUALIFIER_DATATYPE
,      QUALIFIER_PRECEDENCE
,      COMPARISON_OPERATOR_CODE
,      EXCLUDER_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      QUALIFIER_RULE_ID
,      CREATED_FROM_RULE_ID
,      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
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      OTHERS_GROUP_CNT
,      SEGMENT_ID
,      ARCH_PURG_REQUEST_ID
FROM QP.QP_ARCH_QUALIFIERS;

Dependencies

[top of page]

QP.QP_ARCH_QUALIFIERS does not reference any database object

QP.QP_ARCH_QUALIFIERS is referenced by following:

SchemaQP
ViewQP_ARCH_QUALIFIERS#