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: OKS.OKS_QUALIFIERS

Object Details

Object Name:	OKS_QUALIFIERS
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_QUALIFIERS
Subobject Name:
Status:	VALID

This table stores pricing qualifier information for service authoring. This information is passed to Oracle Pricing to calculate the appropriate discounts or surcharges. This table is populated through Pricing Qualifier UI, which is accessible from lines of Oracle Service Contracts Authoring UI.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKS_QUALIFIERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUALIFIER_ID
OKS_QUALIFIERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
QUALIFIER_ID	NUMBER		Yes	Internal Unique Identifier.
REQUEST_ID	NUMBER			Unique Identifier of a concurrent request.
PROGRAM_APPLICATION_ID	NUMBER			With PROGRAM_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_ID	NUMBER			With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_UPDATE_DATE	DATE			Date the concurrent program updated the record.
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	(3)	Yes	No longer used deprecated
QUALIFIER_RULE_ID	NUMBER			Qualifier Rule Identifier
START_DATE_ACTIVE	DATE			Date the qualifier becomes effective
END_DATE_ACTIVE	DATE			Date the qualifier becomes ineffective
CREATED_FROM_RULE_ID	NUMBER			Created From Rule Identifier
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			This column stores the header id of contract qualifier created for.
LIST_LINE_ID	NUMBER			This column stores the line id of contract qualifier created for.
QUALIFIER_DATATYPE	VARCHAR2	(10)		Identifies the data type 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.
CREATED_BY	NUMBER	(15)	Yes	ID of the user whom created the record.
CREATION_DATE	DATE		Yes	Date the record was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	ID of the last user who updated the record.
LAST_UPDATE_LOGIN	NUMBER	(15)		OS ID of the user who last updated the record.
LAST_UPDATE_DATE	DATE		Yes	Date the record was last updated.
CONTEXT	VARCHAR2	(30)		Context
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield
ACTIVE_FLAG	VARCHAR2	(3)		Active Flag
LIST_TYPE_CODE	VARCHAR2	(30)		List Type Code
QUAL_ATTR_VALUE_FROM_NUMBER	NUMBER			Not used deprecated
QUAL_ATTR_VALUE_TO_NUMBER	NUMBER			Not used deprecated
SECURITY_GROUP_ID	NUMBER			Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.

Query Text

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


SELECT QUALIFIER_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      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
,      SECURITY_GROUP_ID
FROM OKS.OKS_QUALIFIERS;

Dependencies

[top of page]

OKS.OKS_QUALIFIERS does not reference any database object

OKS.OKS_QUALIFIERS is referenced by following:

OKS: OKS_QUALIFIERS#