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]

VIEW: APPS.QP_PREQ_QUAL_TMP

Object Details

Object Name:	QP_PREQ_QUAL_TMP
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QP.QP_PREQ_QUAL_TMP
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
LIST_HEADER_ID	NUMBER		Identifier of the list header used to create or update the pricing line.
LIST_LINE_ID	NUMBER		Identifier of the list line used to create or update the pricing line.
LINE_INDEX	NUMBER		Identifier for request line or request line detail.
QUALIFIER_ATTRIBUTE_LEVEL	VARCHAR2	(30)	Level of the attribute - 'ORDER', 'LINE'.
QUALIFIER_ATTRIBUTE_TYPE	VARCHAR2	(30)	Type of the attribute, e.g. PRODUCT, PRICING and QUALIFIER.
QUALIFIER_ATTRIBUTE_CONTEXT	VARCHAR2	(30)	Context for qualifier, for example, Customer Hierarchy.
QUALIFIER_ATTRIBUTE	VARCHAR2	(30)	Qualifier attribute, for example, QUALIFIER_ATTRIBUTE1: Customer Class.
QUALIFIER_ATTRIBUTE_VALUE	VARCHAR2	(240)	Value for qualifier attribute.
QUALIFIER_GROUPING_NO	NUMBER		Indicates the grouping number of the qualifier from QP_QUALIFIERS.QUALIFIER_GROUPING_NO
QUALIFIER_PRECEDENCE	NUMBER		Precedence or selectivity for qualifier. Used to resolve incompatibilities.
QUALIFIER_DATATYPE	VARCHAR2	(10)	Data type of the qualifier - NUMBER, VARCHAR or DATE.
QUALIFIER_PRICING_ATTR_FLAG	VARCHAR2	(30)	Internal Purposes.
QUALIFIER_OPERATOR_TYPE	VARCHAR2	(30)	Operator code of the qualifier - 'BETWEEN', 'NOT =' or '='.
SETUP_VALUE_FROM	VARCHAR2	(240)	Setup From value.
SETUP_VALUE_TO	VARCHAR2	(240)	Setup To value.
ASK_FOR_FLAG	VARCHAR2	(1)	Indicates whether the user must ask for the "List", e.g. quote a promotion number, to get the benefits on the list. The pricing engine ignores any lists where 'Ask For = Y' if they have not been quoted on the pricing request.
CREATED_FROM_LIST_TYPE	VARCHAR2	(30)	List Type Code of the price list or modifier list.
VALIDATED_FLAG	VARCHAR2	(1)	Indicates that a price list or modifier list(asked for promotion) is valid for the pricing request. Applicable to price list and modifier list qualifiers; the pricing engine assumes that other qualifiers are valid.
APPLIED_FLAG	VARCHAR2	(1)	The lists or list lines that this pricing event or a prior pricing event applied. Allowable values are1. Yes: Applicable when the attribute context is a list or list line2. No: Applicable when the attribute context is a list or list line3. Null
QUALIFIER_TYPE	VARCHAR2	(20)	Type of the qualifier - header level ('HQ') or line level ('LQ').
QUALIFIER_GROUP_CNT	NUMBER		Total attributes count for each grouping number.
HEADER_QUALS_EXIST_FLAG	VARCHAR2	(1)	Indicates whether there is qualifier on the header level.
SEARCH_IND	NUMBER		Used in modifier search. Qualifier with the least distinct attributes count in a group assigned 1 and the rest are assigned 2.
PRICING_STATUS_CODE	VARCHAR2	(30)	Returned pricing status.
START_DATE_ACTIVE	DATE		The date of qualifier becomes active.
END_DATE_ACTIVE	DATE		The date of qualifier becomes inactive.
LINE_TYPE_CODE	VARCHAR2	(30)	Order Date Start
START_DATE_ACTIVE_FIRST	DATE		Order Date Start
START_DATE_ACTIVE_SECOND	DATE		Ship Date Start
PRICING_EFFECTIVE_DATE	DATE		Pricing Date.
UNIQUE_KEY	VARCHAR2	(2000)	Composed of line index, header ID, line ID and qualifier grouping number for unique identifier.
PRICING_PHASE_ID	NUMBER		Pricing Phase identifier.
START_DATE_ACTIVE_H	DATE		List Header Start Date Active
END_DATE_ACTIVE_H	DATE		List Header End Date Active
END_DATE_ACTIVE_FIRST	DATE		Order Date End
END_DATE_ACTIVE_SECOND	DATE		Ship Date End
ACTIVE_DATE_FIRST_TYPE	VARCHAR2	(30)	ORDER
ACTIVE_DATE_SECOND_TYPE	VARCHAR2	(30)	SHIP
HEADER_LIMIT_EXISTS	VARCHAR2	(1)	Indicates whether there is limit header.
REQUEST_ID	NUMBER		Request line identifier distinguishes between any two pricing engine calls.
NULL_GROUP_CNT	NUMBER		Internal Purposes.
OTHER_GROUP_CNT	NUMBER		Internal Purposes.
OTHERS_GROUP_CNT	NUMBER		Internal Purposes.
DERIVED_QUALIFIER_FLAG	VARCHAR2	(1)	Indicates that the qualifier is derived.

Query Text

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


SELECT LIST_HEADER_ID
,      LIST_LINE_ID
,      LINE_INDEX
,      QUALIFIER_ATTRIBUTE_LEVEL
,      QUALIFIER_ATTRIBUTE_TYPE
,      QUALIFIER_ATTRIBUTE_CONTEXT
,      QUALIFIER_ATTRIBUTE
,      QUALIFIER_ATTRIBUTE_VALUE
,      QUALIFIER_GROUPING_NO
,      QUALIFIER_PRECEDENCE
,      QUALIFIER_DATATYPE
,      QUALIFIER_PRICING_ATTR_FLAG
,      QUALIFIER_OPERATOR_TYPE
,      SETUP_VALUE_FROM
,      SETUP_VALUE_TO
,      ASK_FOR_FLAG
,      CREATED_FROM_LIST_TYPE
,      VALIDATED_FLAG
,      APPLIED_FLAG
,      QUALIFIER_TYPE
,      QUALIFIER_GROUP_CNT
,      HEADER_QUALS_EXIST_FLAG
,      SEARCH_IND
,      PRICING_STATUS_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      LINE_TYPE_CODE
,      START_DATE_ACTIVE_FIRST
,      START_DATE_ACTIVE_SECOND
,      PRICING_EFFECTIVE_DATE
,      UNIQUE_KEY
,      PRICING_PHASE_ID
,      START_DATE_ACTIVE_H
,      END_DATE_ACTIVE_H
,      END_DATE_ACTIVE_FIRST
,      END_DATE_ACTIVE_SECOND
,      ACTIVE_DATE_FIRST_TYPE
,      ACTIVE_DATE_SECOND_TYPE
,      HEADER_LIMIT_EXISTS
,      REQUEST_ID
,      NULL_GROUP_CNT
,      OTHER_GROUP_CNT
,      OTHERS_GROUP_CNT
,      DERIVED_QUALIFIER_FLAG
FROM APPS.QP_PREQ_QUAL_TMP;

Dependencies

[top of page]

APPS.QP_PREQ_QUAL_TMP references the following:

APPS: QP_PREQ_QUAL_TMP_T

APPS.QP_PREQ_QUAL_TMP is referenced by following:

APPS: QP_PREQ_GRP - show dependent code