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: GML.OP_CHRG_BRK

Object Details

Object Name:	OP_CHRG_BRK
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.OP_CHRG_BRK
Subobject Name:
Status:	VALID

This table contains charge breaks. Charge breaks (differences in charges) can be based on either order quantity, order line quantity, order value or order line value. Depending on the quantity or value used, the charge might change. The pricing logic in Order Entry uses information in this table to calculate charges on an order or order line.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_CHRG_BRKI1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHARGE_ID LINE_NO
OP_CHRG_BRK_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHRGBREAK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHRGBREAK_ID	NUMBER	(10)	Yes	Surrogate id to uniquely identify each row.
CHARGE_ID	NUMBER	(10)	Yes	Reference to charge for which these breaks apply. FK to op_chrg_mst.
QTY_BREAKPOINT	NUMBER			Quantity break for this charge.
VALUE_BREAKPOINT	NUMBER			Value break for this charge. Value is taken as either the entire order value, if the charge is calculated for an entire order or as the value of the line, if the charge is calculated for a line item.
BREAKPOINT_FACTOR	NUMBER			Percent (stored as decimal between 0 and 1) which is added or subtracted from the base amount or base per unit price of the charge to arrive at the actual charge. Depending on the type of charge, this field may also store a charge which i
BREAKPOINT_PRICE	NUMBER			Unit price entered for this break. This is the price per unit of either the entire order or the order line that will be added as an additional charge. If charge is defined as a "discount" then the charge is displayed as positive, but sto
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TRANS_CNT	NUMBER	(10)		Not currently used
LINE_NO	NUMBER	(5)	Yes	Part of primary key to uniquely identify a breakpoint for a charge

Query Text

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


SELECT CHRGBREAK_ID
,      CHARGE_ID
,      QTY_BREAKPOINT
,      VALUE_BREAKPOINT
,      BREAKPOINT_FACTOR
,      BREAKPOINT_PRICE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      TRANS_CNT
,      LINE_NO
FROM GML.OP_CHRG_BRK;

Dependencies

[top of page]

GML.OP_CHRG_BRK does not reference any database object

GML.OP_CHRG_BRK is referenced by following:

APPS: OP_CHRG_BRK