DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.QP_PREQ_RLTD_LINES_TMP

Object Details
Object Name: QP_PREQ_RLTD_LINES_TMP
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQP.QP_PREQ_RLTD_LINES_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 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.
Query Text

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;

Dependencies

[top of page]

APPS.QP_PREQ_RLTD_LINES_TMP references the following:

SchemaAPPS
SynonymQP_PREQ_RLTD_LINES_TMP_T
APPS.QP_PREQ_RLTD_LINES_TMP is referenced by following:

SchemaAPPS
Package BodyASO_PRICING_CORE_PVT - show dependent code
Package BodyFTE_QP_ENGINE - show dependent code
Package BodyOE_ADV_PRICE_PVT - show dependent code
Package BodyOE_BULK_PRICEORDER_PVT - show dependent code
Package BodyOE_OE_AVAILABILITY - show dependent code
Package BodyOE_OE_PRICING_AVAILABILITY - show dependent code
Package BodyOE_ORDER_PRICE_PVT - show dependent code
Package BodyOE_RETROBILL_PVT - show dependent code
PL/SQL PackageOZF_ORDER_PRICE_PVT - show dependent code
Package BodyOZF_ORDER_PRICE_PVT - show dependent code
Package BodyQP_PRICE_BOOK_PVT - show dependent code