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_PRCE_BRK

Object Details

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

This table contains price breaks for items on a pricelist. Price breaks (also known as price brackets or differences in prices) can be based on either order quantity, order line quantity, order value or order line value. Depending on the quantity or value used, the price might change. The pricing logic in Order Entry uses information in this table to calculate prices on an order or order line based on established pricelists.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OP_PRCE_BRK_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BREAKTYPE_ID
OP_PRCE_BRK_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRICE_ID LINE_NO QTY_BREAKPOINT VALUE_BREAKPOINT

Columns

Name	Datatype	Length	Mandatory	Comments
PRICE_ID	NUMBER	(10)	Yes	Price detail link. FK to op_prce_itm.
BREAKPOINT_FACTOR	NUMBER			Percent which is applied to base price for this price detail to compute the unit price for the break value or qty.
BREAKPOINT_PRICE	NUMBER			Unit price which applies for this break value/qty.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_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
BREAKTYPE_ID	NUMBER	(10)	Yes	Surrogate id which uniquely identifies this row.
LINE_NO	NUMBER	(5)	Yes	Part of primary key to distinguish between unique quantity and value breaks.
QTY_BREAKPOINT	NUMBER			Quantity break for price.
VALUE_BREAKPOINT	NUMBER			Value break for price (item qty * base price).

Query Text

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


SELECT PRICE_ID
,      BREAKPOINT_FACTOR
,      BREAKPOINT_PRICE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      TRANS_CNT
,      BREAKTYPE_ID
,      LINE_NO
,      QTY_BREAKPOINT
,      VALUE_BREAKPOINT
FROM GML.OP_PRCE_BRK;

Dependencies

[top of page]

GML.OP_PRCE_BRK does not reference any database object

GML.OP_PRCE_BRK is referenced by following:

APPS: GMLCOPPR - show dependent code; OP_PRCE_BRK