FND Design Data [Home] [Help]

Table: PON_AUCTION_SHIPMENTS_ALL

Product: PON - Sourcing
Description: Stores the negotiation shipment details
Implementation/DBA Data: TablePON.PON_AUCTION_SHIPMENTS_ALL
Primary Key: PON_AUCTION_SHIPMENTS_ALL_PK1
  1. ColumnAUCTION_HEADER_ID
  2. ColumnLINE_NUMBER
  3. ColumnSHIPMENT_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
PON_AUCTION_SHIPMENTS_ALL FK Joins to TablePON_AUCTION_HEADERS_ALL PON_AUCTION_SHIPMENTS_ALL.AUCTION_HEADER_ID
PON_AUCTION_SHIPMENTS_ALL FK Joins to TableHR_LOCATIONS_ALL PON_AUCTION_SHIPMENTS_ALL.SHIP_TO_LOCATION_ID
TablePON_BID_SHIPMENTS FK Joins to PON_AUCTION_SHIPMENTS_ALL PON_BID_SHIPMENTS.AUCTION_SHIPMENT_NUMBER
PON_BID_SHIPMENTS.AUCTION_LINE_NUMBER
PON_BID_SHIPMENTS.AUCTION_HEADER_ID
TablePON_PRICE_DIFFERENTIALS FK Joins to PON_AUCTION_SHIPMENTS_ALL PON_PRICE_DIFFERENTIALS.SHIPMENT_NUMBER
PON_PRICE_DIFFERENTIALS.LINE_NUMBER
PON_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID