Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

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.

eTRM - PON Tables and Views

TABLE - PON.PON_ACCEPTANCES
TABLE - PON.PON_ACKNOWLEDGEMENTS
TABLE - PON.PON_ACTION_HISTORY
TABLE - PON.PON_ATTACHMENTS_INTERFACE
TABLE - PON.PON_ATTRIBUTES_INTERFACE
TABLE - PON.PON_ATTRIBUTE_LISTS
TABLE - PON.PON_ATTRIBUTE_SCORES
TABLE - PON.PON_AUCTION_ATTRIBUTES
TABLE - PON.PON_AUCTION_ATTR_MAPPING_B
TABLE - PON.PON_AUCTION_CURRENCY_RATES
TABLE - PON.PON_AUCTION_EVENTS
TABLE - PON.PON_AUCTION_HEADERS_ALL
TABLE - PON.PON_AUCTION_ITEM_PRICES_ALL
TABLE - PON.PON_AUCTION_SECTIONS
TABLE - PON.PON_AUCTION_SHIPMENTS_ALL
TABLE - PON.PON_AUCTION_SUMMARY
TABLE - PON.PON_AUCTION_TEMPLATES
TABLE - PON.PON_AUC_ATTRIBUTES_INTERFACE
TABLE - PON.PON_AUC_BIZRULES
TABLE - PON.PON_AUC_BIZRULE_VALUES
TABLE - PON.PON_AUC_DOCTYPES
TABLE - PON.PON_AUC_DOCTYPES_TL
TABLE - PON.PON_AUC_DOCTYPE_RULES
TABLE - PON.PON_AUC_HEADERS_INTERFACE
TABLE - PON.PON_AUC_ITEMS_INTERFACE
TABLE - PON.PON_AUC_PAYMENTS_INTERFACE
TABLE - PON.PON_AUC_PAYMENTS_SHIPMENTS
TABLE - PON.PON_AUC_PRICE_DIFFER_INT
TABLE - PON.PON_AUC_PRICE_ELEMENTS_INT
TABLE - PON.PON_AUC_SHIPMENTS_INTERFACE
TABLE - PON.PON_AWARD_ALLOCATIONS
TABLE - PON.PON_AWARD_ITEMS_INTERFACE
TABLE - PON.PON_BACKING_REQUISITIONS
TABLE - PON.PON_BIDDERS_LISTS
TABLE - PON.PON_BIDDING_PARTIES
TABLE - PON.PON_BID_ATTRIBUTE_VALUES
TABLE - PON.PON_BID_ATTR_VALUES_INTERFACE
TABLE - PON.PON_BID_HEADERS
TABLE - PON.PON_BID_HEADERS_ARCH
TABLE - PON.PON_BID_HEADERS_INTERFACE
TABLE - PON.PON_BID_ITEM_PRICES
TABLE - PON.PON_BID_ITEM_PRICES_INTERFACE
TABLE - PON.PON_BID_ITEM_REFERENCES
TABLE - PON.PON_BID_PAYMENTS_INTERFACE
TABLE - PON.PON_BID_PAYMENTS_SHIPMENTS
TABLE - PON.PON_BID_PRICE_DIFFERENTIALS
TABLE - PON.PON_BID_PRICE_DIFFER_INT
TABLE - PON.PON_BID_PRICE_ELEMENTS
TABLE - PON.PON_BID_PRICE_ELEMENTS_INT
TABLE - PON.PON_BID_REBATES
TABLE - PON.PON_BID_SHIPMENTS
TABLE - PON.PON_BID_SHIPMENTS_INT
TABLE - PON.PON_COLORS
TABLE - PON.PON_CONTRACTS
TABLE - PON.PON_CONTRACTS_TL
TABLE - PON.PON_DISCUSSIONS
TABLE - PON.PON_DOCTYPE_STYLES
TABLE - PON.PON_EMD_CORPORATE
TABLE - PON.PON_EMD_FIN_PARAMETERS_ALL
TABLE - PON.PON_EMD_PAYMENT_TYPES_ALL
TABLE - PON.PON_EMD_PAYMENT_TYPES_TL
TABLE - PON.PON_EMD_TRANSACTIONS
TABLE - PON.PON_EVALUATION_TEAMS
TABLE - PON.PON_EVALUATION_TEAM_MEMBERS
TABLE - PON.PON_EVALUATION_TEAM_SECTIONS
TABLE - PON.PON_FBO_POSTS
TABLE - PON.PON_FIELDS
TABLE - PON.PON_FIELDS_TL
TABLE - PON.PON_FORMS_INSTANCES
TABLE - PON.PON_FORMS_SECTIONS
TABLE - PON.PON_FORMS_SECTIONS_TL
TABLE - PON.PON_FORM_FIELD_VALUES
TABLE - PON.PON_FORM_SECTION_COMPILED
TABLE - PON.PON_FORM_SECTION_FIELDS
TABLE - PON.PON_FPJ_DELETED_ATTRIBUTES
TABLE - PON.PON_FPK_DELETED_PRICE_ELEMENTS
TABLE - PON.PON_INTERFACE_ERRORS
TABLE - PON.PON_ITEM_PRICES_INTERFACE
TABLE - PON.PON_LARGE_NEG_PF_VALUES
TABLE - PON.PON_MNG_EVAL_BID_SECTIONS
TABLE - PON.PON_MNG_EVAL_TEAM_MEMBERS
TABLE - PON.PON_MNG_EVAL_TEAM_SECTIONS
TABLE - PON.PON_NEGOTIATION_STYLES
TABLE - PON.PON_NEGOTIATION_STYLES_TL
TABLE - PON.PON_NEG_TEAM_MEMBERS
TABLE - PON.PON_NOTIF_GROUP_MEMBERS
TABLE - PON.PON_NOTIF_SUBSCRIPTION_GROUPS
TABLE - PON.PON_OPTIMIZE_BID_CLASS
TABLE - PON.PON_OPTIMIZE_CONSTRAINTS
TABLE - PON.PON_OPTIMIZE_RESULTS
TABLE - PON.PON_OPTIMIZE_SCENARIOS
TABLE - PON.PON_ORCA_CERT_DETAILS
TABLE - PON.PON_PARTY_LINE_EXCLUSIONS
TABLE - PON.PON_PARTY_PREFERENCES
TABLE - PON.PON_PF_SUPPLIER_FORMULA
TABLE - PON.PON_PF_SUPPLIER_VALUES
TABLE - PON.PON_PRICE_DIFFERENTIALS
TABLE - PON.PON_PRICE_DIFFER_INTERFACE
TABLE - PON.PON_PRICE_ELEMENTS
TABLE - PON.PON_PRICE_ELEMENT_LISTS
TABLE - PON.PON_PRICE_ELEMENT_TYPES
TABLE - PON.PON_PRICE_ELEMENT_TYPES_TL
TABLE - PON.PON_SAAS_NEGOTIATION_PO
TABLE - PON.PON_SAAS_PO_ATTACHMENTS
TABLE - PON.PON_SCORING_TEAMS
TABLE - PON.PON_SCORING_TEAM_MEMBERS
TABLE - PON.PON_SCORING_TEAM_SECTIONS
TABLE - PON.PON_SUPPLIER_ACCESS
TABLE - PON.PON_SUPPLIER_ACTIVITIES
TABLE - PON.PON_SUPPLIER_PROVIDERS
TABLE - PON.PON_TEAM_MEMBER_ATTR_SCORES
TABLE - PON.PON_TEAM_MEMBER_BID_SCORES
TABLE - PON.PON_TE_RECIPIENTS
TABLE - PON.PON_TE_VIEW_AUDIT
TABLE - PON.PON_THREADS
TABLE - PON.PON_THREAD_ENTRIES
TABLE - PON.PON_UMBRELLA_PROGRAMS
TABLE - PON.PON_WF_DEBUG
VIEW - APPS.PON_AUCTION_HEADERS_ALL_V
VIEW - APPS.PON_AUCTION_HEADERS_V
VIEW - APPS.PON_AUC_NOTIF_DELIV_V
VIEW - APPS.PON_BUYER_MANAGE_DELIV_V
VIEW - APPS.PON_COST_FACTORS_VL
VIEW - APPS.PON_EMD_PAYMENT_TYPES_VL
VIEW - APPS.PON_EMPLOYEES_CURRENT_V
VIEW - APPS.PON_MI_AUCTIONSUMMARY_V
VIEW - APPS.PON_MI_AUC_BUYERAUC_V
VIEW - APPS.PON_MI_AUC_RFQ_V
VIEW - APPS.PON_MI_AUC_SAVINGS_V
VIEW - APPS.PON_MI_RFQSUMMARY_V
VIEW - APPS.PON_NEGOTIATION_STYLES_VL
VIEW - APPS.PON_PRICE_ELEMENT_TYPES_VL
VIEW - APPS.PON_SUPPLIER_MANAGE_DELIV_V
VIEW - APPS.PON_SYSTEM_FIELDS_VALUES_V
VIEW - APPS.PON_VALID_NEG_STYLES_V

Table: PON_ACCEPTANCES

Description: Stores the acceptance of a respomses for an on-line negotiation of an item.
Primary Key: PON_ACCEPTANCES_PK
  1. ACCEPTANCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_ACCEPTANCES.AUCTION_LINE_NUMBER
PON_ACCEPTANCES.AUCTION_HEADER_ID 		PON_AUCTION_ITEM_PRICES_ALL

[top of page]

PON.PON_ACCEPTANCES does not reference any database object

PON.PON_ACCEPTANCES is referenced by following:

PON
VIEW - PON_ACCEPTANCES#

[top of page]

Table: PON_ACKNOWLEDGEMENTS

Description: Holds the supplier user response of whether they acknowledged the changes in negotiation amendments.

[top of page]

PON.PON_ACKNOWLEDGEMENTS does not reference any database object

PON.PON_ACKNOWLEDGEMENTS is referenced by following:

PON
VIEW - PON_ACKNOWLEDGEMENTS#

[top of page]

Table: PON_ACTION_HISTORY

Description: To store Approval History
Primary Key: PON_ACTION_HISTORY_PK
  1. OBJECT_ID
  2. OBJECT_ID2
  3. SEQUENCE_NUM
  4. OBJECT_TYPE_CODE
  5. ACTION_TYPE

[top of page]

PON.PON_ACTION_HISTORY does not reference any database object

PON.PON_ACTION_HISTORY is referenced by following:

PON
VIEW - PON_ACTION_HISTORY#

[top of page]

Table: PON_ATTACHMENTS_INTERFACE

Description: Interface table to store imported negotiation attachments
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_ATTACHMENTS_INTERFACE.DOCUMENT_ID FND_DOCUMENTS

[top of page]

PON.PON_ATTACHMENTS_INTERFACE does not reference any database object

PON.PON_ATTACHMENTS_INTERFACE is referenced by following:

PON
VIEW - PON_ATTACHMENTS_INTERFACE#

[top of page]

Table: PON_ATTRIBUTES_INTERFACE

Description: Temporary table that contains the attribute details about the attributes that are transferred from BPA to a negotiation document.

[top of page]

PON.PON_ATTRIBUTES_INTERFACE does not reference any database object

PON.PON_ATTRIBUTES_INTERFACE is referenced by following:

PON
VIEW - PON_ATTRIBUTES_INTERFACE#

[top of page]

Table: PON_ATTRIBUTE_LISTS

Description: Stores the attribute lists that belong to a trading partner.
Primary Key: PON_ATTRIBUTE_LISTS_PK
  1. ATTRIBUTE_LIST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_ATTRIBUTE_LISTS.TRADING_PARTNER_ID HZ_PARTIES
PON_ATTRIBUTE_LISTS.TRADING_PARTNER_CONTACT_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PON_AUCTION_ATTRIBUTES.ATTRIBUTE_LIST_ID PON_ATTRIBUTE_LISTS
PON_AUCTION_SECTIONS.ATTRIBUTE_LIST_ID PON_ATTRIBUTE_LISTS

[top of page]

PON.PON_ATTRIBUTE_LISTS does not reference any database object

PON.PON_ATTRIBUTE_LISTS is referenced by following:

PON
VIEW - PON_ATTRIBUTE_LISTS#

[top of page]

Table: PON_ATTRIBUTE_SCORES

Description: stores the scoring criteria for a particular attribute
Primary Key: PON_ATTRIBUTE_SCORES_UK
  1. ATTRIBUTE_LIST_ID
  2. AUCTION_HEADER_ID
  3. LINE_NUMBER
  4. ATTRIBUTE_SEQUENCE_NUMBER
  5. SEQUENCE_NUMBER

[top of page]

PON.PON_ATTRIBUTE_SCORES does not reference any database object

PON.PON_ATTRIBUTE_SCORES is referenced by following:

PON
VIEW - PON_ATTRIBUTE_SCORES#

[top of page]

Table: PON_AUCTION_ATTRIBUTES

Description: Stores negotiation item attributes.
Primary Key: PON_AUCTION_ATTRIBUTES_UK
  1. LINE_NUMBER
  2. ATTRIBUTE_LIST_ID
  3. ATTRIBUTE_NAME
  4. AUCTION_HEADER_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_AUCTION_ATTRIBUTES does not reference any database object

PON.PON_AUCTION_ATTRIBUTES is referenced by following:

PON
VIEW - PON_AUCTION_ATTRIBUTES#

[top of page]

Table: PON_AUCTION_ATTR_MAPPING_B

Description: Supplier Management project. Mapping auction attributes to user-defined attributes.

[top of page]

PON.PON_AUCTION_ATTR_MAPPING_B does not reference any database object

PON.PON_AUCTION_ATTR_MAPPING_B is referenced by following:

PON
VIEW - PON_AUCTION_ATTR_MAPPING_B#

[top of page]

Table: PON_AUCTION_CURRENCY_RATES

Description: Stores the currency conversion rate between the negotiation currency and the response currency
Primary Key: PON_AUCTION_CURRENCY_RATES_UK
  1. BID_CURRENCY_CODE
  2. LIST_ID
  3. AUCTION_HEADER_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_AUCTION_CURRENCY_RATES does not reference any database object

PON.PON_AUCTION_CURRENCY_RATES is referenced by following:

PON
VIEW - PON_AUCTION_CURRENCY_RATES#

[top of page]

Table: PON_AUCTION_EVENTS

Description: Stores the event details of a group of negotiations.
Primary Key: PON_AUCTION_EVENTS_PK
  1. EVENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_AUCTION_EVENTS.TRADING_PARTNER_ID HZ_PARTIES
PON_AUCTION_EVENTS.TRADING_PARTNER_CONTACT_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PON_AUCTION_HEADERS_ALL.EVENT_ID PON_AUCTION_EVENTS

[top of page]

PON.PON_AUCTION_EVENTS does not reference any database object

PON.PON_AUCTION_EVENTS is referenced by following:

PON
VIEW - PON_AUCTION_EVENTS#

[top of page]

Table: PON_AUCTION_HEADERS_ALL

Description: Stores the negotiations header level details.
Primary Key: PON_AUCTION_HEADERS_ALL_PK
  1. AUCTION_HEADER_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column Foreign Table
PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID PON_AUCTION_HEADERS_ALL
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

[top of page]

PON.PON_AUCTION_HEADERS_ALL does not reference any database object

PON.PON_AUCTION_HEADERS_ALL is referenced by following:

PON
VIEW - PON_AUCTION_HEADERS_ALL#

[top of page]

Table: PON_AUCTION_ITEM_PRICES_ALL

Description: Stores the negotiation item details including price.
Primary Key: PON_AUCTION_ITEM_PRICES_ALL_PK
  1. AUCTION_HEADER_ID
  2. LINE_NUMBER
Foreign Keys from this table:
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 Keys to this table:
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_ITEM_REFERENCES.AUCTION_LINE_NUMBER
PON_BID_ITEM_REFERENCES.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

[top of page]

PON.PON_AUCTION_ITEM_PRICES_ALL does not reference any database object

PON.PON_AUCTION_ITEM_PRICES_ALL is referenced by following:

PON
VIEW - PON_AUCTION_ITEM_PRICES_ALL#

[top of page]

Table: PON_AUCTION_SECTIONS

Description: This table stores the distinct sections for Requirements (Header Attributes)
Primary Key: PON_AUCTION_SECTIONS_PK1
  1. SECTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_AUCTION_SECTIONS.ATTRIBUTE_LIST_ID PON_ATTRIBUTE_LISTS

[top of page]

PON.PON_AUCTION_SECTIONS does not reference any database object

PON.PON_AUCTION_SECTIONS is referenced by following:

PON
VIEW - PON_AUCTION_SECTIONS#

[top of page]

Table: PON_AUCTION_SHIPMENTS_ALL

Description: Stores the negotiation shipment details
Primary Key: PON_AUCTION_SHIPMENTS_ALL_PK1
  1. AUCTION_HEADER_ID
  2. LINE_NUMBER
  3. SHIPMENT_NUMBER
Foreign Keys from this table:
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 Keys to this table:
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

[top of page]

PON.PON_AUCTION_SHIPMENTS_ALL does not reference any database object

PON.PON_AUCTION_SHIPMENTS_ALL is referenced by following:

PON
VIEW - PON_AUCTION_SHIPMENTS_ALL#

[top of page]

Table: PON_AUCTION_SUMMARY

Description: Temporary table used to generate summary data for an item involved in an auction to display in the auction summary page
Primary Key: PON_AUCTION_SUMMARY_PK
  1. AUCTION_ID
  2. BATCH_ID
  3. LINE_NUMBER
Foreign Keys from this table:
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

[top of page]

PON.PON_AUCTION_SUMMARY does not reference any database object

PON.PON_AUCTION_SUMMARY is referenced by following:

PON
VIEW - PON_AUCTION_SUMMARY#

[top of page]

Table: PON_AUCTION_TEMPLATES

Description: Stores the template information from which negotiations can be created
Primary Key: PON_AUCTION_TEMPLATES_PK
  1. TEMPLATE_ID
Foreign Keys from this table:
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 Keys to this table:
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

[top of page]

PON.PON_AUCTION_TEMPLATES does not reference any database object

PON.PON_AUCTION_TEMPLATES is referenced by following:

PON
VIEW - PON_AUCTION_TEMPLATES#

[top of page]

Table: PON_AUC_ATTRIBUTES_INTERFACE

Description: Temporary table that contains the attribute details that have been imported or exported to to excel.

[top of page]

PON.PON_AUC_ATTRIBUTES_INTERFACE does not reference any database object

PON.PON_AUC_ATTRIBUTES_INTERFACE is referenced by following:

PON
VIEW - PON_AUC_ATTRIBUTES_INTERFACE#

[top of page]

Table: PON_AUC_BIZRULES

Description: Stores negotiations business rules
Primary Key: PON_AUC_BIZRULES_PK
  1. BIZRULE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PON_AUC_BIZRULE_VALUES.BIZRULE_ID PON_AUC_BIZRULES
PON_AUC_DOCTYPE_RULES.BIZRULE_ID PON_AUC_BIZRULES

[top of page]

PON.PON_AUC_BIZRULES does not reference any database object

PON.PON_AUC_BIZRULES is referenced by following:

PON
VIEW - PON_AUC_BIZRULES#

[top of page]

Table: PON_AUC_BIZRULE_VALUES

Description: Stores the value for the negotiation business rule
Primary Key: PON_AUC_BIZRULE_VALUES_PK
  1. LOOKUP_CODE
  2. BIZRULE_ID
  3. DOCTYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_AUC_BIZRULE_VALUES.BIZRULE_ID PON_AUC_BIZRULES
PON_AUC_BIZRULE_VALUES.DOCTYPE_ID PON_AUC_DOCTYPES

[top of page]

PON.PON_AUC_BIZRULE_VALUES does not reference any database object

PON.PON_AUC_BIZRULE_VALUES is referenced by following:

PON
VIEW - PON_AUC_BIZRULE_VALUES#

[top of page]

Table: PON_AUC_DOCTYPES

Description: Stores the negotiation document type
Primary Key: PON_AUC_DOCTYPES_PK
  1. DOCTYPE_ID
Foreign Keys to this table:
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

[top of page]

PON.PON_AUC_DOCTYPES does not reference any database object

PON.PON_AUC_DOCTYPES is referenced by following:

PON
VIEW - PON_AUC_DOCTYPES#

[top of page]

Table: PON_AUC_DOCTYPES_TL

Description: Stores the translated document type name
Primary Key: PON_AUC_DOCTYPES_TL_PK
  1. DOCTYPE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_AUC_DOCTYPES_TL.DOCTYPE_ID PON_AUC_DOCTYPES
PON_AUC_DOCTYPES_TL.LANGUAGE FND_LANGUAGES

[top of page]

PON.PON_AUC_DOCTYPES_TL does not reference any database object

PON.PON_AUC_DOCTYPES_TL is referenced by following:

PON
VIEW - PON_AUC_DOCTYPES_TL#

[top of page]

Table: PON_AUC_DOCTYPE_RULES

Description: Stores the business rules is applicable to a negotiation document type
Primary Key: PON_AUC_DOCTYPE_RULES_PK
  1. BIZRULE_ID
  2. DOCTYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_AUC_DOCTYPE_RULES.BIZRULE_ID PON_AUC_BIZRULES
PON_AUC_DOCTYPE_RULES.DOCTYPE_ID PON_AUC_DOCTYPES

[top of page]

PON.PON_AUC_DOCTYPE_RULES does not reference any database object

PON.PON_AUC_DOCTYPE_RULES is referenced by following:

PON
VIEW - PON_AUC_DOCTYPE_RULES#

[top of page]

Table: PON_AUC_HEADERS_INTERFACE

Description: Interface table to store imported negotiation header information
Primary Key: PON_AUC_HEADERS_INTERFACE_PK
  1. INTERFACE_AUCTION_HEADER_ID
Foreign Keys from this table:
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 Keys to this table:
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

[top of page]

PON.PON_AUC_HEADERS_INTERFACE does not reference any database object

PON.PON_AUC_HEADERS_INTERFACE is referenced by following:

PON
VIEW - PON_AUC_HEADERS_INTERFACE#

[top of page]

Table: PON_AUC_ITEMS_INTERFACE

Description: Interface table to store imported negotiation item information
Primary Key: PON_AUC_ITEMS_INTERFACE_PK
  1. INTERFACE_AUCTION_HEADER_ID
  2. INTERFACE_LINE_NUMBER
Foreign Keys from this table:
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 Keys to this table:
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

[top of page]

PON.PON_AUC_ITEMS_INTERFACE does not reference any database object

PON.PON_AUC_ITEMS_INTERFACE is referenced by following:

PON
VIEW - PON_AUC_ITEMS_INTERFACE#

[top of page]

Table: PON_AUC_PAYMENTS_INTERFACE

Description: Interface table to store imported information of the payments that are defined on a negotiation for complex services.
Primary Key: PON_AUC_PAYMENTS_INTERFACE_PK
  1. BATCH_ID
  2. INTERFACE_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_AUC_PAYMENTS_INTERFACE.AUCTION_HEADER_ID PON_AUCTION_HEADERS_ALL

[top of page]

PON.PON_AUC_PAYMENTS_INTERFACE does not reference any database object

PON.PON_AUC_PAYMENTS_INTERFACE is referenced by following:

PON
VIEW - PON_AUC_PAYMENTS_INTERFACE#

[top of page]

Table: PON_AUC_PAYMENTS_SHIPMENTS

Description: This contains the details of the payments that are defined on a negotiation for complex services.
Primary Key: PON_AUC_PAYMENTS_SHIPMENTS_PK
  1. PAYMENT_ID
Foreign Keys from this table:
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 Keys to this table:
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

[top of page]

PON.PON_AUC_PAYMENTS_SHIPMENTS does not reference any database object

PON.PON_AUC_PAYMENTS_SHIPMENTS is referenced by following:

PON
VIEW - PON_AUC_PAYMENTS_SHIPMENTS#

[top of page]

Table: PON_AUC_PRICE_DIFFER_INT

Description: Temporary table that contains the price differential details that have been imported or exported to to excel.

[top of page]

PON.PON_AUC_PRICE_DIFFER_INT does not reference any database object

PON.PON_AUC_PRICE_DIFFER_INT is referenced by following:

PON
VIEW - PON_AUC_PRICE_DIFFER_INT#

[top of page]

Table: PON_AUC_PRICE_ELEMENTS_INT

Description: Temporary table that contains the price element details that have been imported or exported to to excel.

[top of page]

PON.PON_AUC_PRICE_ELEMENTS_INT does not reference any database object

PON.PON_AUC_PRICE_ELEMENTS_INT is referenced by following:

PON
VIEW - PON_AUC_PRICE_ELEMENTS_INT#

[top of page]

Table: PON_AUC_SHIPMENTS_INTERFACE

Description: Interface table to store imported negotiation shipment information
Primary Key: PON_AUC_SHIPMENTS_INTERFACE_PK
  1. INTERFACE_AUCTION_HEADER_ID
  2. INTERFACE_SHIP_NUMBER
  3. INTERFACE_LINE_NUMBER
Foreign Keys from this table:
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 Keys to this table:
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

[top of page]

PON.PON_AUC_SHIPMENTS_INTERFACE does not reference any database object

PON.PON_AUC_SHIPMENTS_INTERFACE is referenced by following:

PON
VIEW - PON_AUC_SHIPMENTS_INTERFACE#

[top of page]

Table: PON_AWARD_ALLOCATIONS

Description: Contains the allocation of each awarded response to the backing requisitions for a particular negotiation line.
Primary Key: PON_AWARD_ALLOCATIONS_PK
  1. ORIG_REQ_LINE_ID
  2. BID_LINE_NUMBER
  3. BID_NUMBER
Foreign Keys from this table:
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

[top of page]

PON.PON_AWARD_ALLOCATIONS does not reference any database object

PON.PON_AWARD_ALLOCATIONS is referenced by following:

PON
VIEW - PON_AWARD_ALLOCATIONS#

[top of page]

Table: PON_AWARD_ITEMS_INTERFACE

Description: Temporary table used to transfer data from spreadsheet to the negotiation award table.
Primary Key: PON_AWARD_ITEMS_INTERFACE
  1. AUCTION_LINE_NUMBER
  2. BATCH_ID
  3. BID_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_AWARD_ITEMS_INTERFACE.AUCTION_LINE_NUMBER
PON_AWARD_ITEMS_INTERFACE.BID_NUMBER 		PON_BID_ITEM_PRICES

[top of page]

PON.PON_AWARD_ITEMS_INTERFACE does not reference any database object

PON.PON_AWARD_ITEMS_INTERFACE is referenced by following:

PON
VIEW - PON_AWARD_ITEMS_INTERFACE#

[top of page]

Table: PON_BACKING_REQUISITIONS

Description: This table stores information about all the backing requisitions ties to a negotiation item line
Primary Key: PON_BACKING_REQUISTIONS_PK
  1. AUCTION_HEADER_ID
  2. LINE_NUMBER
  3. REQUISITION_LINE_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_BACKING_REQUISITIONS does not reference any database object

PON.PON_BACKING_REQUISITIONS is referenced by following:

PON
VIEW - PON_BACKING_REQUISITIONS#

[top of page]

Table: PON_BIDDERS_LISTS

Description: Stores the header level data of an invitation list
Primary Key: PON_BIDDERS_LISTS_PK
  1. LIST_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_BIDDERS_LISTS.TRADING_PARTNER_ID HZ_PARTIES
PON_BIDDERS_LISTS.TRADING_PARTNER_CONTACT_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PON_BIDDING_PARTIES.LIST_ID PON_BIDDERS_LISTS

[top of page]

PON.PON_BIDDERS_LISTS does not reference any database object

PON.PON_BIDDERS_LISTS is referenced by following:

PON
VIEW - PON_BIDDERS_LISTS#

[top of page]

Table: PON_BIDDING_PARTIES

Description: Stores the parties participating in a negotiation.
Primary Key: PON_BIDDING_PARTIES_UK
  1. AUCTION_HEADER_ID
  2. LIST_ID
  3. TRADING_PARTNER_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_BIDDING_PARTIES does not reference any database object

PON.PON_BIDDING_PARTIES is referenced by following:

PON
VIEW - PON_BIDDING_PARTIES#

[top of page]

Table: PON_BID_ATTRIBUTE_VALUES

Description: Stores the attributes value of a line item which is part of a response to a negotiation.
Primary Key: PON_BID_ATTRIBUTE_VALUES_PK
  1. BID_NUMBER
  2. LINE_NUMBER
  3. ATTRIBUTE_NAME

[top of page]

PON.PON_BID_ATTRIBUTE_VALUES does not reference any database object

PON.PON_BID_ATTRIBUTE_VALUES is referenced by following:

PON
VIEW - PON_BID_ATTRIBUTE_VALUES#

[top of page]

Table: PON_BID_ATTR_VALUES_INTERFACE

Description: Temporary table that stores data of response attribute values uploaded from spreadsheet
Primary Key: PON_BID_ATTR_VALUES_INTERF_PK
  1. BATCH_ID
  2. LINE_NUMBER
  3. ATTRIBUTE_NAME

[top of page]

PON.PON_BID_ATTR_VALUES_INTERFACE does not reference any database object

PON.PON_BID_ATTR_VALUES_INTERFACE is referenced by following:

PON
VIEW - PON_BID_ATTR_VALUES_INTERFACE#

[top of page]

Table: PON_BID_HEADERS

Description: Contains header level data for a response to a negotiation
Primary Key: PON_BID_HEADERS_PK
  1. BID_NUMBER
Foreign Keys from this table:
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 Keys to this table:
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

[top of page]

PON.PON_BID_HEADERS does not reference any database object

PON.PON_BID_HEADERS is referenced by following:

PON
VIEW - PON_BID_HEADERS#

[top of page]

Table: PON_BID_HEADERS_ARCH

Description: No longer used.
Primary Key: PON_BID_HEADERS_ARCH_PK
  1. BID_NUMBER
  2. BID_REVISION_NUMBER

[top of page]

PON.PON_BID_HEADERS_ARCH does not reference any database object

PON.PON_BID_HEADERS_ARCH is referenced by following:

PON
VIEW - PON_BID_HEADERS_ARCH#

[top of page]

Table: PON_BID_HEADERS_INTERFACE

Description: Temporary table that contains the Bid Header details that have been imported or exported to to excel.

[top of page]

PON.PON_BID_HEADERS_INTERFACE does not reference any database object

PON.PON_BID_HEADERS_INTERFACE is referenced by following:

PON
VIEW - PON_BID_HEADERS_INTERFACE#

[top of page]

Table: PON_BID_ITEM_PRICES

Description: Contains information regarding the responses submitted by a supplier on a negotiation.
Primary Key: PON_BID_ITEM_PRICES_PK
  1. AUCTION_LINE_NUMBER
  2. BID_NUMBER
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column Foreign Table
PON_AWARD_ITEMS_INTERFACE.AUCTION_LINE_NUMBER
PON_AWARD_ITEMS_INTERFACE.BID_NUMBER 		PON_BID_ITEM_PRICES

[top of page]

PON.PON_BID_ITEM_PRICES does not reference any database object

PON.PON_BID_ITEM_PRICES is referenced by following:

PON
VIEW - PON_BID_ITEM_PRICES#

[top of page]

Table: PON_BID_ITEM_PRICES_INTERFACE

Description: PON_BID_ITEMS_PROCES_INTERFACE temporarily stores response information.

[top of page]

PON.PON_BID_ITEM_PRICES_INTERFACE does not reference any database object

PON.PON_BID_ITEM_PRICES_INTERFACE is referenced by following:

PON
VIEW - PON_BID_ITEM_PRICES_INTERFACE#

[top of page]

Table: PON_BID_ITEM_REFERENCES

Description: Contains information regarding the relation of Unsolcited Lines to Solicitation Lines done by a supplier.
Primary Key: PON_BID_ITEM_REFERENCES_PK
  1. AUCTION_HEADER_ID
  2. LINE_NUMBER
  3. LINK_TYPE
  4. LINK_DONE_BY
  5. BID_NUMBER
  6. AUCTION_LINE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_BID_ITEM_REFERENCES.AUCTION_LINE_NUMBER
PON_BID_ITEM_REFERENCES.AUCTION_HEADER_ID 		PON_AUCTION_ITEM_PRICES_ALL

[top of page]

PON.PON_BID_ITEM_REFERENCES does not reference any database object

PON.PON_BID_ITEM_REFERENCES is referenced by following:

PON
VIEW - PON_BID_ITEM_REFERENCES#

[top of page]

Table: PON_BID_PAYMENTS_INTERFACE

Description: Interface table to store imported information of the payments that are defined on a response to a negotiation for complex services.
Primary Key: PON_BID_PAYMENTS_INTERFACE_PK
  1. BATCH_ID
  2. INTERFACE_LINE_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_BID_PAYMENTS_INTERFACE does not reference any database object

PON.PON_BID_PAYMENTS_INTERFACE is referenced by following:

PON
VIEW - PON_BID_PAYMENTS_INTERFACE#

[top of page]

Table: PON_BID_PAYMENTS_SHIPMENTS

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.
Primary Key: PON_BID_PAYMENTS_SHIPMENTS_PK
  1. BID_PAYMENT_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column Foreign Table
PON_INTERFACE_ERRORS.BID_PAYMENT_ID PON_BID_PAYMENTS_SHIPMENTS

[top of page]

PON.PON_BID_PAYMENTS_SHIPMENTS does not reference any database object

PON.PON_BID_PAYMENTS_SHIPMENTS is referenced by following:

PON
VIEW - PON_BID_PAYMENTS_SHIPMENTS#

[top of page]

Table: PON_BID_PRICE_DIFFERENTIALS

Description: Response price differentials table
Primary Key: PON_BID_PRICE_DIFF_PK1
  1. BID_NUMBER
  2. LINE_NUMBER
  3. SHIPMENT_NUMBER
  4. PRICE_DIFFERENTIAL_NUMBER
Foreign Keys from this 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

[top of page]

PON.PON_BID_PRICE_DIFFERENTIALS does not reference any database object

PON.PON_BID_PRICE_DIFFERENTIALS is referenced by following:

PON
VIEW - PON_BID_PRICE_DIFFERENTIALS#

[top of page]

Table: PON_BID_PRICE_DIFFER_INT

Description: Temporary table that contains the response price differential details that have been imported or exported to to excel.

[top of page]

PON.PON_BID_PRICE_DIFFER_INT does not reference any database object

PON.PON_BID_PRICE_DIFFER_INT is referenced by following:

PON
VIEW - PON_BID_PRICE_DIFFER_INT#

[top of page]

Table: PON_BID_PRICE_ELEMENTS

Description: Stores price element bid details included in an auction or RFQ.
Primary Key: PON_BID_PRICE_ELEMENTS_PK1
  1. BID_NUMBER
  2. PRICE_ELEMENT_TYPE_ID
  3. LINE_NUMBER

[top of page]

PON.PON_BID_PRICE_ELEMENTS does not reference any database object

PON.PON_BID_PRICE_ELEMENTS is referenced by following:

PON
VIEW - PON_BID_PRICE_ELEMENTS#

[top of page]

Table: PON_BID_PRICE_ELEMENTS_INT

Description: Interface table for price element

[top of page]

PON.PON_BID_PRICE_ELEMENTS_INT does not reference any database object

PON.PON_BID_PRICE_ELEMENTS_INT is referenced by following:

PON
VIEW - PON_BID_PRICE_ELEMENTS_INT#

[top of page]

Table: PON_BID_REBATES

Description: This table is used to store rebates for a particular bid
Primary Key: PON_BID_REBATES_PK
  1. SEQUENCE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_BID_REBATES.BID_NUMBER PON_BID_HEADERS

[top of page]

PON.PON_BID_REBATES does not reference any database object

PON.PON_BID_REBATES is referenced by following:

PON
VIEW - PON_BID_REBATES#

[top of page]

Table: PON_BID_SHIPMENTS

Description: Contains the response details for an shipment in a negotiation
Primary Key: PON_BID_SHIPMENTS_PK1
  1. BID_NUMBER
  2. LINE_NUMBER
  3. SHIPMENT_NUMBER
Foreign Keys from this table:
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 Keys to this table:
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

[top of page]

PON.PON_BID_SHIPMENTS does not reference any database object

PON.PON_BID_SHIPMENTS is referenced by following:

PON
VIEW - PON_BID_SHIPMENTS#

[top of page]

Table: PON_BID_SHIPMENTS_INT

Description: Store tempory data for Price Breaks spreadsheet uploading.

[top of page]

PON.PON_BID_SHIPMENTS_INT does not reference any database object

PON.PON_BID_SHIPMENTS_INT is referenced by following:

PON
VIEW - PON_BID_SHIPMENTS_INT#

[top of page]

Table: PON_COLORS

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.
Primary Key: PON_COLORS_PK
  1. COLOR_ID

[top of page]

PON.PON_COLORS does not reference any database object

PON.PON_COLORS is referenced by following:

PON
VIEW - PON_COLORS#

[top of page]

Table: PON_CONTRACTS

Description: Stores the contract information such as Terms and Conditions that the negotiation owner would like a participant to accept.
Primary Key: PON_CONTRACTS_PK
  1. CONTRACT_ID
  2. VERSION_NUM
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_CONTRACTS.AUTHORING_PARTY_ID HZ_PARTIES
PON_CONTRACTS.AUTHORING_PARTY_CONTACT_ID HZ_PARTIES

[top of page]

PON.PON_CONTRACTS does not reference any database object

PON.PON_CONTRACTS is referenced by following:

PON
VIEW - PON_CONTRACTS#

[top of page]

Table: PON_CONTRACTS_TL

Description: Stores the contract information in each language
Primary Key: PON_CONTRACTS_TL_PK
  1. LANGUAGE
  2. VERSION_NUM
  3. CONTRACT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_CONTRACTS_TL.VERSION_NUM
PON_CONTRACTS_TL.CONTRACT_ID 		%

[top of page]

PON.PON_CONTRACTS_TL does not reference any database object

PON.PON_CONTRACTS_TL is referenced by following:

PON
VIEW - PON_CONTRACTS_TL#

[top of page]

Table: PON_DISCUSSIONS

Description: This is the driving table for discussions.
Primary Key: PON_DISCUSSIONS_PK
  1. DISCUSSION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_DISCUSSIONS.LANGUAGE_CODE FND_LANGUAGES
PON_DISCUSSIONS.OWNER_PARTY_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PON_THREADS.DISCUSSION_ID PON_DISCUSSIONS
PON_THREAD_ENTRIES.DISCUSSION_ID PON_DISCUSSIONS

[top of page]

PON.PON_DISCUSSIONS does not reference any database object

PON.PON_DISCUSSIONS is referenced by following:

PON
VIEW - PON_DISCUSSIONS#

[top of page]

Table: PON_DOCTYPE_STYLES

Description: This table stores whether a style is enabled for a document type.

[top of page]

PON.PON_DOCTYPE_STYLES does not reference any database object

PON.PON_DOCTYPE_STYLES is referenced by following:

PON
VIEW - PON_DOCTYPE_STYLES#

[top of page]

Table: PON_EMD_CORPORATE

Description:

[top of page]

PON.PON_EMD_CORPORATE does not reference any database object

PON.PON_EMD_CORPORATE is referenced by following:

PON
VIEW - PON_EMD_CORPORATE#

[top of page]

Table: PON_EMD_FIN_PARAMETERS_ALL

Description:
Primary Key: EMD_FIN_PARAMETERS_KEY
  1. EMD_FIN_PARAMETERS_ID

[top of page]

PON.PON_EMD_FIN_PARAMETERS_ALL does not reference any database object

PON.PON_EMD_FIN_PARAMETERS_ALL is referenced by following:

PON
VIEW - PON_EMD_FIN_PARAMETERS_ALL#

[top of page]

Table: PON_EMD_PAYMENT_TYPES_ALL

Description:
Primary Key: PON_EMD_PAYMENT_TYPES_PK1
  1. PAYMENT_TYPE_CODE
  2. ORG_ID

[top of page]

PON.PON_EMD_PAYMENT_TYPES_ALL does not reference any database object

PON.PON_EMD_PAYMENT_TYPES_ALL is referenced by following:

PON
VIEW - PON_EMD_PAYMENT_TYPES_ALL#

[top of page]

Table: PON_EMD_PAYMENT_TYPES_TL

Description:
Primary Key: PON_EMD_PAYMENT_TYPES_TL_PK1
  1. PAYMENT_TYPE_CODE
  2. ORG_ID
  3. LANGUAGE

[top of page]

PON.PON_EMD_PAYMENT_TYPES_TL does not reference any database object

PON.PON_EMD_PAYMENT_TYPES_TL is referenced by following:

PON
VIEW - PON_EMD_PAYMENT_TYPES_TL#

[top of page]

Table: PON_EMD_TRANSACTIONS

Description:
Primary Key: EMD_TRANSACTION_ID_PK1
  1. EMD_TRANSACTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID PON_AUCTION_HEADERS_ALL

[top of page]

PON.PON_EMD_TRANSACTIONS does not reference any database object

PON.PON_EMD_TRANSACTIONS is referenced by following:

PON
VIEW - PON_EMD_TRANSACTIONS#

[top of page]

Table: PON_EVALUATION_TEAMS

Description: Supplier Management project. RFI Evaluation Team table.

[top of page]

PON.PON_EVALUATION_TEAMS does not reference any database object

PON.PON_EVALUATION_TEAMS is referenced by following:

PON
VIEW - PON_EVALUATION_TEAMS#

[top of page]

Table: PON_EVALUATION_TEAM_MEMBERS

Description: Supplier Management project. Evaluation team members table.

[top of page]

PON.PON_EVALUATION_TEAM_MEMBERS does not reference any database object

PON.PON_EVALUATION_TEAM_MEMBERS is referenced by following:

PON
VIEW - PON_EVALUATION_TEAM_MEMBERS#

[top of page]

Table: PON_EVALUATION_TEAM_SECTIONS

Description: Supplier Management project. Evaluation team sections table.

[top of page]

PON.PON_EVALUATION_TEAM_SECTIONS does not reference any database object

PON.PON_EVALUATION_TEAM_SECTIONS is referenced by following:

PON
VIEW - PON_EVALUATION_TEAM_SECTIONS#

[top of page]

Table: PON_FBO_POSTS

Description: This will store history of notice posted to FedBizOpps

[top of page]

PON.PON_FBO_POSTS does not reference any database object

PON.PON_FBO_POSTS is referenced by following:

PON
VIEW - PON_FBO_POSTS#

[top of page]

Table: PON_FIELDS

Description: Stores information about a field.

[top of page]

PON.PON_FIELDS does not reference any database object

PON.PON_FIELDS is referenced by following:

PON
VIEW - PON_FIELDS#

[top of page]

Table: PON_FIELDS_TL

Description: Stores translatable information about a field.

[top of page]

PON.PON_FIELDS_TL does not reference any database object

PON.PON_FIELDS_TL is referenced by following:

PON
VIEW - PON_FIELDS_TL#

[top of page]

Table: PON_FORMS_INSTANCES

Description: Stores the relationship between the form and the negotiation/event.

[top of page]

PON.PON_FORMS_INSTANCES does not reference any database object

PON.PON_FORMS_INSTANCES is referenced by following:

PON
VIEW - PON_FORMS_INSTANCES#

[top of page]

Table: PON_FORMS_SECTIONS

Description: Store the header details for a form, section or abstract.

[top of page]

PON.PON_FORMS_SECTIONS does not reference any database object

PON.PON_FORMS_SECTIONS is referenced by following:

PON
VIEW - PON_FORMS_SECTIONS#

[top of page]

Table: PON_FORMS_SECTIONS_TL

Description: Stores the language specific information for a form, section or abstract.

[top of page]

PON.PON_FORMS_SECTIONS_TL does not reference any database object

PON.PON_FORMS_SECTIONS_TL is referenced by following:

PON
VIEW - PON_FORMS_SECTIONS_TL#

[top of page]

Table: PON_FORM_FIELD_VALUES

Description: Stores the form data.

[top of page]

PON.PON_FORM_FIELD_VALUES does not reference any database object

PON.PON_FORM_FIELD_VALUES is referenced by following:

PON
VIEW - PON_FORM_FIELD_VALUES#

[top of page]

Table: PON_FORM_SECTION_COMPILED

Description: Stored the "compiled form".

[top of page]

PON.PON_FORM_SECTION_COMPILED does not reference any database object

PON.PON_FORM_SECTION_COMPILED is referenced by following:

PON
VIEW - PON_FORM_SECTION_COMPILED#

[top of page]

Table: PON_FORM_SECTION_FIELDS

Description: Stores the relationships between a form, section or abstract and its components.

[top of page]

PON.PON_FORM_SECTION_FIELDS does not reference any database object

PON.PON_FORM_SECTION_FIELDS is referenced by following:

PON
VIEW - PON_FORM_SECTION_FIELDS#

[top of page]

Table: PON_FPJ_DELETED_ATTRIBUTES

Description: This table is used to store data from the attributes table that was deleted as part of the Minimun release upgrade

[top of page]

PON.PON_FPJ_DELETED_ATTRIBUTES does not reference any database object

PON.PON_FPJ_DELETED_ATTRIBUTES is referenced by following:

PON
VIEW - PON_FPJ_DELETED_ATTRIBUTES#

[top of page]

Table: PON_FPK_DELETED_PRICE_ELEMENTS

Description: This table stores information about the deleted unit price elements in FPK.

[top of page]

PON.PON_FPK_DELETED_PRICE_ELEMENTS does not reference any database object

PON.PON_FPK_DELETED_PRICE_ELEMENTS is referenced by following:

PON
VIEW - PON_FPK_DELETED_PRICE_ELEMENT#

[top of page]

Table: PON_INTERFACE_ERRORS

Description: Contains any errors from interfaces to other applications
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_INTERFACE_ERRORS.PAYMENT_ID PON_AUC_PAYMENTS_SHIPMENTS
PON_INTERFACE_ERRORS.BID_PAYMENT_ID PON_BID_PAYMENTS_SHIPMENTS

[top of page]

PON.PON_INTERFACE_ERRORS does not reference any database object

PON.PON_INTERFACE_ERRORS is referenced by following:

PON
VIEW - PON_INTERFACE_ERRORS#

[top of page]

Table: PON_ITEM_PRICES_INTERFACE

Description: Temporary table contains the item price details that have been imported or exported to to excel.
Foreign Keys from this table:
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

[top of page]

PON.PON_ITEM_PRICES_INTERFACE does not reference any database object

PON.PON_ITEM_PRICES_INTERFACE is referenced by following:

PON
VIEW - PON_ITEM_PRICES_INTERFACE#

[top of page]

Table: PON_LARGE_NEG_PF_VALUES

Description: This table stores the buyer price factor values for a given supplier for a large negotiation

[top of page]

PON.PON_LARGE_NEG_PF_VALUES does not reference any database object

PON.PON_LARGE_NEG_PF_VALUES is referenced by following:

PON
VIEW - PON_LARGE_NEG_PF_VALUES#

[top of page]

Table: PON_MNG_EVAL_BID_SECTIONS

Description: Supplier Management project. Table to track sections removed or added to evaluations after Manage Evaluation Teams.

[top of page]

PON.PON_MNG_EVAL_BID_SECTIONS does not reference any database object

PON.PON_MNG_EVAL_BID_SECTIONS is referenced by following:

PON
VIEW - PON_MNG_EVAL_BID_SECTIONS#

[top of page]

Table: PON_MNG_EVAL_TEAM_MEMBERS

Description: Supplier Management project. Table to track changes to team members after Manage Evaluation Teams.

[top of page]

PON.PON_MNG_EVAL_TEAM_MEMBERS does not reference any database object

PON.PON_MNG_EVAL_TEAM_MEMBERS is referenced by following:

PON
VIEW - PON_MNG_EVAL_TEAM_MEMBERS#

[top of page]

Table: PON_MNG_EVAL_TEAM_SECTIONS

Description: Supplier Management project. Table to track changes to team sections assignment after Manage Evaluation Teams.

[top of page]

PON.PON_MNG_EVAL_TEAM_SECTIONS does not reference any database object

PON.PON_MNG_EVAL_TEAM_SECTIONS is referenced by following:

PON
VIEW - PON_MNG_EVAL_TEAM_SECTIONS#

[top of page]

Table: PON_NEGOTIATION_STYLES

Description: This table stores negotiation style related information.

[top of page]

PON.PON_NEGOTIATION_STYLES does not reference any database object

PON.PON_NEGOTIATION_STYLES is referenced by following:

PON
VIEW - PON_NEGOTIATION_STYLES#

[top of page]

Table: PON_NEGOTIATION_STYLES_TL

Description: This table stores language specific negotiation style information.

[top of page]

PON.PON_NEGOTIATION_STYLES_TL does not reference any database object

PON.PON_NEGOTIATION_STYLES_TL is referenced by following:

PON
VIEW - PON_NEGOTIATION_STYLES_TL#

[top of page]

Table: PON_NEG_TEAM_MEMBERS

Description: Stores Collaboration Team member details included in a negotiation or template.
Primary Key: PON_NEG_TEAM_MEMBERS_U1
  1. AUCTION_HEADER_ID
  2. LIST_ID
  3. USER_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_NEG_TEAM_MEMBERS does not reference any database object

PON.PON_NEG_TEAM_MEMBERS is referenced by following:

PON
VIEW - PON_NEG_TEAM_MEMBERS#

[top of page]

Table: PON_NOTIF_GROUP_MEMBERS

Description: This table stores the individual notifications assigned to a particular group.

[top of page]

PON.PON_NOTIF_GROUP_MEMBERS does not reference any database object

PON.PON_NOTIF_GROUP_MEMBERS is referenced by following:

PON
VIEW - PON_NOTIF_GROUP_MEMBERS#

[top of page]

Table: PON_NOTIF_SUBSCRIPTION_GROUPS

Description: This table stores the notification subscription preferences for the sourcing instance.

[top of page]

PON.PON_NOTIF_SUBSCRIPTION_GROUPS does not reference any database object

PON.PON_NOTIF_SUBSCRIPTION_GROUPS is referenced by following:

PON
VIEW - PON_NOTIF_SUBSCRIPTION_GROUPS#

[top of page]

Table: PON_OPTIMIZE_BID_CLASS

Description: This table stores the suppliers for a particular constraint
Primary Key: PON_OPTIMIZE_BID_CLASS_PK1
  1. SCENARIO_ID
  2. SEQUENCE_NUMBER
  3. BID_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_OPTIMIZE_BID_CLASS.SCENARIO_ID PON_OPTIMIZE_SCENARIOS
PON_OPTIMIZE_BID_CLASS.BID_NUMBER PON_BID_HEADERS

[top of page]

PON.PON_OPTIMIZE_BID_CLASS does not reference any database object

PON.PON_OPTIMIZE_BID_CLASS is referenced by following:

PON
VIEW - PON_OPTIMIZE_BID_CLASS#

[top of page]

Table: PON_OPTIMIZE_CONSTRAINTS

Description: This table stores information about the user created constraints
Primary Key: PON_OPTIMIZE_CONSTRAINTS_PK1
  1. SCENARIO_ID
  2. SEQUENCE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_OPTIMIZE_CONSTRAINTS.SCENARIO_ID PON_OPTIMIZE_SCENARIOS
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

[top of page]

PON.PON_OPTIMIZE_CONSTRAINTS does not reference any database object

PON.PON_OPTIMIZE_CONSTRAINTS is referenced by following:

PON
VIEW - PON_OPTIMIZE_CONSTRAINTS#

[top of page]

Table: PON_OPTIMIZE_RESULTS

Description: This table stores information about the results of award optimization scenarios
Primary Key: PON_OPTIMIZE_RESULTS_PK1
  1. SCENARIO_ID
  2. BID_NUMBER
  3. LINE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_OPTIMIZE_RESULTS.SCENARIO_ID PON_OPTIMIZE_SCENARIOS
PON_OPTIMIZE_RESULTS.BID_NUMBER PON_BID_HEADERS

[top of page]

PON.PON_OPTIMIZE_RESULTS does not reference any database object

PON.PON_OPTIMIZE_RESULTS is referenced by following:

PON
VIEW - PON_OPTIMIZE_RESULTS#

[top of page]

Table: PON_OPTIMIZE_SCENARIOS

Description: This table stores information about the award optimization scenarios
Primary Key: PON_OPTIMIZE_SCENARIOS_PK1
  1. SCENARIO_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_OPTIMIZE_SCENARIOS.AUCTION_HEADER_ID PON_AUCTION_HEADERS_ALL
PON_OPTIMIZE_SCENARIOS.UPDATED_TP_CONTACT_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
PON_OPTIMIZE_BID_CLASS.SCENARIO_ID PON_OPTIMIZE_SCENARIOS
PON_OPTIMIZE_CONSTRAINTS.SCENARIO_ID PON_OPTIMIZE_SCENARIOS
PON_OPTIMIZE_RESULTS.SCENARIO_ID PON_OPTIMIZE_SCENARIOS

[top of page]

PON.PON_OPTIMIZE_SCENARIOS does not reference any database object

PON.PON_OPTIMIZE_SCENARIOS is referenced by following:

PON
VIEW - PON_OPTIMIZE_SCENARIOS#

[top of page]

Table: PON_ORCA_CERT_DETAILS

Description:

[top of page]

PON.PON_ORCA_CERT_DETAILS does not reference any database object

PON.PON_ORCA_CERT_DETAILS is referenced by following:

PON
VIEW - PON_ORCA_CERT_DETAILS#

[top of page]

Table: PON_PARTY_LINE_EXCLUSIONS

Description: Table stores negotiation line restrictions for a particular supplier/line combination
Primary Key: PON_PARY_LINE_EXCLUSIONS_U1
  1. AUCTION_HEADER_ID
  2. LINE_NUMBER
  3. SEQUENCE_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_PARTY_LINE_EXCLUSIONS.AUCTION_HEADER_ID PON_AUCTION_HEADERS_ALL

[top of page]

PON.PON_PARTY_LINE_EXCLUSIONS does not reference any database object

PON.PON_PARTY_LINE_EXCLUSIONS is referenced by following:

PON
VIEW - PON_PARTY_LINE_EXCLUSIONS#

[top of page]

Table: PON_PARTY_PREFERENCES

Description: Stores data for a party preferences within an application
Primary Key: POM_PARTY_PREFERENCES_PK
  1. PARTY_ID
  2. APP_SHORT_NAME
  3. PREFERENCE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_PARTY_PREFERENCES.PARTY_ID HZ_PARTIES
PON_PARTY_PREFERENCES.APP_SHORT_NAME FND_APPLICATION

[top of page]

PON.PON_PARTY_PREFERENCES does not reference any database object

PON.PON_PARTY_PREFERENCES is referenced by following:

PON
VIEW - PON_PARTY_PREFERENCES#

[top of page]

Table: PON_PF_SUPPLIER_FORMULA

Description: This table stores aggregated price factor values for a given supplier.

[top of page]

PON.PON_PF_SUPPLIER_FORMULA does not reference any database object

PON.PON_PF_SUPPLIER_FORMULA is referenced by following:

PON
VIEW - PON_PF_SUPPLIER_FORMULA#

[top of page]

Table: PON_PF_SUPPLIER_VALUES

Description: This table stores auction costfactor values for invited suppliers.

[top of page]

PON.PON_PF_SUPPLIER_VALUES does not reference any database object

PON.PON_PF_SUPPLIER_VALUES is referenced by following:

PON
VIEW - PON_PF_SUPPLIER_VALUES#

[top of page]

Table: PON_PRICE_DIFFERENTIALS

Description: Negotiation price differentials table
Primary Key: PON_PRICE_DIFFERENTIALS_PK1
  1. AUCTION_HEADER_ID
  2. LINE_NUMBER
  3. SHIPMENT_NUMBER
  4. PRICE_DIFFERENTIAL_NUMBER
Foreign Keys from this 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

[top of page]

PON.PON_PRICE_DIFFERENTIALS does not reference any database object

PON.PON_PRICE_DIFFERENTIALS is referenced by following:

PON
VIEW - PON_PRICE_DIFFERENTIALS#

[top of page]

Table: PON_PRICE_DIFFER_INTERFACE

Description: Interface table to store imported negotiation price differential information
Primary Key: PON_PRICE_DIFFER_INTERFACE_PK1
  1. INTERFACE_AUCTION_HEADER_ID
  2. INTERFACE_LINE_NUMBER
  3. INTERFACE_SHIPMENT_NUMBER
  4. INTERFACE_PRICE_DIFFER_NUMBER
Foreign Keys from this table:
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

[top of page]

PON.PON_PRICE_DIFFER_INTERFACE does not reference any database object

PON.PON_PRICE_DIFFER_INTERFACE is referenced by following:

PON
VIEW - PON_PRICE_DIFFER_INTERFACE#

[top of page]

Table: PON_PRICE_ELEMENTS

Description: Stores price element details included in an auction or RFQ.
Primary Key: PON_PRICE_ELEMENTS_U1
  1. AUCTION_HEADER_ID
  2. LINE_NUMBER
  3. PRICE_ELEMENT_TYPE_ID
  4. LIST_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_PRICE_ELEMENTS does not reference any database object

PON.PON_PRICE_ELEMENTS is referenced by following:

PON
VIEW - PON_PRICE_ELEMENTS#

[top of page]

Table: PON_PRICE_ELEMENT_LISTS

Description: Stores price element list details
Primary Key: PON_PRICE_ELEMENT_LISTS_PK
  1. LIST_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
PON_PRICE_ELEMENTS.LIST_ID PON_PRICE_ELEMENT_LISTS

[top of page]

PON.PON_PRICE_ELEMENT_LISTS does not reference any database object

PON.PON_PRICE_ELEMENT_LISTS is referenced by following:

PON
VIEW - PON_PRICE_ELEMENT_LISTS#

[top of page]

Table: PON_PRICE_ELEMENT_TYPES

Description: Stores price element type details
Primary Key: PON_PRICE_ELEMENT_TYPES_PK
  1. PRICE_ELEMENT_TYPE_ID
Foreign Keys to this table:
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
PO_RCV_CHARGES.COST_FACTOR_ID PON_PRICE_ELEMENT_TYPES
RCV_CHARGES_INTERFACE.COST_FACTOR_ID PON_PRICE_ELEMENT_TYPES

[top of page]

PON.PON_PRICE_ELEMENT_TYPES does not reference any database object

PON.PON_PRICE_ELEMENT_TYPES is referenced by following:

PON
VIEW - PON_PRICE_ELEMENT_TYPES#

[top of page]

Table: PON_PRICE_ELEMENT_TYPES_TL

Description: Stores price element type language details
Primary Key: PON_PRICE_ELEMENT_TYPES_TL_PK
  1. PRICE_ELEMENT_TYPE_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_PRICE_ELEMENT_TYPES_TL.PRICE_ELEMENT_TYPE_ID PON_PRICE_ELEMENT_TYPES

[top of page]

PON.PON_PRICE_ELEMENT_TYPES_TL does not reference any database object

PON.PON_PRICE_ELEMENT_TYPES_TL is referenced by following:

PON
VIEW - PON_PRICE_ELEMENT_TYPES_TL#

[top of page]

Table: PON_SAAS_NEGOTIATION_PO

Description:

[top of page]

PON.PON_SAAS_NEGOTIATION_PO does not reference any database object

PON.PON_SAAS_NEGOTIATION_PO is referenced by following:

PON
VIEW - PON_SAAS_NEGOTIATION_PO#

[top of page]

Table: PON_SAAS_PO_ATTACHMENTS

Description:

[top of page]

PON.PON_SAAS_PO_ATTACHMENTS does not reference any database object

PON.PON_SAAS_PO_ATTACHMENTS is referenced by following:

PON
VIEW - PON_SAAS_PO_ATTACHMENTS#

[top of page]

Table: PON_SCORING_TEAMS

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
Primary Key: PON_SCORING_TEAMS_PK
  1. TEAM_ID
Foreign Keys from this table:
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 Keys to this table:
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

[top of page]

PON.PON_SCORING_TEAMS does not reference any database object

PON.PON_SCORING_TEAMS is referenced by following:

PON
VIEW - PON_SCORING_TEAMS#

[top of page]

Table: PON_SCORING_TEAM_MEMBERS

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
Primary Key: PON_SCORING_TEAM_MEMBERS_PK
  1. TEAM_ID
  2. USER_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_SCORING_TEAM_MEMBERS does not reference any database object

PON.PON_SCORING_TEAM_MEMBERS is referenced by following:

PON
VIEW - PON_SCORING_TEAM_MEMBERS#

[top of page]

Table: PON_SCORING_TEAM_SECTIONS

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
Primary Key: PON_SCORING_TEAM_SECTIONS_PK
  1. AUCTION_HEADER_ID
  2. TEAM_ID
  3. SECTION_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_SCORING_TEAM_SECTIONS does not reference any database object

PON.PON_SCORING_TEAM_SECTIONS is referenced by following:

PON
VIEW - PON_SCORING_TEAM_SECTIONS#

[top of page]

Table: PON_SUPPLIER_ACCESS

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
Primary Key: PON_SUPPLIER_ACCESS_PK1
  1. AUCTION_HEADER_ID_ORIG_AMEND
  2. SUPPLIER_TRADING_PARTNER_ID
  3. LOCK_DATE
Foreign Keys from this table:
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

[top of page]

PON.PON_SUPPLIER_ACCESS does not reference any database object

PON.PON_SUPPLIER_ACCESS is referenced by following:

PON
VIEW - PON_SUPPLIER_ACCESS#

[top of page]

Table: PON_SUPPLIER_ACTIVITIES

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.
Primary Key: PON_SUPPLIER_ACTIVITIES_PK
  1. AUCTION_HEADER_ID_ORIG_AMEND
  2. TRADING_PARTNER_ID
  3. TRADING_PARTNER_CONTACT_ID
  4. LAST_ACTIVITY_TIME
  5. SESSION_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_SUPPLIER_ACTIVITIES does not reference any database object

PON.PON_SUPPLIER_ACTIVITIES is referenced by following:

PON
VIEW - PON_SUPPLIER_ACTIVITIES#

[top of page]

Table: PON_SUPPLIER_PROVIDERS

Description: PON_SUPPLIER_PROVIDERS stores details of supplier providers.
Primary Key: PON_SUPPLIER_PROVIDERS_PK
  1. PROVIDER_ID

[top of page]

PON.PON_SUPPLIER_PROVIDERS does not reference any database object

PON.PON_SUPPLIER_PROVIDERS is referenced by following:

PON
VIEW - PON_SUPPLIER_PROVIDERS#

[top of page]

Table: PON_TEAM_MEMBER_ATTR_SCORES

Description: This table records scores for every scoring team member for a given attribute and a response.
Primary Key: PON_TEAM_MEMBER_ATTR_SCORES_PK
  1. BID_NUMBER
  2. USER_ID
  3. ATTRIBUTE_SEQUENCE_NUMBER
Foreign Keys from this table:
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

[top of page]

PON.PON_TEAM_MEMBER_ATTR_SCORES does not reference any database object

PON.PON_TEAM_MEMBER_ATTR_SCORES is referenced by following:

PON
VIEW - PON_TEAM_MEMBER_ATTR_SCORES#

[top of page]

Table: PON_TEAM_MEMBER_BID_SCORES

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
Primary Key: PON_TEAM_MEMBER_BID_SCORES_PK
  1. BID_NUMBER
  2. USER_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_TEAM_MEMBER_BID_SCORES does not reference any database object

PON.PON_TEAM_MEMBER_BID_SCORES is referenced by following:

PON
VIEW - PON_TEAM_MEMBER_BID_SCORES#

[top of page]

Table: PON_TE_RECIPIENTS

Description: This table lists the recipient of the message.
Primary Key: PON_TE_RECIPIENTS_PK
  1. ENTRY_ID
  2. TO_ID
Foreign Keys from this table:
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

[top of page]

PON.PON_TE_RECIPIENTS does not reference any database object

PON.PON_TE_RECIPIENTS is referenced by following:

PON
VIEW - PON_TE_RECIPIENTS#

[top of page]

Table: PON_TE_VIEW_AUDIT

Description: A simple table keeping track of who viewed which message when.
Primary Key: PON_TE_VIEW_AUDIT_PK
  1. ENTRY_ID
  2. VIEWER_PARTY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
PON_TE_VIEW_AUDIT.ENTRY_ID PON_THREAD_ENTRIES
PON_TE_VIEW_AUDIT.VIEWER_PARTY_ID HZ_PARTIES

[top of page]

PON.PON_TE_VIEW_AUDIT does not reference any database object

PON.PON_TE_VIEW_AUDIT is referenced by following:

PON
VIEW - PON_TE_VIEW_AUDIT#

[top of page]

Table: PON_THREADS

Description: This identifies simple metadata for the thread.
Primary Key: PON_THREADS_PK
  1. DISCUSSION_ID
  2. THREAD_NUMBER
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column Foreign Table
PON_THREAD_ENTRIES.DISCUSSION_ID
PON_THREAD_ENTRIES.THREAD_NUMBER 		PON_THREADS

[top of page]

PON.PON_THREADS does not reference any database object

PON.PON_THREADS is referenced by following:

PON
VIEW - PON_THREADS#

[top of page]

Table: PON_THREAD_ENTRIES

Description: Stores message content for threaded discussions
Primary Key: PON_THREAD_ENTRIES_PK
  1. ENTRY_ID
Foreign Keys from this table:
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 Keys to this table:
Foreign Key Column Foreign Table
PON_TE_RECIPIENTS.ENTRY_ID PON_THREAD_ENTRIES
PON_TE_VIEW_AUDIT.ENTRY_ID PON_THREAD_ENTRIES

[top of page]

PON.PON_THREAD_ENTRIES does not reference any database object

PON.PON_THREAD_ENTRIES is referenced by following:

PON
VIEW - PON_THREAD_ENTRIES#

[top of page]

Table: PON_UMBRELLA_PROGRAMS

Description:
Primary Key: PON_UMBRELLA_PROGRAMS_PK
  1. UMBRELLA_PROGRAM_ID

[top of page]

PON.PON_UMBRELLA_PROGRAMS does not reference any database object

PON.PON_UMBRELLA_PROGRAMS is referenced by following:

PON
VIEW - PON_UMBRELLA_PROGRAMS#

[top of page]

Table: PON_WF_DEBUG

Description: Holds the debug statements for workflow processes

[top of page]

PON.PON_WF_DEBUG does not reference any database object

PON.PON_WF_DEBUG is referenced by following:

PON
VIEW - PON_WF_DEBUG#

[top of page]

View: PON_AUCTION_HEADERS_ALL_V

[top of page]

APPS.PON_AUCTION_HEADERS_ALL_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HZ_PARTIES
SYNONYM - PON_AUCTION_HEADERS_ALL
PACKAGE - PON_LOCALE_PKG

APPS.PON_AUCTION_HEADERS_ALL_V is not referenced by any database object

[top of page]

View: PON_AUCTION_HEADERS_V

[top of page]

APPS.PON_AUCTION_HEADERS_V references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HZ_PARTIES
SYNONYM - PON_AUCTION_HEADERS
PACKAGE - PON_LOCALE_PKG

APPS.PON_AUCTION_HEADERS_V is not referenced by any database object

[top of page]

View: PON_AUC_NOTIF_DELIV_V

[top of page]

APPS.PON_AUC_NOTIF_DELIV_V references the following:

APPS
SYNONYM - PON_AUCTION_HEADERS_ALL
SYNONYM - PON_BID_HEADERS

APPS.PON_AUC_NOTIF_DELIV_V is not referenced by any database object

[top of page]

View: PON_BUYER_MANAGE_DELIV_V

[top of page]

APPS.PON_BUYER_MANAGE_DELIV_V references the following:

APPS
SYNONYM - FND_COMPILED_MENU_FUNCTIONS
SYNONYM - FND_FORM_FUNCTIONS
SYNONYM - FND_MENUS
SYNONYM - FND_USER
SYNONYM - HZ_CODE_ASSIGNMENTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - PON_AUCTION_HEADERS_ALL
SYNONYM - PON_BID_HEADERS
SYNONYM - PON_NEG_TEAM_MEMBERS

APPS.PON_BUYER_MANAGE_DELIV_V is not referenced by any database object

[top of page]

View: PON_COST_FACTORS_VL

[top of page]

APPS.PON_COST_FACTORS_VL references the following:

APPS
SYNONYM - PON_PRICE_ELEMENT_TYPES
SYNONYM - PON_PRICE_ELEMENT_TYPES_TL

APPS.PON_COST_FACTORS_VL is not referenced by any database object

[top of page]

View: PON_EMD_PAYMENT_TYPES_VL

[top of page]

APPS.PON_EMD_PAYMENT_TYPES_VL references the following:

APPS
SYNONYM - PON_EMD_PAYMENT_TYPES_ALL
SYNONYM - PON_EMD_PAYMENT_TYPES_TL

APPS.PON_EMD_PAYMENT_TYPES_VL is not referenced by any database object

[top of page]

View: PON_EMPLOYEES_CURRENT_V

[top of page]

APPS.PON_EMPLOYEES_CURRENT_V references the following:

APPS
PACKAGE - HR_SECURITY
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_ALL_POSITIONS
SYNONYM - PER_JOBS
SYNONYM - PER_PERIODS_OF_PLACEMENT
SYNONYM - PER_PERIODS_OF_SERVICE
SYNONYM - PER_PHONES

APPS.PON_EMPLOYEES_CURRENT_V is not referenced by any database object

[top of page]

View: PON_MI_AUCTIONSUMMARY_V

[top of page]

APPS.PON_MI_AUCTIONSUMMARY_V references the following:

- PON_MI_AUC_BUYERAUC_V

APPS.PON_MI_AUCTIONSUMMARY_V is not referenced by any database object

[top of page]

View: PON_MI_AUC_BUYERAUC_V

[top of page]

APPS.PON_MI_AUC_BUYERAUC_V references the following:

APPS
SYNONYM - PON_AUCTION_HEADERS
SYNONYM - PON_AUC_DOCTYPES
SYNONYM - PON_BID_HEADERS
SYNONYM - PON_BID_ITEM_PRICES

APPS.PON_MI_AUC_BUYERAUC_V is not referenced by any database object

[top of page]

View: PON_MI_AUC_RFQ_V

[top of page]

APPS.PON_MI_AUC_RFQ_V references the following:

APPS
SYNONYM - PON_AUCTION_HEADERS
SYNONYM - PON_AUC_DOCTYPES
SYNONYM - PON_BID_HEADERS
SYNONYM - PON_BID_ITEM_PRICES
APPS.PON_MI_AUC_RFQ_V is referenced by following:

APPS
VIEW - PON_MI_RFQSUMMARY_V

[top of page]

View: PON_MI_AUC_SAVINGS_V

[top of page]

APPS.PON_MI_AUC_SAVINGS_V references the following:

APPS
SYNONYM - PON_AUCTION_HEADERS
SYNONYM - PON_AUCTION_ITEM_PRICES_ALL
SYNONYM - PON_AUC_DOCTYPES
SYNONYM - PON_BID_HEADERS
SYNONYM - PON_BID_ITEM_PRICES

APPS.PON_MI_AUC_SAVINGS_V is not referenced by any database object

[top of page]

View: PON_MI_RFQSUMMARY_V

[top of page]

APPS.PON_MI_RFQSUMMARY_V references the following:

APPS
VIEW - PON_MI_AUC_RFQ_V

APPS.PON_MI_RFQSUMMARY_V is not referenced by any database object

[top of page]

View: PON_NEGOTIATION_STYLES_VL

[top of page]

APPS.PON_NEGOTIATION_STYLES_VL references the following:

APPS
SYNONYM - PON_NEGOTIATION_STYLES
SYNONYM - PON_NEGOTIATION_STYLES_TL

APPS.PON_NEGOTIATION_STYLES_VL is not referenced by any database object

[top of page]

View: PON_PRICE_ELEMENT_TYPES_VL

[top of page]

APPS.PON_PRICE_ELEMENT_TYPES_VL references the following:

APPS
SYNONYM - PON_PRICE_ELEMENT_TYPES
SYNONYM - PON_PRICE_ELEMENT_TYPES_TL

APPS.PON_PRICE_ELEMENT_TYPES_VL is not referenced by any database object

[top of page]

View: PON_SUPPLIER_MANAGE_DELIV_V

[top of page]

APPS.PON_SUPPLIER_MANAGE_DELIV_V references the following:

APPS
SYNONYM - FND_USER
SYNONYM - PON_AUCTION_HEADERS_ALL
SYNONYM - PON_BID_HEADERS

APPS.PON_SUPPLIER_MANAGE_DELIV_V is not referenced by any database object

[top of page]

View: PON_SYSTEM_FIELDS_VALUES_V

[top of page]

APPS.PON_SYSTEM_FIELDS_VALUES_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
VIEW - HR_LEGAL_ENTITIES
PACKAGE - HR_SECURITY
VIEW - PER_BUSINESS_GROUPS
SYNONYM - PON_AUCTION_HEADERS_ALL
SYNONYM - PON_AUC_DOCTYPES
SYNONYM - PON_AUC_DOCTYPES_TL
PACKAGE - PON_CONTERMS_UTL_PVT
PACKAGE - PON_FORMS_UTIL_PVT
PACKAGE - PON_LOCALE_PKG
- AP_TERMS_VL

APPS.PON_SYSTEM_FIELDS_VALUES_V is not referenced by any database object

[top of page]

View: PON_VALID_NEG_STYLES_V

[top of page]

APPS.PON_VALID_NEG_STYLES_V references the following:

APPS
SYNONYM - PON_AUC_DOCTYPES
SYNONYM - PON_DOCTYPE_STYLES
SYNONYM - PON_NEGOTIATION_STYLES
SYNONYM - PON_NEGOTIATION_STYLES_TL

APPS.PON_VALID_NEG_STYLES_V is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract