[Home] [Help] [Dependency Information]
Object Name: | PON_PF_SUPPLIER_FORMULA |
---|---|
Object Type: | TABLE |
Owner: | PON |
FND Design Data: | PON.PON_PF_SUPPLIER_FORMULA |
Subobject Name: | |
Status: | VALID |
This table stores aggregated price factor values for a given supplier which will be used to calculate the total price of a supplier's response.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PON_PF_SUPPLIER_FORMULA_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
AUCTION_HEADER_ID
LINE_NUMBER TRADING_PARTNER_ID VENDOR_SITE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUCTION_HEADER_ID | NUMBER | Yes | Auction number | |
LINE_NUMBER | NUMBER | Yes | Auction line number | |
TRADING_PARTNER_ID | NUMBER | Supplier's company id | ||
VENDOR_SITE_ID | NUMBER | Yes | Supplier's site id. If no site available for this supplier, use value -1 | |
UNIT_PRICE | NUMBER | Aggregated unit price value for a supplier on a given line. If no unit price value for this supplier, use value 0. | ||
FIXED_AMOUNT | NUMBER | Aggregated fixed amount value for a supplier on a given line. If no fixed amount value for this supplier, use value 0. | ||
PERCENTAGE | NUMBER | Aggregated percentage value for a supplier on a given line. If no percentage value for this supplier, use value 1.0 | ||
CREATION_DATE | DATE | Yes | Who columns | |
CREATED_BY | NUMBER | Yes | Who columns | |
LAST_UPDATE_DATE | DATE | Yes | Who columns | |
LAST_UPDATED_BY | NUMBER | Yes | Who columns | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Who columns | |
REQUESTED_SUPPLIER_ID | NUMBER | Registered Supplier Id |
Cut, paste (and edit) the following text to query this object:
SELECT AUCTION_HEADER_ID
, LINE_NUMBER
, TRADING_PARTNER_ID
, VENDOR_SITE_ID
, UNIT_PRICE
, FIXED_AMOUNT
, PERCENTAGE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUESTED_SUPPLIER_ID
FROM PON.PON_PF_SUPPLIER_FORMULA;
PON.PON_PF_SUPPLIER_FORMULA does not reference any database object
PON.PON_PF_SUPPLIER_FORMULA is referenced by following:
|
|
|