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_FWK_DUMMY

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_QUALIFIERS_FWK_DUMMY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID QUALIFIER_ID

Columns

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

Query Text

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;

Dependencies

[top of page]

QP.QP_QUALIFIERS_FWK_DUMMY does not reference any database object

QP.QP_QUALIFIERS_FWK_DUMMY is referenced by following:

APPS: QP_QUALIFIERS_FWK_DUMMY