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: OKC.OKC_PRICE_ADJUSTMENTS

Object Details

Object Name:	OKC_PRICE_ADJUSTMENTS
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_PRICE_ADJUSTMENTS
Subobject Name:
Status:	VALID

A record of actual adjustments made to price based on price attribute values.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_PRICE_ADJUSTMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKC_PRICE_ADJUSTMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHR_ID
OKC_PRICE_ADJUSTMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column.
PAT_ID	NUMBER			Foreign key to OKC_PRICE_ADJUSTMENTS.
CHR_ID	NUMBER			ID of the contract for which price adjustments are made.
CLE_ID	NUMBER			ID of the contract line for which price adjustments are created.
BSL_ID	NUMBER			Foreign key to OKS_BILL_SUB_LINES.
BCL_ID	NUMBER			Foreign key to OKS_BILL_CONT_LINES.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
MODIFIED_FROM	NUMBER			Used for storing value of the item code , which was upgraded.
MODIFIED_TO	NUMBER			Used for storing value of the item code , which was upgraded.
MODIFIER_MECHANISM_TYPE_CODE	VARCHAR2	(90)		Modifier mechanism type code.
OPERAND	NUMBER			Operand.
ARITHMETIC_OPERATOR	VARCHAR2	(90)		Arithmetic Operator.
AUTOMATIC_FLAG	VARCHAR2	(3)		Automatic flag.
UPDATE_ALLOWED	VARCHAR2	(3)		Update allowed flag.
UPDATED_FLAG	VARCHAR2	(3)		Updated flag.
APPLIED_FLAG	VARCHAR2	(3)		Applied flag.
ON_INVOICE_FLAG	VARCHAR2	(3)		On invoice flag.
PRICING_PHASE_ID	NUMBER			Pricing phase ID.
CONTEXT	VARCHAR2	(90)		Descriptive flex-field segment
ATTRIBUTE1	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(720)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(720)		Descriptive flexfield column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
REQUEST_ID	NUMBER			Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
LIST_HEADER_ID	NUMBER			Identifier of the modifier list for this adjustment
LIST_LINE_ID	NUMBER			Identifier of the modifier list line for this adjustment
LIST_LINE_TYPE_CODE	VARCHAR2	(90)		Line type of the list line used to update the pricing line
CHANGE_REASON_CODE	VARCHAR2	(90)		User entered reason code for making a change to adjustment value
CHANGE_REASON_TEXT	VARCHAR2	(2000)		Free format text further explaining the reason for the adjustment
ESTIMATED_FLAG	VARCHAR2	(3)		Flag indicating whether the charge amount is estimated or fixed.
ADJUSTED_AMOUNT	NUMBER			Amount adjusted by this adjustment
CHARGE_TYPE_CODE	VARCHAR2	(90)		Indicates the type of charge for adjustments related to charges. This is normally used for Freight/Special Charges type.
CHARGE_SUBTYPE_CODE	VARCHAR2	(90)		Further classification of the type of charge
RANGE_BREAK_QUANTITY	NUMBER			The Quantity due to which this Range Price break modifier qualified
ACCRUAL_CONVERSION_RATE	NUMBER			Conversion rate for the accrual
PRICING_GROUP_SEQUENCE	NUMBER			Indicates the pricing bucket in which the pricing engine applied this adjustment
ACCRUAL_FLAG	VARCHAR2	(3)		Indicates whether the discount is an accrual.
LIST_LINE_NO	VARCHAR2	(240)		Line number of the Modifier list line
SOURCE_SYSTEM_CODE	VARCHAR2	(90)		Source system which has generated this adjustment
BENEFIT_QTY	NUMBER			The accrual quantity for non-monetary accruals or, for promotional goods, item quantity
BENEFIT_UOM_CODE	VARCHAR2	(3)		The accrual unit of measure for non-monetary accruals, or, for promotional goods, item unit of measure
EXPIRATION_DATE	DATE			Expiration date of Coupon issued
MODIFIER_LEVEL_CODE	VARCHAR2	(90)		The level at which the list line qualified for the transaction.
PRICE_BREAK_TYPE_CODE	VARCHAR2	(90)		Type of price break associated with this adjustment
SUBSTITUTION_ATTRIBUTE	VARCHAR2	(90)		Modifier details. The attribute in the TERMS context that the pricing engine substituted, for example, Payment Terms. Used for Term Substitution-type modifiers.
PRORATION_TYPE_CODE	VARCHAR2	(90)		Proration type
INCLUDE_ON_RETURNS_FLAG	VARCHAR2	(3)		Indicates whether the pricing engine should include the charge on a return transaction. Used for Freight/Special Charge-type modifiers.
REBATE_TRANSACTION_TYPE_CODE	VARCHAR2	(30)		Rebate Transaction type code

Query Text

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


SELECT ID
,      PAT_ID
,      CHR_ID
,      CLE_ID
,      BSL_ID
,      BCL_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      MODIFIED_FROM
,      MODIFIED_TO
,      MODIFIER_MECHANISM_TYPE_CODE
,      OPERAND
,      ARITHMETIC_OPERATOR
,      AUTOMATIC_FLAG
,      UPDATE_ALLOWED
,      UPDATED_FLAG
,      APPLIED_FLAG
,      ON_INVOICE_FLAG
,      PRICING_PHASE_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      OBJECT_VERSION_NUMBER
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      LIST_LINE_TYPE_CODE
,      CHANGE_REASON_CODE
,      CHANGE_REASON_TEXT
,      ESTIMATED_FLAG
,      ADJUSTED_AMOUNT
,      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
,      EXPIRATION_DATE
,      MODIFIER_LEVEL_CODE
,      PRICE_BREAK_TYPE_CODE
,      SUBSTITUTION_ATTRIBUTE
,      PRORATION_TYPE_CODE
,      INCLUDE_ON_RETURNS_FLAG
,      REBATE_TRANSACTION_TYPE_CODE
FROM OKC.OKC_PRICE_ADJUSTMENTS;

Dependencies

[top of page]

OKC.OKC_PRICE_ADJUSTMENTS does not reference any database object

OKC.OKC_PRICE_ADJUSTMENTS is referenced by following:

APPS: OKC_PRICE_ADJUSTMENTS