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_PRICE_ELEMENTS

Object Details

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

PON_BID_PRICE_ELEMENTS stores details of price element bids in an auction or RFQ. Each row includes specific information about the price element bids such as auction or RFQ header ID, bid number, price element type ID, auction currency value, bid currency value etc.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_BID_PRICE_ELEMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BID_NUMBER LINE_NUMBER PRICE_ELEMENT_TYPE_ID
PON_BID_PRICE_ELEMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUCTION_HEADER_ID LINE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
BID_NUMBER	NUMBER		Yes	Unique Bid identifier
LINE_NUMBER	NUMBER		Yes	Line number
PRICE_ELEMENT_TYPE_ID	NUMBER		Yes	Unique pricing element idenfier
AUCTION_HEADER_ID	NUMBER		Yes	Unique auction identifier
PRICING_BASIS	VARCHAR2	(30)	Yes	Pricing basis.
AUCTION_CURRENCY_VALUE	NUMBER			Value supplied by supplier converted to auctioneer's currency.
BID_CURRENCY_VALUE	NUMBER			Value supplied by supplier in the supplier's bid currency.
SEQUENCE_NUMBER	NUMBER			Number denoting sequence in which price element is added to line
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
PF_TYPE	VARCHAR2	(30)		Price factor type. Could be either buyer or supplier.
OLD_BID_CURRENCY_VALUE	NUMBER			Bid currency value from source bid.
REQUEST_ID	NUMBER			Identifier of the concurrent program that last processed the row.
PROGRAM_APPLICATION_ID	NUMBER			Identifer of the owning application for the concurrent program that last updated this row.
PROGRAM_ID	NUMBER			Identifier of the concurrent program that last updated this row.
PROGRAM_UPDATE_DATE	DATE			Date when this row was last updated by a concurrent program.
BATCH_ID	NUMBER			Batch id. Only used in spreadsheet upload case.
INTERFACE_LINE_ID	NUMBER			Interface Line ID
NEGATIVE_COST_FACTOR_FLAG	VARCHAR2	(1)

Query Text

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


SELECT BID_NUMBER
,      LINE_NUMBER
,      PRICE_ELEMENT_TYPE_ID
,      AUCTION_HEADER_ID
,      PRICING_BASIS
,      AUCTION_CURRENCY_VALUE
,      BID_CURRENCY_VALUE
,      SEQUENCE_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PF_TYPE
,      OLD_BID_CURRENCY_VALUE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      BATCH_ID
,      INTERFACE_LINE_ID
,      NEGATIVE_COST_FACTOR_FLAG
FROM PON.PON_BID_PRICE_ELEMENTS;

Dependencies

[top of page]

PON.PON_BID_PRICE_ELEMENTS does not reference any database object

PON.PON_BID_PRICE_ELEMENTS is referenced by following:

PON: PON_BID_PRICE_ELEMENTS#