[Home] [Help] [Dependency Information]
Object Name: | QP_PREQ_QUAL_TMP |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QP.QP_PREQ_QUAL_TMP |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | 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. |
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;
|
|
|