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

TABLE: QP.QP_DEBUG_REQ_RLTD_LINES

Object Details
Object Name: QP_DEBUG_REQ_RLTD_LINES
Object Type: TABLE
Owner: QP
FND Design Data: TableQP.QP_DEBUG_REQ_RLTD_LINES
Subobject Name:
Status: VALID


This table contains information about the related lines.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_DEBUG_REQ_RLTD_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnLINE_INDEX
QP_DEBUG_REQ_RLTD_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnLINE_DETAIL_INDEX
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes Request Id is the sequence number to uniquely identify the Debug Requests.
REQUEST_TYPE_CODE VARCHAR2 (30)
Identifies the transaction system making the pricing request.
LINE_INDEX NUMBER

PL/SQL unique identifier for request line.
LINE_DETAIL_INDEX NUMBER

PL/SQL unique identifier. Unique identifier of 'request line detail' in calling application.
RELATIONSHIP_TYPE_CODE VARCHAR2 (30)
Type of relationship between pricing lines. Allowable values are:BUY, GET, PBH_LINE, SERVICE_LINE, GENERATED_LINE, LINE_TO_LINE, LINE_TO_DETAIL,DETAIL_TO_DETAIL, ORDER_TO_LINE, RELATED_ITEM_PRICE.
RELATED_LINE_INDEX NUMBER

PL/SQL unique identifier for request line.
RELATED_LINE_DETAIL_INDEX NUMBER

PL/SQL unique identifier. Unique identifier of 'request line detail' in calling application.
PRICING_STATUS_CODE VARCHAR2 (30)
Return Status from the engine.
PRICING_STATUS_TEXT VARCHAR2 (240)
Returned message from Pricing Engine.
LIST_LINE_ID NUMBER

Identifies the List Line.
RELATED_LIST_LINE_ID NUMBER

Identifies the List Line.
RELATED_LIST_LINE_TYPE VARCHAR2 (30)
Line type of the list line used to update the pricing line.
OPERAND_CALCULATION_CODE VARCHAR2 (30)
Type of operand. Allowable values are: Adjustment percent (for discounts), Adjustment amount (for discounts), Adjustment NewPrice (for discounts), UNIT_PRICE (for price lists), PERCENT_PRICE (for price lists), LUMPSUM.
OPERAND NUMBER

Value of pricing request detail line, for example, 10 currency unit list price with 3% discount. This is user updateable field.
PRICING_GROUP_SEQUENCE NUMBER

Indicates the pricing bucket in which the pricing engine applied this list line. If 'MODIFIER_LEVEL' is 'ORDER' or if 'AUTOMATIC_FLAG' is set to 'N', the value in this field can't be modified.
RELATIONSHIP_TYPE_DETAIL VARCHAR2 (30)
Type of Relationship between line details.
SETUP_VALUE_FROM NUMBER

Setup value for product or pricing attribute.
SETUP_VALUE_TO NUMBER

Setup value for product or pricing attribute.
QUALIFIER_VALUE NUMBER

Qualifier Value.
ADJUSTMENT_AMOUNT NUMBER

It indicates the dollar value of the adjusted amount. It holds the value of the bucketed adjusted amount for line types like PLL, DIS, and 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

Satisfied Range Value.
Query Text

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


SELECT REQUEST_ID
,      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
FROM QP.QP_DEBUG_REQ_RLTD_LINES;

Dependencies

[top of page]

QP.QP_DEBUG_REQ_RLTD_LINES does not reference any database object

QP.QP_DEBUG_REQ_RLTD_LINES is referenced by following:

SchemaQP
ViewQP_DEBUG_REQ_RLTD_LINES#