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: OZF.OZF_VOLUME_OFFER_TIERS

Object Details

Object Name:	OZF_VOLUME_OFFER_TIERS
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_VOLUME_OFFER_TIERS
Subobject Name:
Status:	VALID

Stores tier info of volume offer

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_VOLUME_OFFER_TIERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VOLUME_OFFER_TIERS_ID
OZF_VOLUME_OFFER_TIERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QP_LIST_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
VOLUME_OFFER_TIERS_ID	NUMBER		Yes	Unique identifier of volume offer
QP_LIST_HEADER_ID	NUMBER		Yes	Identifier of the offer list header
DISCOUNT_TYPE_CODE	VARCHAR2	(30)	Yes	Discount type code
DISCOUNT	NUMBER		Yes	Tier discount
BREAK_TYPE_CODE	VARCHAR2	(30)	Yes	Break type of the tier
TIER_VALUE_FROM	NUMBER		Yes	Start value of the tier
TIER_VALUE_TO	NUMBER		Yes	End value of the tier
VOLUME_TYPE	VARCHAR2	(30)	Yes	Volume type
ACTIVE	VARCHAR2	(1)		Active flag
UOM_CODE	VARCHAR2	(3)		UOM code
OBJECT_VERSION_NUMBER	NUMBER		Yes	Standard WHO column

Query Text

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


SELECT VOLUME_OFFER_TIERS_ID
,      QP_LIST_HEADER_ID
,      DISCOUNT_TYPE_CODE
,      DISCOUNT
,      BREAK_TYPE_CODE
,      TIER_VALUE_FROM
,      TIER_VALUE_TO
,      VOLUME_TYPE
,      ACTIVE
,      UOM_CODE
,      OBJECT_VERSION_NUMBER
FROM OZF.OZF_VOLUME_OFFER_TIERS;

Dependencies

[top of page]

OZF.OZF_VOLUME_OFFER_TIERS does not reference any database object

OZF.OZF_VOLUME_OFFER_TIERS is referenced by following:

APPS: OZF_VOLUME_OFFER_TIERS