FND Design Data [Home] [Help]

Table: PON_AUCTION_ITEM_PRICES_ALL

Product: PON - Sourcing
Description: Stores the negotiation item details including price.
Implementation/DBA Data: TablePON.PON_AUCTION_ITEM_PRICES_ALL
Primary Key: PON_AUCTION_ITEM_PRICES_ALL_PK
  1. ColumnAUCTION_HEADER_ID
  2. ColumnLINE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
PON_AUCTION_ITEM_PRICES_ALL FK Joins to TablePON_AUCTION_HEADERS_ALL PON_AUCTION_ITEM_PRICES_ALL.AUCTION_HEADER_ID
PON_AUCTION_ITEM_PRICES_ALL FK Joins to TablePA_EXPENDITURE_TYPES PON_AUCTION_ITEM_PRICES_ALL.PROJECT_EXPENDITURE_TYPE
PON_AUCTION_ITEM_PRICES_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS PON_AUCTION_ITEM_PRICES_ALL.PROJECT_EXP_ORGANIZATION_ID
PON_AUCTION_ITEM_PRICES_ALL FK Joins to TableMTL_CATEGORIES_B PON_AUCTION_ITEM_PRICES_ALL.CATEGORY_ID
PON_AUCTION_ITEM_PRICES_ALL FK Joins to TablePO_LINE_TYPES_B PON_AUCTION_ITEM_PRICES_ALL.LINE_TYPE_ID
PON_AUCTION_ITEM_PRICES_ALL FK Joins to TablePA_PROJECTS_ALL PON_AUCTION_ITEM_PRICES_ALL.PROJECT_ID
PON_AUCTION_ITEM_PRICES_ALL FK Joins to TablePA_TASKS PON_AUCTION_ITEM_PRICES_ALL.PROJECT_TASK_ID
TablePON_ACCEPTANCES FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_ACCEPTANCES.AUCTION_LINE_NUMBER
PON_ACCEPTANCES.AUCTION_HEADER_ID
TablePON_AUCTION_ATTRIBUTES FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_AUCTION_ATTRIBUTES.LINE_NUMBER
PON_AUCTION_ATTRIBUTES.AUCTION_HEADER_ID
TablePON_AUCTION_SUMMARY FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_AUCTION_SUMMARY.LINE_NUMBER
PON_AUCTION_SUMMARY.AUCTION_ID
TablePON_AUC_PAYMENTS_SHIPMENTS FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_AUC_PAYMENTS_SHIPMENTS.LINE_NUMBER
PON_AUC_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID
TablePON_BACKING_REQUISITIONS FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_BACKING_REQUISITIONS.LINE_NUMBER
PON_BACKING_REQUISITIONS.AUCTION_HEADER_ID
TablePON_BID_ITEM_PRICES FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_BID_ITEM_PRICES.LINE_NUMBER
PON_BID_ITEM_PRICES.AUCTION_HEADER_ID
TablePON_BID_ITEM_REFERENCES FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_BID_ITEM_REFERENCES.AUCTION_LINE_NUMBER
PON_BID_ITEM_REFERENCES.AUCTION_HEADER_ID
TablePON_BID_PAYMENTS_SHIPMENTS FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_BID_PAYMENTS_SHIPMENTS.AUCTION_LINE_NUMBER
PON_BID_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID
TablePON_BID_SHIPMENTS FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_BID_SHIPMENTS.AUCTION_LINE_NUMBER
PON_BID_SHIPMENTS.AUCTION_HEADER_ID
TablePON_PRICE_DIFFERENTIALS FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_PRICE_DIFFERENTIALS.LINE_NUMBER
PON_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID
TablePON_PRICE_ELEMENTS FK Joins to PON_AUCTION_ITEM_PRICES_ALL PON_PRICE_ELEMENTS.LINE_NUMBER
PON_PRICE_ELEMENTS.AUCTION_HEADER_ID