[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QP_INTERFACE_QUALIFIERS |
|---|---|
| Object Type: | TABLE |
| Owner: | QP |
| FND Design Data: |  QP.QP_INTERFACE_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.
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. 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.
Scope: public
Product: QP
Display Name: Interface Qualifiers
Category: BUSINESS_ENTITY QP_PRICE_QUALIFIER
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| QP_INTERFACE_QUALIFIERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 REQUEST_ID
PROCESS_STATUS_FLAG
|
| QP_INTERFACE_QUALIFIERS_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORIG_SYS_HEADER_REF
ORIG_SYS_LINE_REF
|
| QP_INTERFACE_QUALIFIERS_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORIG_SYS_QUALIFIER_REF
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| QUALIFIER_ID | NUMBER | Identifies the Qualifier. System generated identifier. | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| CREATED_BY | NUMBER | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | 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) | Context in the Qualifier descriptive flexfield | |
| QUALIFIER_ATTRIBUTE | VARCHAR2 | (30) | 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) | 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) | 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 | |
| PROCESS_ID | NUMBER | Process Id for transaction | ||
| PROCESS_TYPE | VARCHAR2 | (30) | Process type of Calling Application | |
| INTERFACE_ACTION_CODE | VARCHAR2 | (30) | Update/Insert/Delete code | |
| LOCK_FLAG | VARCHAR2 | (2) | Locking indicator for transaction | |
| PROCESS_FLAG | VARCHAR2 | (2) | Process flag for transaction | |
| DELETE_FLAG | VARCHAR2 | (2) | Delete flag for transaction | |
| PROCESS_STATUS_FLAG | VARCHAR2 | (2) | Process Status Flag for transaction | |
| LIST_LINE_NO | VARCHAR2 | (30) | List Line Number | |
| QUALIFIER_ATTRIBUTE_CODE | VARCHAR2 | (50) | Qualifier attribute code | |
| QUALIFIER_ATTR_VALUE_CODE | VARCHAR2 | (50) | Qualifier attribute value | |
| QUALIFIER_ATTR_VALUE_TO_CODE | VARCHAR2 | (50) | Qualifier attribute value 'to' if the value is a range. | |
| ATTRIBUTE_STATUS | VARCHAR2 | (50) | Indicate the error in the attribute validation. | |
| 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. | |
| CREATED_FROM_RULE | VARCHAR2 | (50) | CREATED_FROM_RULE_ID if NULL is retrieved using this value. | |
| QUALIFIER_RULE | VARCHAR2 | (50) | QUALIFIER_RULE_ID if NULL is retrieved using this value. | |
| 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 |
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
, PROCESS_ID
, PROCESS_TYPE
, INTERFACE_ACTION_CODE
, LOCK_FLAG
, PROCESS_FLAG
, DELETE_FLAG
, PROCESS_STATUS_FLAG
, LIST_LINE_NO
, QUALIFIER_ATTRIBUTE_CODE
, QUALIFIER_ATTR_VALUE_CODE
, QUALIFIER_ATTR_VALUE_TO_CODE
, ATTRIBUTE_STATUS
, ORIG_SYS_QUALIFIER_REF
, ORIG_SYS_HEADER_REF
, ORIG_SYS_LINE_REF
, CREATED_FROM_RULE
, QUALIFIER_RULE
, QUALIFY_HIER_DESCENDENTS_FLAG
FROM QP.QP_INTERFACE_QUALIFIERS;
QP.QP_INTERFACE_QUALIFIERS does not reference any database object
QP.QP_INTERFACE_QUALIFIERS is referenced by following:
APPS
QP_INTERFACE_QUALIFIERS
|
|
|
|