[Home] [Help] [Dependency Information]
Object Name: | QP_PREQ_RLTD_LINES_TMP |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QP.QP_PREQ_RLTD_LINES_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 |
---|---|---|---|---|
REQUEST_TYPE_CODE | VARCHAR2 | (30) | Identifies the transaction system making the pricing request. | |
LINE_INDEX | NUMBER | Identifier of the request line. | ||
LINE_DETAIL_INDEX | NUMBER | Identifier of the detail line. | ||
RELATIONSHIP_TYPE_CODE | VARCHAR2 | (30) | Internal Purposes. | |
RELATED_LINE_INDEX | NUMBER | Identifier of the parent request line. | ||
RELATED_LINE_DETAIL_INDEX | NUMBER | Identifier of the related request line on QP_PREQ_LDETS_TMP_T. | ||
PRICING_STATUS_CODE | VARCHAR2 | (30) | Returned pricing status. | |
PRICING_STATUS_TEXT | VARCHAR2 | (240) | Returned pricing message. | |
LIST_LINE_ID | NUMBER | Identifier of the list line used to create the pricing line. | ||
RELATED_LIST_LINE_ID | NUMBER | Identifier of the related list line. | ||
RELATED_LIST_LINE_TYPE | VARCHAR2 | (30) | Type of related list line. | |
OPERAND_CALCULATION_CODE | VARCHAR2 | (30) | Type of operand. Allowable values are:1. Adjustment percent (for discounts)2. Adjustment amount (for discounts)3. Adjustment New Price (for discounts)4. UNIT_PRICE(for price lists)5. PERCENT_PRICE(for price lists) | |
OPERAND | NUMBER | Value of pricing request detail line, for example, 10 currency unit list price with 3% discount | ||
PRICING_GROUP_SEQUENCE | NUMBER | Indicates the pricing bucket in which the pricing engine applied this list line. | ||
RELATIONSHIP_TYPE_DETAIL | VARCHAR2 | (30) | Relationship type of the detail line. | |
SETUP_VALUE_FROM | NUMBER | Setup value for product or pricing attribute. | ||
SETUP_VALUE_TO | NUMBER | Return value for Pricing attribute. Populated when the pricing engine returns details of a volume break. | ||
QUALIFIER_VALUE | NUMBER | Internal Purposes. | ||
ADJUSTMENT_AMOUNT | NUMBER | It holds the value of the bucketed adjusted amount for line types like PLL, DIS, SUR etc. For price break (PBH) child lines, the field is populated if the pricing engine derived the value of the request line or request line detail from a price break. | ||
SATISFIED_RANGE_VALUE | NUMBER | Indicates the range for Range breaks. | ||
REQUEST_ID | NUMBER | Request line identifier distinguishes between any two pricing engine calls. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_TYPE_CODE
, LINE_INDEX
, LINE_DETAIL_INDEX
, RELATIONSHIP_TYPE_CODE
, RELATED_LINE_INDEX
, RELATED_LINE_DETAIL_INDEX
, PRICING_STATUS_CODE
, PRICING_STATUS_TEXT
, LIST_LINE_ID
, RELATED_LIST_LINE_ID
, RELATED_LIST_LINE_TYPE
, OPERAND_CALCULATION_CODE
, OPERAND
, PRICING_GROUP_SEQUENCE
, RELATIONSHIP_TYPE_DETAIL
, SETUP_VALUE_FROM
, SETUP_VALUE_TO
, QUALIFIER_VALUE
, ADJUSTMENT_AMOUNT
, SATISFIED_RANGE_VALUE
, REQUEST_ID
FROM APPS.QP_PREQ_RLTD_LINES_TMP;
|
|
|