[Home] [Help] [Dependency Information]
Object Name: | QP_QUALIFIERS_FWK_DUMMY |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_QUALIFIERS_FWK_DUMMY |
Subobject Name: | |
Status: | VALID |
This is a staging table for qualifiers created from HTML pricing flows before the pricing entity is posted to the database.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_QUALIFIERS_FWK_DUMMY_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TRANSACTION_ID
QUALIFIER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | System generated Identifier for the HTML transaction within the Create/Update Qualifier Page | |
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. | ||
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. | |
SEGMENT_ID | NUMBER | Identifier for the qualifier context and attribute. Maps to qp_segments_b.segment_id. | ||
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 TRANSACTION_ID
, 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
, ORIG_SYS_QUALIFIER_REF
, ORIG_SYS_HEADER_REF
, ORIG_SYS_LINE_REF
, SEGMENT_ID
, QUALIFY_HIER_DESCENDENTS_FLAG
FROM QP.QP_QUALIFIERS_FWK_DUMMY;
QP.QP_QUALIFIERS_FWK_DUMMY does not reference any database object
QP.QP_QUALIFIERS_FWK_DUMMY is referenced by following:
|
|
|