PON_BID_PRICE_ELEMENTS
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.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PON_BID_PRICE_ELEMENTS_PK |
BID_NUMBER, LINE_NUMBER, SEQUENCE_NUMBER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BID_NUMBER | NUMBER | 18 | Yes | Unique Bid identifier | |
| LINE_NUMBER | NUMBER | Yes | Line number | ||
| PRICE_ELEMENT_TYPE_ID | NUMBER | 18 | Yes | Unique pricing element idenfier | |
| AUCTION_HEADER_ID | NUMBER | 18 | 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 | Yes | Number denoting sequence in which price element is added to line | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| 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 | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_UPDATE_DATE | DATE | Date when this row was last updated by a concurrent program. | |||
| PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the application name spawning the concurrent request. | ||
| BATCH_ID | NUMBER | 18 | Batch id. Only used in spreadsheet upload case. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| INTERFACE_LINE_ID | NUMBER | Line number corresponding to the spreadsheet line number | |||
| AUCTION_LINE_NUMBER | NUMBER | Yes | Line number of the Negotiation line. For Alternate lines, this will store the Negotiation Line number for which the alternate is created. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PON_BID_PRICE_ELEMENTS | pon_bid_item_prices | BID_NUMBER, LINE_NUMBER |
| PON_BID_PRICE_ELEMENTS | pon_auction_headers_all | AUCTION_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_BID_PRICE_ELEMENTS_N1 | Non Unique | Default | AUCTION_HEADER_ID, LINE_NUMBER |
| PON_BID_PRICE_ELEMENTS_U1 | Unique | Default | BID_NUMBER, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID |
| PON_BID_PRICE_ELEMENTS_U2 | Unique | Default | BID_NUMBER, LINE_NUMBER, SEQUENCE_NUMBER |