[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QP_DEBUG_REQ_RLTD_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | QP |
| FND Design Data: |  QP.QP_DEBUG_REQ_RLTD_LINES
|
| Subobject Name: | |
| Status: | VALID |
This table contains information about the related lines.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| QP_DEBUG_REQ_RLTD_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 REQUEST_ID
LINE_INDEX
|
| QP_DEBUG_REQ_RLTD_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID
LINE_DETAIL_INDEX
|
| 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. |
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;
QP.QP_DEBUG_REQ_RLTD_LINES does not reference any database object
QP.QP_DEBUG_REQ_RLTD_LINES is referenced by following:
APPS
QP_DEBUG_REQ_RLTD_LINES
|
|
|
|