[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_PRICE_ADJUSTMENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | ONT |
| FND Design Data: |  ONT.OE_PRICE_ADJUSTMENTS
|
| Subobject Name: | |
| Status: | VALID |
This table is used to store price adjustments that have been applied to an order or a line. The column automatic flag indicates if the adjustment was applied automatically or manually. Manual discouts are created with applied_Flag = Y.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OE_PRICE_ADJUSTMENTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PRICE_ADJUSTMENT_ID
|
| OE_PRICE_ADJUSTMENTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
HEADER_ID
|
| OE_PRICE_ADJUSTMENTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINE_ID
|
| OE_PRICE_ADJUSTMENTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LIST_HEADER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRICE_ADJUSTMENT_ID | NUMBER | Yes | System generated Primary key | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Application of concurrent program that last updated row. | ||
| PROGRAM_ID | NUMBER | Concurrent program that last updated row. | ||
| PROGRAM_UPDATE_DATE | DATE | Last date changed by concurrent program | ||
| REQUEST_ID | NUMBER | Concurrent request that last changed row | ||
| HEADER_ID | NUMBER | Yes | Order Header | |
| DISCOUNT_ID | NUMBER | No longer used | ||
| DISCOUNT_LINE_ID | NUMBER | No longer used | ||
| AUTOMATIC_FLAG | VARCHAR2 | (1) | Yes | Indicates if the discount was applied automatically |
| PERCENT | NUMBER | No longer used | ||
| LINE_ID | NUMBER | ORDER LINE_ID | ||
| CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield segment | |
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ORIG_SYS_DISCOUNT_REF | VARCHAR2 | (50) | Original system discount reference | |
| CHANGE_SEQUENCE | VARCHAR2 | (50) | Change sequence | |
| LIST_HEADER_ID | NUMBER | Header Id of the Modifier | ||
| LIST_LINE_ID | NUMBER | Line id of the Modifier | ||
| LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | Line Type of the Modifier | |
| MODIFIED_FROM | VARCHAR2 | (240) | Used for storing value of the item code, which was upgraded. | |
| MODIFIED_TO | VARCHAR2 | (240) | Used for Storing Value of the item code, to which an item was upgraded. | |
| UPDATE_ALLOWED | VARCHAR2 | (1) | Indicates if this adjustment is overridable | |
| CHANGE_REASON_CODE | VARCHAR2 | (30) | User entered reason code for making a change to the adjustment value | |
| CHANGE_REASON_TEXT | VARCHAR2 | (2000) | Free form text for the reason code | |
| MODIFIER_MECHANISM_TYPE_CODE | VARCHAR2 | (30) | Not Used | |
| UPDATED_FLAG | VARCHAR2 | (1) | Flag to indicate if the user has modied this row | |
| APPLIED_FLAG | VARCHAR2 | (1) | Tells , if the adjustment has been applied to the order line. Used for string manual discounts, which are not yet applied by the user | |
| OPERAND | NUMBER | Stores the Adjustment value, Qualified by Arithmetic_Operator | ||
| ARITHMETIC_OPERATOR | VARCHAR2 | (30) | Qualifies the value in operand, ( % , Amount or a New Price) | |
| COST_ID | NUMBER | Reference to the COST record in WSH_FREIGHT_COSTS table. | ||
| TAX_CODE | VARCHAR2 | (50) | Tax code applied on the Order Line. If the Tax Code associated with an order line is a Tax Group code then this column will store tax code included in the group. | |
| TAX_EXEMPT_FLAG | VARCHAR2 | (1) | For future use | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | For future use | |
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | For future use | |
| PARENT_ADJUSTMENT_ID | NUMBER | For future use | ||
| INVOICED_FLAG | VARCHAR2 | (1) | Flag indicating whether the charge is invoiced or not. | |
| ESTIMATED_FLAG | VARCHAR2 | (1) | Flag indicating whether the charge amount is estimated or fixed. | |
| INC_IN_SALES_PERFORMANCE | VARCHAR2 | (1) | For future use | |
| SPLIT_ACTION_CODE | VARCHAR2 | (30) | Not in use | |
| ADJUSTED_AMOUNT | NUMBER | Stores the Adjusted Amount at the adjustment level . | ||
| PRICING_PHASE_ID | NUMBER | Phase Id, in which this adjustment was created | ||
| CHARGE_TYPE_CODE | VARCHAR2 | (30) | Type code of charge | |
| CHARGE_SUBTYPE_CODE | VARCHAR2 | (30) | Charge Sub Type Code | |
| RANGE_BREAK_QUANTITY | NUMBER | Breakup of Order line quantity, used when the price break is of type range | ||
| ACCRUAL_CONVERSION_RATE | NUMBER | Conversion rate used in accruals | ||
| PRICING_GROUP_SEQUENCE | NUMBER | used in price calculation, from qp_list_lines | ||
| ACCRUAL_FLAG | VARCHAR2 | (1) | Indicates, if the adjustment is accrued | |
| LIST_LINE_NO | VARCHAR2 | (240) | List Line Number from qp_list_lines | |
| SOURCE_SYSTEM_CODE | VARCHAR2 | (30) | Source system which has generated this adjustment | |
| BENEFIT_QTY | NUMBER | Quantity accrued | ||
| BENEFIT_UOM_CODE | VARCHAR2 | (3) | UOM of BENEFIT_QTY | |
| PRINT_ON_INVOICE_FLAG | VARCHAR2 | (1) | Flag used to indicate if the adjustment is to be printed on invoice | |
| EXPIRATION_DATE | DATE | Expiration date of Coupon issued | ||
| REBATE_TRANSACTION_TYPE_CODE | VARCHAR2 | (30) | Rebate Transaction Type code from qp_list_lines | |
| REBATE_TRANSACTION_REFERENCE | VARCHAR2 | (80) | Reference for rebate Transaction | |
| REBATE_PAYMENT_SYSTEM_CODE | VARCHAR2 | (30) | Rebate Payment Code | |
| REDEEMED_DATE | DATE | Date of redeeming an accrual | ||
| REDEEMED_FLAG | VARCHAR2 | (1) | Indicates if the accraul is redeemed | |
| MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | This signifies whether the modifier list line( discount, surcharge or rebate ) is to be applied at order, line or group of lines level. | |
| PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | Indicates the type of pricebreaks - point or range. | |
| SUBSTITUTION_ATTRIBUTE | VARCHAR2 | (30) | Indicates the type of terms upgrade given . Holds the flex strucure segment name for context TERM | |
| PRORATION_TYPE_CODE | VARCHAR2 | (30) | For future use | |
| INCLUDE_ON_RETURNS_FLAG | VARCHAR2 | (1) | Indicates, if the adjustment is returnable | |
| CREDIT_OR_CHARGE_FLAG | VARCHAR2 | (1) | Indicates if the adjustment record is a credit or charge to a customer. | |
| AC_CONTEXT | VARCHAR2 | (150) | Additional Charges Descriptive Flexfield structure defining column | |
| AC_ATTRIBUTE1 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE2 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE3 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE4 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE5 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE6 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE7 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE8 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE9 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE10 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE11 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE12 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE13 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE14 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| AC_ATTRIBUTE15 | VARCHAR2 | (240) | Additional Charges Descriptive Flexfield segment | |
| LOCK_CONTROL | NUMBER | Internal use only. | ||
| OPERAND_PER_PQTY | NUMBER | Operand per pricing quantity. | ||
| ADJUSTED_AMOUNT_PER_PQTY | NUMBER | Adjusted amount per pricing quantity. | ||
| INTERCO_INVOICED_FLAG | VARCHAR2 | (1) | Inter Company invoice flag. | |
| INVOICED_AMOUNT | NUMBER | Freight charge amount interfaced to receivables. | ||
| RETROBILL_REQUEST_ID | NUMBER | Foreign key to OE_RETROBILL_REQUESTS table | ||
| TAX_RATE_ID | NUMBER | (15) | Key to uniquely identify tax rates |
Cut, paste (and edit) the following text to query this object:
SELECT PRICE_ADJUSTMENT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, HEADER_ID
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, AUTOMATIC_FLAG
, PERCENT
, LINE_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORIG_SYS_DISCOUNT_REF
, CHANGE_SEQUENCE
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATE_ALLOWED
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, MODIFIER_MECHANISM_TYPE_CODE
, UPDATED_FLAG
, APPLIED_FLAG
, OPERAND
, ARITHMETIC_OPERATOR
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, RANGE_BREAK_QUANTITY
, ACCRUAL_CONVERSION_RATE
, PRICING_GROUP_SEQUENCE
, ACCRUAL_FLAG
, LIST_LINE_NO
, SOURCE_SYSTEM_CODE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, PRINT_ON_INVOICE_FLAG
, EXPIRATION_DATE
, REBATE_TRANSACTION_TYPE_CODE
, REBATE_TRANSACTION_REFERENCE
, REBATE_PAYMENT_SYSTEM_CODE
, REDEEMED_DATE
, REDEEMED_FLAG
, MODIFIER_LEVEL_CODE
, PRICE_BREAK_TYPE_CODE
, SUBSTITUTION_ATTRIBUTE
, PRORATION_TYPE_CODE
, INCLUDE_ON_RETURNS_FLAG
, CREDIT_OR_CHARGE_FLAG
, AC_CONTEXT
, AC_ATTRIBUTE1
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, LOCK_CONTROL
, OPERAND_PER_PQTY
, ADJUSTED_AMOUNT_PER_PQTY
, INTERCO_INVOICED_FLAG
, INVOICED_AMOUNT
, RETROBILL_REQUEST_ID
, TAX_RATE_ID
FROM ONT.OE_PRICE_ADJUSTMENTS;
ONT.OE_PRICE_ADJUSTMENTS does not reference any database object
ONT.OE_PRICE_ADJUSTMENTS is referenced by following:
APPS
OE_PRICE_ADJUSTMENTS
|
|
|
|