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: PON.PON_BID_REBATES

Object Details

Object Name:	PON_BID_REBATES
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_BID_REBATES
Subobject Name:
Status:	VALID

PON_BID_REBATES is the table used to store Rebates for a particular bid

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_BID_REBATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BID_NUMBER

Columns

Name	Datatype	Mandatory	Comments
SEQUENCE_NUMBER	NUMBER	Yes	DB generated sequence
BID_NUMBER	NUMBER	Yes	FK to bid_number on pon_bid_headers
LOWER_SPEND	NUMBER		Lower spend level of the rebate structure
UPPER_SPEND	NUMBER		Upper spend level in the rebate structure
REBATE	NUMBER		The actual rebate percentage for this rebate tier
CREATION_DATE	DATE		Std WHO Column
CREATED_BY	NUMBER		Std WHO Column
LAST_UPDATE_DATE	DATE		Std WHO Column
LAST_UPDATED_BY	NUMBER		Std WHO Column

Query Text

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


SELECT SEQUENCE_NUMBER
,      BID_NUMBER
,      LOWER_SPEND
,      UPPER_SPEND
,      REBATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM PON.PON_BID_REBATES;

Dependencies

[top of page]

PON.PON_BID_REBATES does not reference any database object

PON.PON_BID_REBATES is referenced by following:

PON: PON_BID_REBATES#