eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ONT.OE_PRICE_ADJUSTMENTS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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
INST_ID	NUMBER			used in RAC INSTANCE AFFINITY for context setting

Query Text

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
,      INST_ID
FROM ONT.OE_PRICE_ADJUSTMENTS;

Dependencies

[top of page]

ONT.OE_PRICE_ADJUSTMENTS does not reference any database object

ONT.OE_PRICE_ADJUSTMENTS is referenced by following:

ONT: OE_PRICE_ADJUSTMENTS#