This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | Stores the acceptance of a respomses for an on-line negotiation of an item. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_ACCEPTANCES.AUCTION_LINE_NUMBER
PON_ACCEPTANCES.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON.PON_ACCEPTANCES does not reference any database object
PON.PON_ACCEPTANCES is referenced by following:
Description: | Holds the supplier user response of whether they acknowledged the changes in negotiation amendments. |
---|
PON.PON_ACKNOWLEDGEMENTS does not reference any database object
PON.PON_ACKNOWLEDGEMENTS is referenced by following:
Description: | To store Approval History |
---|
PON.PON_ACTION_HISTORY does not reference any database object
PON.PON_ACTION_HISTORY is referenced by following:
Description: | Interface table to store imported negotiation attachments |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_ATTACHMENTS_INTERFACE.DOCUMENT_ID | FND_DOCUMENTS |
PON.PON_ATTACHMENTS_INTERFACE does not reference any database object
PON.PON_ATTACHMENTS_INTERFACE is referenced by following:
Description: | Temporary table that contains the attribute details about the attributes that are transferred from BPA to a negotiation document. |
---|
PON.PON_ATTRIBUTES_INTERFACE does not reference any database object
PON.PON_ATTRIBUTES_INTERFACE is referenced by following:
Description: | Stores the attribute lists that belong to a trading partner. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_ATTRIBUTE_LISTS.TRADING_PARTNER_ID | HZ_PARTIES |
PON_ATTRIBUTE_LISTS.TRADING_PARTNER_CONTACT_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_ATTRIBUTES.ATTRIBUTE_LIST_ID | PON_ATTRIBUTE_LISTS |
PON_AUCTION_SECTIONS.ATTRIBUTE_LIST_ID | PON_ATTRIBUTE_LISTS |
PON.PON_ATTRIBUTE_LISTS does not reference any database object
PON.PON_ATTRIBUTE_LISTS is referenced by following:
Description: | stores the scoring criteria for a particular attribute |
---|
PON.PON_ATTRIBUTE_SCORES does not reference any database object
PON.PON_ATTRIBUTE_SCORES is referenced by following:
Description: | Stores negotiation item attributes. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_ATTRIBUTES.LINE_NUMBER
PON_AUCTION_ATTRIBUTES.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_AUCTION_ATTRIBUTES.ATTRIBUTE_LIST_ID | PON_ATTRIBUTE_LISTS |
PON_AUCTION_ATTRIBUTES.ATTRIBUTE_LIST_ID | PON_AUCTION_TEMPLATES |
PON.PON_AUCTION_ATTRIBUTES does not reference any database object
PON.PON_AUCTION_ATTRIBUTES is referenced by following:
Description: | Stores the currency conversion rate between the negotiation currency and the response currency |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_CURRENCY_RATES.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_AUCTION_CURRENCY_RATES.LIST_ID | PON_AUCTION_TEMPLATES |
PON.PON_AUCTION_CURRENCY_RATES does not reference any database object
PON.PON_AUCTION_CURRENCY_RATES is referenced by following:
Description: | Stores the event details of a group of negotiations. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_EVENTS.TRADING_PARTNER_ID | HZ_PARTIES |
PON_AUCTION_EVENTS.TRADING_PARTNER_CONTACT_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_HEADERS_ALL.EVENT_ID | PON_AUCTION_EVENTS |
PON.PON_AUCTION_EVENTS does not reference any database object
PON.PON_AUCTION_EVENTS is referenced by following:
Description: | Stores the negotiations header level details. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID | HZ_PARTIES |
PON_AUCTION_HEADERS_ALL.DOCTYPE_ID | PON_AUC_DOCTYPES |
PON_AUCTION_HEADERS_ALL.BILL_TO_LOCATION_ID | HR_LOCATIONS_ALL |
PON_AUCTION_HEADERS_ALL.BUYER_ID | FND_USER |
PON_AUCTION_HEADERS_ALL.PROJECT_ID | PA_PROJECTS_ALL |
PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME | FND_USER |
PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID | HZ_PARTIES |
PON_AUCTION_HEADERS_ALL.SHIP_TO_LOCATION_ID | HR_LOCATIONS_ALL |
PON_AUCTION_HEADERS_ALL.CURRENCY_CODE | FND_CURRENCIES |
PON_AUCTION_HEADERS_ALL.RATE_TYPE | GL_DAILY_CONVERSION_TYPES |
PON_AUCTION_HEADERS_ALL.LANGUAGE_CODE | FND_LANGUAGES |
PON_AUCTION_HEADERS_ALL.EVENT_ID | PON_AUCTION_EVENTS |
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_CURRENCY_RATES.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_AUCTION_ITEM_PRICES_ALL.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_AUCTION_SHIPMENTS_ALL.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_AUC_PAYMENTS_INTERFACE.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_AUC_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_AWARD_ALLOCATIONS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BIDDING_PARTIES.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BID_HEADERS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BID_PAYMENTS_INTERFACE.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BID_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BID_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BID_SHIPMENTS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_ITEM_PRICES_INTERFACE.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_NEG_TEAM_MEMBERS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_OPTIMIZE_CONSTRAINTS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_OPTIMIZE_SCENARIOS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_PARTY_LINE_EXCLUSIONS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SCORING_TEAMS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SCORING_TEAM_MEMBERS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SCORING_TEAM_SECTIONS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SUPPLIER_ACCESS.AUCTION_HEADER_ID_ORIG_AMEND | PON_AUCTION_HEADERS_ALL |
PON_SUPPLIER_ACCESS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SUPPLIER_ACTIVITIES.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SUPPLIER_ACTIVITIES.AUCTION_HEADER_ID_ORIG_AMEND | PON_AUCTION_HEADERS_ALL |
PON_TEAM_MEMBER_ATTR_SCORES.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_TEAM_MEMBER_BID_SCORES.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON.PON_AUCTION_HEADERS_ALL does not reference any database object
PON.PON_AUCTION_HEADERS_ALL is referenced by following:
Description: | Stores the negotiation item details including price. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_ITEM_PRICES_ALL.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_AUCTION_ITEM_PRICES_ALL.PROJECT_EXPENDITURE_TYPE | PA_EXPENDITURE_TYPES |
PON_AUCTION_ITEM_PRICES_ALL.PROJECT_EXP_ORGANIZATION_ID | HR_ALL_ORGANIZATION_UNITS |
PON_AUCTION_ITEM_PRICES_ALL.CATEGORY_ID | MTL_CATEGORIES_B |
PON_AUCTION_ITEM_PRICES_ALL.LINE_TYPE_ID | PO_LINE_TYPES_B |
PON_AUCTION_ITEM_PRICES_ALL.PROJECT_ID | PA_PROJECTS_ALL |
PON_AUCTION_ITEM_PRICES_ALL.PROJECT_TASK_ID | PA_TASKS |
Foreign Key Column | Foreign Table |
---|---|
PON_ACCEPTANCES.AUCTION_LINE_NUMBER
PON_ACCEPTANCES.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_AUCTION_ATTRIBUTES.LINE_NUMBER
PON_AUCTION_ATTRIBUTES.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_AUCTION_SUMMARY.LINE_NUMBER
PON_AUCTION_SUMMARY.AUCTION_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_AUC_PAYMENTS_SHIPMENTS.LINE_NUMBER
PON_AUC_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_BACKING_REQUISITIONS.LINE_NUMBER
PON_BACKING_REQUISITIONS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_BID_ITEM_PRICES.LINE_NUMBER
PON_BID_ITEM_PRICES.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_BID_PAYMENTS_SHIPMENTS.AUCTION_LINE_NUMBER
PON_BID_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_BID_SHIPMENTS.AUCTION_LINE_NUMBER
PON_BID_SHIPMENTS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_PRICE_DIFFERENTIALS.LINE_NUMBER
PON_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_PRICE_ELEMENTS.LINE_NUMBER
PON_PRICE_ELEMENTS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON.PON_AUCTION_ITEM_PRICES_ALL does not reference any database object
PON.PON_AUCTION_ITEM_PRICES_ALL is referenced by following:
Description: | This table stores the distinct sections for Requirements (Header Attributes) |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_SECTIONS.ATTRIBUTE_LIST_ID | PON_ATTRIBUTE_LISTS |
PON.PON_AUCTION_SECTIONS does not reference any database object
PON.PON_AUCTION_SECTIONS is referenced by following:
Description: | Stores the negotiation shipment details |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_SHIPMENTS_ALL.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_AUCTION_SHIPMENTS_ALL.SHIP_TO_LOCATION_ID | HR_LOCATIONS_ALL |
Foreign Key Column | Foreign Table |
---|---|
PON_BID_SHIPMENTS.AUCTION_SHIPMENT_NUMBER
PON_BID_SHIPMENTS.AUCTION_LINE_NUMBER PON_BID_SHIPMENTS.AUCTION_HEADER_ID |
PON_AUCTION_SHIPMENTS_ALL |
PON_PRICE_DIFFERENTIALS.SHIPMENT_NUMBER
PON_PRICE_DIFFERENTIALS.LINE_NUMBER PON_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID |
PON_AUCTION_SHIPMENTS_ALL |
PON.PON_AUCTION_SHIPMENTS_ALL does not reference any database object
PON.PON_AUCTION_SHIPMENTS_ALL is referenced by following:
Description: | Temporary table used to generate summary data for an item involved in an auction to display in the auction summary page |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_SUMMARY.LINE_NUMBER
PON_AUCTION_SUMMARY.AUCTION_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_AUCTION_SUMMARY.TRADING_PARTNER_ID | HZ_PARTIES |
PON.PON_AUCTION_SUMMARY does not reference any database object
PON.PON_AUCTION_SUMMARY is referenced by following:
Description: | Stores the template information from which negotiations can be created |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_TEMPLATES.TRADING_PARTNER_ID | HZ_PARTIES |
PON_AUCTION_TEMPLATES.CATEGORY_ID | MTL_CATEGORIES_B |
PON_AUCTION_TEMPLATES.TRADING_PARTNER_CONTACT_ID | HZ_PARTIES |
PON_AUCTION_TEMPLATES.CURRENCY_CODE | FND_CURRENCIES |
PON_AUCTION_TEMPLATES.RATE_TYPE | GL_DAILY_CONVERSION_TYPES |
PON_AUCTION_TEMPLATES.LANGUAGE_CODE | FND_LANGUAGES |
PON_AUCTION_TEMPLATES.DOCTYPE_ID | PON_AUC_DOCTYPES |
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_ATTRIBUTES.ATTRIBUTE_LIST_ID | PON_AUCTION_TEMPLATES |
PON_AUCTION_CURRENCY_RATES.LIST_ID | PON_AUCTION_TEMPLATES |
PON_BIDDING_PARTIES.LIST_ID | PON_AUCTION_TEMPLATES |
PON_NEG_TEAM_MEMBERS.LIST_ID | PON_AUCTION_TEMPLATES |
PON_PRICE_ELEMENTS.LIST_ID | PON_AUCTION_TEMPLATES |
PON.PON_AUCTION_TEMPLATES does not reference any database object
PON.PON_AUCTION_TEMPLATES is referenced by following:
Description: | Temporary table that contains the attribute details that have been imported or exported to to excel. |
---|
PON.PON_AUC_ATTRIBUTES_INTERFACE does not reference any database object
PON.PON_AUC_ATTRIBUTES_INTERFACE is referenced by following:
Description: | Stores negotiations business rules |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_BIZRULE_VALUES.BIZRULE_ID | PON_AUC_BIZRULES |
PON_AUC_DOCTYPE_RULES.BIZRULE_ID | PON_AUC_BIZRULES |
PON.PON_AUC_BIZRULES does not reference any database object
PON.PON_AUC_BIZRULES is referenced by following:
Description: | Stores the value for the negotiation business rule |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_BIZRULE_VALUES.BIZRULE_ID | PON_AUC_BIZRULES |
PON_AUC_BIZRULE_VALUES.DOCTYPE_ID | PON_AUC_DOCTYPES |
PON.PON_AUC_BIZRULE_VALUES does not reference any database object
PON.PON_AUC_BIZRULE_VALUES is referenced by following:
Description: | Stores the negotiation document type |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUCTION_HEADERS_ALL.DOCTYPE_ID | PON_AUC_DOCTYPES |
PON_AUCTION_TEMPLATES.DOCTYPE_ID | PON_AUC_DOCTYPES |
PON_AUC_BIZRULE_VALUES.DOCTYPE_ID | PON_AUC_DOCTYPES |
PON_AUC_DOCTYPES_TL.DOCTYPE_ID | PON_AUC_DOCTYPES |
PON_AUC_DOCTYPE_RULES.DOCTYPE_ID | PON_AUC_DOCTYPES |
PON.PON_AUC_DOCTYPES does not reference any database object
PON.PON_AUC_DOCTYPES is referenced by following:
Description: | Stores the translated document type name |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_DOCTYPES_TL.DOCTYPE_ID | PON_AUC_DOCTYPES |
PON_AUC_DOCTYPES_TL.LANGUAGE | FND_LANGUAGES |
PON.PON_AUC_DOCTYPES_TL does not reference any database object
PON.PON_AUC_DOCTYPES_TL is referenced by following:
Description: | Stores the business rules is applicable to a negotiation document type |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_DOCTYPE_RULES.BIZRULE_ID | PON_AUC_BIZRULES |
PON_AUC_DOCTYPE_RULES.DOCTYPE_ID | PON_AUC_DOCTYPES |
PON.PON_AUC_DOCTYPE_RULES does not reference any database object
PON.PON_AUC_DOCTYPE_RULES is referenced by following:
Description: | Interface table to store imported negotiation header information |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_HEADERS_INTERFACE.SHIP_TO_LOCATION_ID | HR_LOCATIONS_ALL |
PON_AUC_HEADERS_INTERFACE.BILL_TO_LOCATION_ID | HR_LOCATIONS_ALL |
PON_AUC_HEADERS_INTERFACE.CURRENCY_CODE | FND_CURRENCIES |
PON_AUC_HEADERS_INTERFACE.RATE_TYPE | GL_DAILY_CONVERSION_TYPES |
PON_AUC_HEADERS_INTERFACE.USER_ID | FND_USER |
PON_AUC_HEADERS_INTERFACE.SUPPLIER_ID | PO_VENDORS |
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_ITEMS_INTERFACE.INTERFACE_AUCTION_HEADER_ID | PON_AUC_HEADERS_INTERFACE |
PON_AUC_SHIPMENTS_INTERFACE.INTERFACE_AUCTION_HEADER_ID | PON_AUC_HEADERS_INTERFACE |
PON_PRICE_DIFFER_INTERFACE.INTERFACE_AUCTION_HEADER_ID | PON_AUC_HEADERS_INTERFACE |
PON.PON_AUC_HEADERS_INTERFACE does not reference any database object
PON.PON_AUC_HEADERS_INTERFACE is referenced by following:
Description: | Interface table to store imported negotiation item information |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_ITEMS_INTERFACE.INTERFACE_AUCTION_HEADER_ID | PON_AUC_HEADERS_INTERFACE |
PON_AUC_ITEMS_INTERFACE.LINE_TYPE_ID | PO_LINE_TYPES_B |
PON_AUC_ITEMS_INTERFACE.CATEGORY_ID | MTL_CATEGORIES_B |
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_SHIPMENTS_INTERFACE.INTERFACE_LINE_NUMBER
PON_AUC_SHIPMENTS_INTERFACE.INTERFACE_AUCTION_HEADER_ID |
PON_AUC_ITEMS_INTERFACE |
PON_PRICE_DIFFER_INTERFACE.INTERFACE_LINE_NUMBER
PON_PRICE_DIFFER_INTERFACE.INTERFACE_AUCTION_HEADER_ID |
PON_AUC_ITEMS_INTERFACE |
PON.PON_AUC_ITEMS_INTERFACE does not reference any database object
PON.PON_AUC_ITEMS_INTERFACE is referenced by following:
Description: | Interface table to store imported information of the payments that are defined on a negotiation for complex services. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_PAYMENTS_INTERFACE.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON.PON_AUC_PAYMENTS_INTERFACE does not reference any database object
PON.PON_AUC_PAYMENTS_INTERFACE is referenced by following:
Description: | This contains the details of the payments that are defined on a negotiation for complex services. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_AUC_PAYMENTS_SHIPMENTS.LINE_NUMBER
PON_AUC_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_AUC_PAYMENTS_SHIPMENTS.PROJECT_ID | PA_PROJECTS_ALL |
PON_AUC_PAYMENTS_SHIPMENTS.PROJECT_TASK_ID | PA_TASKS |
PON_AUC_PAYMENTS_SHIPMENTS.PROJECT_EXP_ORGANIZATION_ID | HR_ALL_ORGANIZATION_UNITS |
PON_AUC_PAYMENTS_SHIPMENTS.SHIP_TO_LOCATION_ID | HR_LOCATIONS_ALL |
PON_AUC_PAYMENTS_SHIPMENTS.WORK_APPROVER_USER_ID | FND_USER |
Foreign Key Column | Foreign Table |
---|---|
PON_BID_PAYMENTS_SHIPMENTS.AUCTION_PAYMENT_ID | PON_AUC_PAYMENTS_SHIPMENTS |
PON_INTERFACE_ERRORS.PAYMENT_ID | PON_AUC_PAYMENTS_SHIPMENTS |
PON.PON_AUC_PAYMENTS_SHIPMENTS does not reference any database object
PON.PON_AUC_PAYMENTS_SHIPMENTS is referenced by following:
Description: | Temporary table that contains the price differential details that have been imported or exported to to excel. |
---|
PON.PON_AUC_PRICE_DIFFER_INT does not reference any database object
PON.PON_AUC_PRICE_DIFFER_INT is referenced by following:
Description: | Temporary table that contains the price element details that have been imported or exported to to excel. |
---|
PON.PON_AUC_PRICE_ELEMENTS_INT does not reference any database object
PON.PON_AUC_PRICE_ELEMENTS_INT is referenced by following:
Description: | Interface table to store imported negotiation shipment information |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AUC_SHIPMENTS_INTERFACE.SHIP_TO_LOCATION_ID | HR_LOCATIONS_ALL |
PON_AUC_SHIPMENTS_INTERFACE.INTERFACE_AUCTION_HEADER_ID | PON_AUC_HEADERS_INTERFACE |
PON_AUC_SHIPMENTS_INTERFACE.INTERFACE_LINE_NUMBER
PON_AUC_SHIPMENTS_INTERFACE.INTERFACE_AUCTION_HEADER_ID |
PON_AUC_ITEMS_INTERFACE |
Foreign Key Column | Foreign Table |
---|---|
PON_PRICE_DIFFER_INTERFACE.INTERFACE_SHIPMENT_NUMBER
PON_PRICE_DIFFER_INTERFACE.INTERFACE_LINE_NUMBER PON_PRICE_DIFFER_INTERFACE.INTERFACE_AUCTION_HEADER_ID |
PON_AUC_SHIPMENTS_INTERFACE |
PON.PON_AUC_SHIPMENTS_INTERFACE does not reference any database object
PON.PON_AUC_SHIPMENTS_INTERFACE is referenced by following:
Description: | Contains the allocation of each awarded response to the backing requisitions for a particular negotiation line. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AWARD_ALLOCATIONS.BID_NUMBER | PON_BID_HEADERS |
PON_AWARD_ALLOCATIONS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_AWARD_ALLOCATIONS.ORIG_REQ_LINE_ID | PO_REQUISITION_LINES_ALL |
PON_AWARD_ALLOCATIONS.ORIG_REQ_HEADER_ID | PO_REQUISITION_HEADERS_ALL |
PON_AWARD_ALLOCATIONS.SPLIT_REQ_LINE_ID | PO_REQUISITION_LINES_ALL |
PON.PON_AWARD_ALLOCATIONS does not reference any database object
PON.PON_AWARD_ALLOCATIONS is referenced by following:
Description: | Temporary table used to transfer data from spreadsheet to the negotiation award table. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_AWARD_ITEMS_INTERFACE.AUCTION_LINE_NUMBER
PON_AWARD_ITEMS_INTERFACE.BID_NUMBER |
PON_BID_ITEM_PRICES |
PON.PON_AWARD_ITEMS_INTERFACE does not reference any database object
PON.PON_AWARD_ITEMS_INTERFACE is referenced by following:
Description: | This table stores information about all the backing requisitions ties to a negotiation item line |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_BACKING_REQUISITIONS.LINE_NUMBER
PON_BACKING_REQUISITIONS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_BACKING_REQUISITIONS.REQUISITION_HEADER_ID | PO_REQUISITION_HEADERS_ALL |
PON_BACKING_REQUISITIONS.REQUISITION_LINE_ID | PO_REQUISITION_LINES_ALL |
PON.PON_BACKING_REQUISITIONS does not reference any database object
PON.PON_BACKING_REQUISITIONS is referenced by following:
Description: | Stores the header level data of an invitation list |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_BIDDERS_LISTS.TRADING_PARTNER_ID | HZ_PARTIES |
PON_BIDDERS_LISTS.TRADING_PARTNER_CONTACT_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
PON_BIDDING_PARTIES.LIST_ID | PON_BIDDERS_LISTS |
PON.PON_BIDDERS_LISTS does not reference any database object
PON.PON_BIDDERS_LISTS is referenced by following:
Description: | Stores the parties participating in a negotiation. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_BIDDING_PARTIES.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BIDDING_PARTIES.LIST_ID | PON_AUCTION_TEMPLATES |
PON_BIDDING_PARTIES.LIST_ID | PON_BIDDERS_LISTS |
PON_BIDDING_PARTIES.TRADING_PARTNER_ID | HZ_PARTIES |
PON.PON_BIDDING_PARTIES does not reference any database object
PON.PON_BIDDING_PARTIES is referenced by following:
Description: | Stores the attributes value of a line item which is part of a response to a negotiation. |
---|
PON.PON_BID_ATTRIBUTE_VALUES does not reference any database object
PON.PON_BID_ATTRIBUTE_VALUES is referenced by following:
Description: | Temporary table that stores data of response attribute values uploaded from spreadsheet |
---|
PON.PON_BID_ATTR_VALUES_INTERFACE does not reference any database object
PON.PON_BID_ATTR_VALUES_INTERFACE is referenced by following:
Description: | Contains header level data for a response to a negotiation |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_BID_HEADERS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BID_HEADERS.TRADING_PARTNER_ID | HZ_PARTIES |
PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID | HZ_PARTIES |
PON_BID_HEADERS.VENDOR_ID | PO_VENDORS |
PON_BID_HEADERS.TRADING_PARTNER_CONTACT_NAME | FND_USER |
Foreign Key Column | Foreign Table |
---|---|
PON_AWARD_ALLOCATIONS.BID_NUMBER | PON_BID_HEADERS |
PON_BID_ITEM_PRICES.BID_NUMBER | PON_BID_HEADERS |
PON_BID_PAYMENTS_INTERFACE.BID_NUMBER | PON_BID_HEADERS |
PON_BID_PAYMENTS_SHIPMENTS.BID_NUMBER | PON_BID_HEADERS |
PON_BID_PRICE_DIFFERENTIALS.BID_NUMBER | PON_BID_HEADERS |
PON_BID_REBATES.BID_NUMBER | PON_BID_HEADERS |
PON_BID_SHIPMENTS.BID_NUMBER | PON_BID_HEADERS |
PON_OPTIMIZE_BID_CLASS.BID_NUMBER | PON_BID_HEADERS |
PON_OPTIMIZE_RESULTS.BID_NUMBER | PON_BID_HEADERS |
PON_TEAM_MEMBER_ATTR_SCORES.BID_NUMBER | PON_BID_HEADERS |
PON_TEAM_MEMBER_BID_SCORES.BID_NUMBER | PON_BID_HEADERS |
PON.PON_BID_HEADERS does not reference any database object
PON.PON_BID_HEADERS is referenced by following:
Description: | Contains an archive of the header level data of a negotiation response |
---|
PON.PON_BID_HEADERS_ARCH does not reference any database object
PON.PON_BID_HEADERS_ARCH is referenced by following:
Description: | Contains the response details for an item in a negotiation |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_BID_ITEM_PRICES.BID_NUMBER | PON_BID_HEADERS |
PON_BID_ITEM_PRICES.LINE_NUMBER
PON_BID_ITEM_PRICES.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
Foreign Key Column | Foreign Table |
---|---|
PON_AWARD_ITEMS_INTERFACE.AUCTION_LINE_NUMBER
PON_AWARD_ITEMS_INTERFACE.BID_NUMBER |
PON_BID_ITEM_PRICES |
PON.PON_BID_ITEM_PRICES does not reference any database object
PON.PON_BID_ITEM_PRICES is referenced by following:
Description: | PON_BID_ITEMS_PROCES_INTERFACE temporarily stores response information. |
---|
PON.PON_BID_ITEM_PRICES_INTERFACE does not reference any database object
PON.PON_BID_ITEM_PRICES_INTERFACE is referenced by following:
Description: | Interface table to store imported information of the payments that are defined on a response to a negotiation for complex services. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_BID_PAYMENTS_INTERFACE.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BID_PAYMENTS_INTERFACE.BID_NUMBER | PON_BID_HEADERS |
PON.PON_BID_PAYMENTS_INTERFACE does not reference any database object
PON.PON_BID_PAYMENTS_INTERFACE is referenced by following:
Description: | This contains the details of the payments that are defined on a response with complex services. This corresponds to the PON_AUC_PAYMENTS_SHIPMENTS table which defines payments on a negotiation. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_BID_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BID_PAYMENTS_SHIPMENTS.BID_NUMBER | PON_BID_HEADERS |
PON_BID_PAYMENTS_SHIPMENTS.AUCTION_LINE_NUMBER
PON_BID_PAYMENTS_SHIPMENTS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_BID_PAYMENTS_SHIPMENTS.AUCTION_PAYMENT_ID | PON_AUC_PAYMENTS_SHIPMENTS |
Foreign Key Column | Foreign Table |
---|---|
PON_INTERFACE_ERRORS.BID_PAYMENT_ID | PON_BID_PAYMENTS_SHIPMENTS |
PON.PON_BID_PAYMENTS_SHIPMENTS does not reference any database object
PON.PON_BID_PAYMENTS_SHIPMENTS is referenced by following:
Description: | Response price differentials table |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_BID_PRICE_DIFFERENTIALS.BID_NUMBER | PON_BID_HEADERS |
PON_BID_PRICE_DIFFERENTIALS.SHIPMENT_NUMBER
PON_BID_PRICE_DIFFERENTIALS.LINE_NUMBER PON_BID_PRICE_DIFFERENTIALS.BID_NUMBER |
PON_BID_SHIPMENTS |
PON_BID_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON.PON_BID_PRICE_DIFFERENTIALS does not reference any database object
PON.PON_BID_PRICE_DIFFERENTIALS is referenced by following:
Description: | Temporary table that contains the response price differential details that have been imported or exported to to excel. |
---|
PON.PON_BID_PRICE_DIFFER_INT does not reference any database object
PON.PON_BID_PRICE_DIFFER_INT is referenced by following:
Description: | Stores price element bid details included in an auction or RFQ. |
---|
PON.PON_BID_PRICE_ELEMENTS does not reference any database object
PON.PON_BID_PRICE_ELEMENTS is referenced by following:
Description: | Interface table for price element |
---|
PON.PON_BID_PRICE_ELEMENTS_INT does not reference any database object
PON.PON_BID_PRICE_ELEMENTS_INT is referenced by following:
Description: | This table is used to store rebates for a particular bid |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_BID_REBATES.BID_NUMBER | PON_BID_HEADERS |
PON.PON_BID_REBATES does not reference any database object
PON.PON_BID_REBATES is referenced by following:
Description: | Contains the response details for an shipment in a negotiation |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_BID_SHIPMENTS.BID_NUMBER | PON_BID_HEADERS |
PON_BID_SHIPMENTS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_BID_SHIPMENTS.AUCTION_LINE_NUMBER
PON_BID_SHIPMENTS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_BID_SHIPMENTS.AUCTION_SHIPMENT_NUMBER
PON_BID_SHIPMENTS.AUCTION_LINE_NUMBER PON_BID_SHIPMENTS.AUCTION_HEADER_ID |
PON_AUCTION_SHIPMENTS_ALL |
PON_BID_SHIPMENTS.SHIP_TO_LOCATION_ID | HR_LOCATIONS_ALL |
Foreign Key Column | Foreign Table |
---|---|
PON_BID_PRICE_DIFFERENTIALS.SHIPMENT_NUMBER
PON_BID_PRICE_DIFFERENTIALS.LINE_NUMBER PON_BID_PRICE_DIFFERENTIALS.BID_NUMBER |
PON_BID_SHIPMENTS |
PON.PON_BID_SHIPMENTS does not reference any database object
PON.PON_BID_SHIPMENTS is referenced by following:
Description: | This contains the list of allowable colors which will be used in the Live Console graphs. The shapes and the associated image file names are also stored. The colors are used to uniquely identify each supplier's bids on the graphs. |
---|
PON.PON_COLORS does not reference any database object
PON.PON_COLORS is referenced by following:
Description: | Stores the contract information such as Terms and Conditions that the negotiation owner would like a participant to accept. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_CONTRACTS.AUTHORING_PARTY_ID | HZ_PARTIES |
PON_CONTRACTS.AUTHORING_PARTY_CONTACT_ID | HZ_PARTIES |
PON.PON_CONTRACTS does not reference any database object
PON.PON_CONTRACTS is referenced by following:
Description: | Stores the contract information in each language |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_CONTRACTS_TL.VERSION_NUM
PON_CONTRACTS_TL.CONTRACT_ID |
% |
PON.PON_CONTRACTS_TL does not reference any database object
PON.PON_CONTRACTS_TL is referenced by following:
Description: | This is the driving table for discussions. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_DISCUSSIONS.LANGUAGE_CODE | FND_LANGUAGES |
PON_DISCUSSIONS.OWNER_PARTY_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
PON_THREADS.DISCUSSION_ID | PON_DISCUSSIONS |
PON_THREAD_ENTRIES.DISCUSSION_ID | PON_DISCUSSIONS |
PON.PON_DISCUSSIONS does not reference any database object
PON.PON_DISCUSSIONS is referenced by following:
Description: | This table stores whether a style is enabled for a document type. |
---|
PON.PON_DOCTYPE_STYLES does not reference any database object
PON.PON_DOCTYPE_STYLES is referenced by following:
Description: | Stores information about a field. |
---|
PON.PON_FIELDS does not reference any database object
PON.PON_FIELDS is referenced by following:
Description: | Stores translatable information about a field. |
---|
PON.PON_FIELDS_TL does not reference any database object
PON.PON_FIELDS_TL is referenced by following:
Description: | Stores the relationship between the form and the negotiation/event. |
---|
PON.PON_FORMS_INSTANCES does not reference any database object
PON.PON_FORMS_INSTANCES is referenced by following:
Description: | Store the header details for a form, section or abstract. |
---|
PON.PON_FORMS_SECTIONS does not reference any database object
PON.PON_FORMS_SECTIONS is referenced by following:
Description: | Stores the language specific information for a form, section or abstract. |
---|
PON.PON_FORMS_SECTIONS_TL does not reference any database object
PON.PON_FORMS_SECTIONS_TL is referenced by following:
Description: | Stores the form data. |
---|
PON.PON_FORM_FIELD_VALUES does not reference any database object
PON.PON_FORM_FIELD_VALUES is referenced by following:
Description: | Stored the "compiled form". |
---|
PON.PON_FORM_SECTION_COMPILED does not reference any database object
PON.PON_FORM_SECTION_COMPILED is referenced by following:
Description: | Stores the relationships between a form, section or abstract and its components. |
---|
PON.PON_FORM_SECTION_FIELDS does not reference any database object
PON.PON_FORM_SECTION_FIELDS is referenced by following:
Description: | This table is used to store data from the attributes table that was deleted as part of the Minimun release upgrade |
---|
PON.PON_FPJ_DELETED_ATTRIBUTES does not reference any database object
PON.PON_FPJ_DELETED_ATTRIBUTES is referenced by following:
Description: | This table stores information about the deleted unit price elements in FPK. |
---|
PON.PON_FPK_DELETED_PRICE_ELEMENTS does not reference any database object
PON.PON_FPK_DELETED_PRICE_ELEMENTS is referenced by following:
Description: | Contains any errors from interfaces to other applications |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_INTERFACE_ERRORS.PAYMENT_ID | PON_AUC_PAYMENTS_SHIPMENTS |
PON_INTERFACE_ERRORS.BID_PAYMENT_ID | PON_BID_PAYMENTS_SHIPMENTS |
PON.PON_INTERFACE_ERRORS does not reference any database object
PON.PON_INTERFACE_ERRORS is referenced by following:
Description: | Temporary table contains the item price details that have been imported or exported to to excel. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_ITEM_PRICES_INTERFACE.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_ITEM_PRICES_INTERFACE.PROJECT_ID | PA_PROJECTS_ALL |
PON_ITEM_PRICES_INTERFACE.PROJECT_TASK_ID | PA_TASKS |
PON_ITEM_PRICES_INTERFACE.WORK_APPROVER_USER_ID | FND_USER |
PON.PON_ITEM_PRICES_INTERFACE does not reference any database object
PON.PON_ITEM_PRICES_INTERFACE is referenced by following:
Description: | This table stores the buyer price factor values for a given supplier for a large negotiation |
---|
PON.PON_LARGE_NEG_PF_VALUES does not reference any database object
PON.PON_LARGE_NEG_PF_VALUES is referenced by following:
Description: | This table stores negotiation style related information. |
---|
PON.PON_NEGOTIATION_STYLES does not reference any database object
PON.PON_NEGOTIATION_STYLES is referenced by following:
Description: | This table stores language specific negotiation style information. |
---|
PON.PON_NEGOTIATION_STYLES_TL does not reference any database object
PON.PON_NEGOTIATION_STYLES_TL is referenced by following:
Description: | Stores Collaboration Team member details included in a negotiation or template. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_NEG_TEAM_MEMBERS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_NEG_TEAM_MEMBERS.LIST_ID | PON_AUCTION_TEMPLATES |
PON_NEG_TEAM_MEMBERS.USER_ID | FND_USER |
PON.PON_NEG_TEAM_MEMBERS does not reference any database object
PON.PON_NEG_TEAM_MEMBERS is referenced by following:
Description: | This table stores the individual notifications assigned to a particular group. |
---|
PON.PON_NOTIF_GROUP_MEMBERS does not reference any database object
PON.PON_NOTIF_GROUP_MEMBERS is referenced by following:
Description: | This table stores the notification subscription preferences for the sourcing instance. |
---|
PON.PON_NOTIF_SUBSCRIPTION_GROUPS does not reference any database object
PON.PON_NOTIF_SUBSCRIPTION_GROUPS is referenced by following:
Description: | This table stores the suppliers for a particular constraint |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_OPTIMIZE_BID_CLASS.SCENARIO_ID | % |
PON_OPTIMIZE_BID_CLASS.BID_NUMBER | PON_BID_HEADERS |
PON.PON_OPTIMIZE_BID_CLASS does not reference any database object
PON.PON_OPTIMIZE_BID_CLASS is referenced by following:
Description: | This table stores information about the user created constraints |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_OPTIMIZE_CONSTRAINTS.SCENARIO_ID | % |
PON_OPTIMIZE_CONSTRAINTS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_OPTIMIZE_CONSTRAINTS.TRADING_PARTNER_ID | HZ_PARTIES |
PON_OPTIMIZE_CONSTRAINTS.TRADING_PARTNER_CONTACT_ID | HZ_PARTIES |
PON.PON_OPTIMIZE_CONSTRAINTS does not reference any database object
PON.PON_OPTIMIZE_CONSTRAINTS is referenced by following:
Description: | This table stores information about the results of award optimization scenarios |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_OPTIMIZE_RESULTS.SCENARIO_ID | % |
PON_OPTIMIZE_RESULTS.BID_NUMBER | PON_BID_HEADERS |
PON.PON_OPTIMIZE_RESULTS does not reference any database object
PON.PON_OPTIMIZE_RESULTS is referenced by following:
Description: | This table stores information about the award optimization scenarios |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_OPTIMIZE_SCENARIOS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_OPTIMIZE_SCENARIOS.UPDATED_TP_CONTACT_ID | HZ_PARTIES |
PON.PON_OPTIMIZE_SCENARIOS does not reference any database object
PON.PON_OPTIMIZE_SCENARIOS is referenced by following:
Description: | Table stores negotiation line restrictions for a particular supplier/line combination |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_PARTY_LINE_EXCLUSIONS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON.PON_PARTY_LINE_EXCLUSIONS does not reference any database object
PON.PON_PARTY_LINE_EXCLUSIONS is referenced by following:
Description: | Stores data for a party preferences within an application |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_PARTY_PREFERENCES.PARTY_ID | HZ_PARTIES |
PON_PARTY_PREFERENCES.APP_SHORT_NAME | FND_APPLICATION |
PON.PON_PARTY_PREFERENCES does not reference any database object
PON.PON_PARTY_PREFERENCES is referenced by following:
Description: | This table stores aggregated price factor values for a given supplier. |
---|
PON.PON_PF_SUPPLIER_FORMULA does not reference any database object
PON.PON_PF_SUPPLIER_FORMULA is referenced by following:
Description: | This table stores auction costfactor values for invited suppliers. |
---|
PON.PON_PF_SUPPLIER_VALUES does not reference any database object
PON.PON_PF_SUPPLIER_VALUES is referenced by following:
Description: | Negotiation price differentials table |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_PRICE_DIFFERENTIALS.LINE_NUMBER
PON_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_PRICE_DIFFERENTIALS.SHIPMENT_NUMBER
PON_PRICE_DIFFERENTIALS.LINE_NUMBER PON_PRICE_DIFFERENTIALS.AUCTION_HEADER_ID |
PON_AUCTION_SHIPMENTS_ALL |
PON.PON_PRICE_DIFFERENTIALS does not reference any database object
PON.PON_PRICE_DIFFERENTIALS is referenced by following:
Description: | Interface table to store imported negotiation price differential information |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_PRICE_DIFFER_INTERFACE.INTERFACE_AUCTION_HEADER_ID | PON_AUC_HEADERS_INTERFACE |
PON_PRICE_DIFFER_INTERFACE.INTERFACE_LINE_NUMBER
PON_PRICE_DIFFER_INTERFACE.INTERFACE_AUCTION_HEADER_ID |
PON_AUC_ITEMS_INTERFACE |
PON_PRICE_DIFFER_INTERFACE.INTERFACE_SHIPMENT_NUMBER
PON_PRICE_DIFFER_INTERFACE.INTERFACE_LINE_NUMBER PON_PRICE_DIFFER_INTERFACE.INTERFACE_AUCTION_HEADER_ID |
PON_AUC_SHIPMENTS_INTERFACE |
PON.PON_PRICE_DIFFER_INTERFACE does not reference any database object
PON.PON_PRICE_DIFFER_INTERFACE is referenced by following:
Description: | Stores price element details included in an auction or RFQ. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_PRICE_ELEMENTS.PRICE_ELEMENT_TYPE_ID | PON_PRICE_ELEMENT_TYPES |
PON_PRICE_ELEMENTS.LINE_NUMBER
PON_PRICE_ELEMENTS.AUCTION_HEADER_ID |
PON_AUCTION_ITEM_PRICES_ALL |
PON_PRICE_ELEMENTS.LIST_ID | PON_PRICE_ELEMENT_LISTS |
PON_PRICE_ELEMENTS.LIST_ID | PON_AUCTION_TEMPLATES |
PON.PON_PRICE_ELEMENTS does not reference any database object
PON.PON_PRICE_ELEMENTS is referenced by following:
Description: | Stores price element list details |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_PRICE_ELEMENTS.LIST_ID | PON_PRICE_ELEMENT_LISTS |
PON.PON_PRICE_ELEMENT_LISTS does not reference any database object
PON.PON_PRICE_ELEMENT_LISTS is referenced by following:
Description: | Stores price element type details |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_PRICE_ELEMENTS.PRICE_ELEMENT_TYPE_ID | PON_PRICE_ELEMENT_TYPES |
PON_PRICE_ELEMENT_TYPES_TL.PRICE_ELEMENT_TYPE_ID | PON_PRICE_ELEMENT_TYPES |
PON.PON_PRICE_ELEMENT_TYPES does not reference any database object
PON.PON_PRICE_ELEMENT_TYPES is referenced by following:
Description: | Stores price element type language details |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_PRICE_ELEMENT_TYPES_TL.PRICE_ELEMENT_TYPE_ID | PON_PRICE_ELEMENT_TYPES |
PON.PON_PRICE_ELEMENT_TYPES_TL does not reference any database object
PON.PON_PRICE_ELEMENT_TYPES_TL is referenced by following:
Description: | This table stores information about scoring teams that may be created optionally for a negotiation. A scoring team is a group of collaboration team members who are assigned the responsibility of evaluating various negotiation attribute grou |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_SCORING_TEAMS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SCORING_TEAMS.ORIG_TEAM_ID | PON_SCORING_TEAMS |
Foreign Key Column | Foreign Table |
---|---|
PON_SCORING_TEAMS.ORIG_TEAM_ID | PON_SCORING_TEAMS |
PON_SCORING_TEAM_MEMBERS.TEAM_ID | PON_SCORING_TEAMS |
PON_SCORING_TEAM_SECTIONS.TEAM_ID | PON_SCORING_TEAMS |
PON_THREAD_ENTRIES.SCORING_TEAM_ID | PON_SCORING_TEAMS |
PON.PON_SCORING_TEAMS does not reference any database object
PON.PON_SCORING_TEAMS is referenced by following:
Description: | PON_SCORING_TEAM_MEMBERS is a logical intersection entity between PON_NEG_TEAM_MEMBERS and PON_SCORING_TEAMS. It lists the members for each scoring team for a given negotiation. Typically this will be a subset of those collaboration team me |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_SCORING_TEAM_MEMBERS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SCORING_TEAM_MEMBERS.TEAM_ID | PON_SCORING_TEAMS |
PON_SCORING_TEAM_MEMBERS.USER_ID | FND_USER |
PON.PON_SCORING_TEAM_MEMBERS does not reference any database object
PON.PON_SCORING_TEAM_MEMBERS is referenced by following:
Description: | PON_SCORING_TEAM_SECTIONS records the team that has been assigned the responsibility of scoring each header attribute group for a negotiation that allows team scoring. Only one team may be assigned to a particular header attribute group wh |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_SCORING_TEAM_SECTIONS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SCORING_TEAM_SECTIONS.TEAM_ID | PON_SCORING_TEAMS |
PON.PON_SCORING_TEAM_SECTIONS does not reference any database object
PON.PON_SCORING_TEAM_SECTIONS is referenced by following:
Description: | This table will record the lock status for a supplier. As the negotiation proceeds the user might lock a supplier out of the negotiation from the 'Manage Supplier Activities' screen. At that point in time we will flag the supplier as 'Lo |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_SUPPLIER_ACCESS.AUCTION_HEADER_ID_ORIG_AMEND | PON_AUCTION_HEADERS_ALL |
PON_SUPPLIER_ACCESS.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SUPPLIER_ACCESS.SUPPLIER_TRADING_PARTNER_ID | HZ_PARTIES |
PON_SUPPLIER_ACCESS.BUYER_TP_CONTACT_ID | HZ_PARTIES |
PON.PON_SUPPLIER_ACCESS does not reference any database object
PON.PON_SUPPLIER_ACCESS is referenced by following:
Description: | This table will contain a row for each distinct activity performed by a Supplier User on the Negotiation as he/she navigates through the bidding flow. The latest activity will be indicated as such by the last_action_flag. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_SUPPLIER_ACTIVITIES.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_SUPPLIER_ACTIVITIES.AUCTION_HEADER_ID_ORIG_AMEND | PON_AUCTION_HEADERS_ALL |
PON_SUPPLIER_ACTIVITIES.TRADING_PARTNER_ID | HZ_PARTIES |
PON_SUPPLIER_ACTIVITIES.TRADING_PARTNER_CONTACT_ID | HZ_PARTIES |
PON_SUPPLIER_ACTIVITIES.SESSION_ID | ICX_SESSIONS |
PON.PON_SUPPLIER_ACTIVITIES does not reference any database object
PON.PON_SUPPLIER_ACTIVITIES is referenced by following:
Description: | PON_SUPPLIER_PROVIDERS stores details of supplier providers. |
---|
PON.PON_SUPPLIER_PROVIDERS does not reference any database object
PON.PON_SUPPLIER_PROVIDERS is referenced by following:
Description: | This table records scores for every scoring team member for a given attribute and a response. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_TEAM_MEMBER_ATTR_SCORES.BID_NUMBER | PON_BID_HEADERS |
PON_TEAM_MEMBER_ATTR_SCORES.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_TEAM_MEMBER_ATTR_SCORES.USER_ID | FND_USER |
PON.PON_TEAM_MEMBER_ATTR_SCORES does not reference any database object
PON.PON_TEAM_MEMBER_ATTR_SCORES is referenced by following:
Description: | For negotiations enabled for team scoring, this table stores the evaluation for the responses on this negotiation for each team member. The table also records the date the response was scored and current score statusFor negotiations enabled |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_TEAM_MEMBER_BID_SCORES.USER_ID | FND_USER |
PON_TEAM_MEMBER_BID_SCORES.AUCTION_HEADER_ID | PON_AUCTION_HEADERS_ALL |
PON_TEAM_MEMBER_BID_SCORES.BID_NUMBER | PON_BID_HEADERS |
PON.PON_TEAM_MEMBER_BID_SCORES does not reference any database object
PON.PON_TEAM_MEMBER_BID_SCORES is referenced by following:
Description: | This table lists the recipient of the message. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_TE_RECIPIENTS.ENTRY_ID | PON_THREAD_ENTRIES |
PON_TE_RECIPIENTS.TO_ID | HZ_PARTIES |
PON_TE_RECIPIENTS.TO_COMPANY_ID | HZ_PARTIES |
PON.PON_TE_RECIPIENTS does not reference any database object
PON.PON_TE_RECIPIENTS is referenced by following:
Description: | A simple table keeping track of who viewed which message when. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_TE_VIEW_AUDIT.ENTRY_ID | PON_THREAD_ENTRIES |
PON_TE_VIEW_AUDIT.VIEWER_PARTY_ID | HZ_PARTIES |
PON.PON_TE_VIEW_AUDIT does not reference any database object
PON.PON_TE_VIEW_AUDIT is referenced by following:
Description: | This identifies simple metadata for the thread. |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_THREADS.DISCUSSION_ID | PON_DISCUSSIONS |
PON_THREADS.LANGUAGE_CODE | FND_LANGUAGES |
PON_THREADS.OWNER_PARTY_ID | HZ_PARTIES |
Foreign Key Column | Foreign Table |
---|---|
PON_THREAD_ENTRIES.DISCUSSION_ID
PON_THREAD_ENTRIES.THREAD_NUMBER |
PON_THREADS |
PON.PON_THREADS does not reference any database object
PON.PON_THREADS is referenced by following:
Description: | Stores message content for threaded discussions |
---|
Foreign Key Column | Foreign Table |
---|---|
PON_THREAD_ENTRIES.DISCUSSION_ID | PON_DISCUSSIONS |
PON_THREAD_ENTRIES.DISCUSSION_ID
PON_THREAD_ENTRIES.THREAD_NUMBER |
PON_THREADS |
PON_THREAD_ENTRIES.FROM_ID | HZ_PARTIES |
PON_THREAD_ENTRIES.FROM_COMPANY_ID | HZ_PARTIES |
PON_THREAD_ENTRIES.SCORING_TEAM_ID | PON_SCORING_TEAMS |
Foreign Key Column | Foreign Table |
---|---|
PON_TE_RECIPIENTS.ENTRY_ID | PON_THREAD_ENTRIES |
PON_TE_VIEW_AUDIT.ENTRY_ID | PON_THREAD_ENTRIES |
PON.PON_THREAD_ENTRIES does not reference any database object
PON.PON_THREAD_ENTRIES is referenced by following:
Description: | Holds the debug statements for workflow processes |
---|
PON.PON_WF_DEBUG does not reference any database object
PON.PON_WF_DEBUG is referenced by following:
APPS.PON_AUCTION_HEADERS_V is not referenced by any database object
APPS.PON_AUC_NOTIF_DELIV_V is not referenced by any database object
APPS.PON_BUYER_MANAGE_DELIV_V is not referenced by any database object
APPS.PON_MI_AUCTIONSUMMARY_V is not referenced by any database object
APPS.PON_MI_AUC_SAVINGS_V is not referenced by any database object
APPS.PON_MI_RFQSUMMARY_V is not referenced by any database object
APPS.PON_SUPPLIER_MANAGE_DELIV_V is not referenced by any database object
APPS.PON_SYSTEM_FIELDS_VALUES_V is not referenced by any database object
APPS.PON_VALID_NEG_STYLES_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |