PON_PRICE_ELEMENTS
PON_PRICE_ELEMENTS stores details of price elements in an auction or RFQ. Each row includes specific information about the price elements such as auction or RFQ header ID, line number, list ID, pricing basis, value etc.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
PON_PRICE_ELEMENTS_PK |
AUCTION_HEADER_ID, LINE_NUMBER, SEQUENCE_NUMBER |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
AUCTION_HEADER_ID | NUMBER | 18 | Yes | Unique Sourcing Document identifier | |
LINE_NUMBER | NUMBER | Yes | Auction Line number | ||
PRICE_ELEMENT_TYPE_ID | NUMBER | 18 | Yes | Foreign key to price element | |
PRICING_BASIS | VARCHAR2 | 30 | Use lookup code PON_PRICING_BASIS. Values are:PER_UNIT, FIXED_AMOUNT, PERCENTAGE | ||
VALUE | NUMBER | Target value | |||
DISPLAY_TARGET_FLAG | VARCHAR2 | 1 | Flag to indicate whether to display target value to supplier. | ||
SEQUENCE_NUMBER | NUMBER | Yes | Number denoting sequence in which price element is added to line or list. | ||
DISP_SEQ_NUMBER | NUMBER | Display Sequence Number | |||
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 | Indicates whether this price factor is of type buyer or supplier. | ||
DISPLAY_TO_SUPPLIERS_FLAG | VARCHAR2 | 1 | Indicates whether display this price factor to suppliers. Only relevant to buyer price factors. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
PROGRAM_NAME | VARCHAR2 | 30 | Identifies the concurrent program | ||
PROGRAM_APP_NAME | VARCHAR2 | 50 | Identifies the application name spawning the concurrent request. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
PON_PRICE_ELEMENTS | pon_price_element_types_b | PRICE_ELEMENT_TYPE_ID |
PON_PRICE_ELEMENTS | pon_auction_item_prices_all | AUCTION_HEADER_ID, LINE_NUMBER |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
PON_PRICE_ELEMENTS_N1 | Non Unique | Default | AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID |
PON_PRICE_ELEMENTS_U1 | Unique | AUCTION_HEADER_ID, LINE_NUMBER, SEQUENCE_NUMBER |