eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PON_AUCTION_ITEM_PRICES_ALL

Product:	PON - Sourcing
Description:	Stores the negotiation item details including price.
Implementation/DBA Data:	PON.PON_AUCTION_ITEM_PRICES_ALL

Primary Key: PON_AUCTION_ITEM_PRICES_ALL_PK

AUCTION_HEADER_ID
LINE_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
PON_AUCTION_ITEM_PRICES_ALL	PON_AUCTION_HEADERS_ALL	PON_AUCTION_ITEM_PRICES_ALL.AUCTION_HEADER_ID
PON_AUCTION_ITEM_PRICES_ALL	PA_EXPENDITURE_TYPES	PON_AUCTION_ITEM_PRICES_ALL.PROJECT_EXPENDITURE_TYPE
PON_AUCTION_ITEM_PRICES_ALL	HR_ALL_ORGANIZATION_UNITS	PON_AUCTION_ITEM_PRICES_ALL.PROJECT_EXP_ORGANIZATION_ID
PON_AUCTION_ITEM_PRICES_ALL	MTL_CATEGORIES_B	PON_AUCTION_ITEM_PRICES_ALL.CATEGORY_ID
PON_AUCTION_ITEM_PRICES_ALL	PO_LINE_TYPES_B	PON_AUCTION_ITEM_PRICES_ALL.LINE_TYPE_ID
PON_AUCTION_ITEM_PRICES_ALL	PA_PROJECTS_ALL	PON_AUCTION_ITEM_PRICES_ALL.PROJECT_ID
PON_AUCTION_ITEM_PRICES_ALL	PA_TASKS	PON_AUCTION_ITEM_PRICES_ALL.PROJECT_TASK_ID
PON_ACCEPTANCES	PON_AUCTION_ITEM_PRICES_ALL	PON_ACCEPTANCES.AUCTION_LINE_NUMBER PON_ACCEPTANCES.AUCTION_HEADER_ID
PON_AUCTION_ATTRIBUTES	PON_AUCTION_ITEM_PRICES_ALL	PON_AUCTION_ATTRIBUTES.LINE_NUMBER PON_AUCTION_ATTRIBUTES.AUCTION_HEADER_ID
PON_AUCTION_SUMMARY	PON_AUCTION_ITEM_PRICES_ALL	PON_AUCTION_SUMMARY.LINE_NUMBER PON_AUCTION_SUMMARY.AUCTION_ID
PON_AUC_PAYMENTS_SHIPMENTS	PON_AUCTION_ITEM_PRICES_ALL	PON_AUC_PAYMENTS_SHIPMENTS.LINE_NUMBER PON_AUC_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID
PON_BACKING_REQUISITIONS	PON_AUCTION_ITEM_PRICES_ALL	PON_BACKING_REQUISITIONS.LINE_NUMBER PON_BACKING_REQUISITIONS.AUCTION_HEADER_ID
PON_BID_ITEM_PRICES	PON_AUCTION_ITEM_PRICES_ALL	PON_BID_ITEM_PRICES.LINE_NUMBER PON_BID_ITEM_PRICES.AUCTION_HEADER_ID
PON_BID_ITEM_REFERENCES	PON_AUCTION_ITEM_PRICES_ALL	PON_BID_ITEM_REFERENCES.AUCTION_LINE_NUMBER PON_BID_ITEM_REFERENCES.AUCTION_HEADER_ID
PON_BID_PAYMENTS_SHIPMENTS	PON_AUCTION_ITEM_PRICES_ALL	PON_BID_PAYMENTS_SHIPMENTS.AUCTION_LINE_NUMBER PON_BID_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID
PON_BID_SHIPMENTS	PON_AUCTION_ITEM_PRICES_ALL	PON_BID_SHIPMENTS.AUCTION_LINE_NUMBER PON_BID_SHIPMENTS.AUCTION_HEADER_ID
PON_PRICE_DIFFERENTIALS	PON_AUCTION_ITEM_PRICES_ALL	PON_PRICE_DIFFERENTIALS.LINE_NUMBER PON_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID
PON_PRICE_ELEMENTS	PON_AUCTION_ITEM_PRICES_ALL	PON_PRICE_ELEMENTS.LINE_NUMBER PON_PRICE_ELEMENTS.AUCTION_HEADER_ID