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

VIEW: APPS.QP_INT_RLTD_LINES

Object Details
Object Name: QP_INT_RLTD_LINES
Object Type: VIEW
Owner: APPS
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
Yes 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_INT_RLTD_LINES;

Dependencies

[top of page]

APPS.QP_INT_RLTD_LINES references the following:

SchemaAPPS
SynonymQP_INT_RLTD_LINES_T
APPS.QP_INT_RLTD_LINES is referenced by following:

SchemaAPPS
Package BodyQP_COPY_DEBUG_PVT - show dependent code
Package BodyQP_PREQ_GRP - show dependent code
Package BodyQP_PREQ_PUB - show dependent code