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 - POS Tables and Views

TABLE - POS.POS_ACCT_ADDR_REL
TABLE - POS.POS_ACNT_ADDR_REQ
TABLE - POS.POS_ACNT_ADDR_SUMM_REQ
TABLE - POS.POS_ACNT_GEN_REQ
TABLE - POS.POS_ACNT_PAY_PREF
TABLE - POS.POS_ADDRESS_NOTES
TABLE - POS.POS_ADDRESS_REQUESTS
TABLE - POS.POS_ADDRESS_UPGRADE
TABLE - POS.POS_ASN_LOAD
TABLE - POS.POS_ATTRPG_CONFIG
TABLE - POS.POS_BANK_ACCNT_OWNERS_INT
TABLE - POS.POS_BANK_ACCOUNT_DET_INT
TABLE - POS.POS_BUSINESS_CLASS_INT
TABLE - POS.POS_BUS_CLASS_ATTR
TABLE - POS.POS_BUS_CLASS_REQS
TABLE - POS.POS_CAPACITY_TOLERANCE_TEMP
TABLE - POS.POS_CONTACT_REQUESTS
TABLE - POS.POS_CONTACT_UPGRADE
TABLE - POS.POS_CONT_ADDR_REQUESTS
TABLE - POS.POS_FISCAL_CLASS_INT
TABLE - POS.POS_IMP_BATCH_SUMMARY
TABLE - POS.POS_MFG_CAPACITY_TEMP
TABLE - POS.POS_ORDER_MODIFIERS_TEMP
TABLE - POS.POS_ORG_HASH
TABLE - POS.POS_OSN_ASSOCIATIONS
TABLE - POS.POS_OSN_REQUESTS
TABLE - POS.POS_PARTY_TAX_PROFILE_INT
TABLE - POS.POS_PARTY_TAX_REG_INT
TABLE - APPS.POS_PRODUCTS_SERVICES_GT
TABLE - POS.POS_PRODUCT_SERVICE_INT
TABLE - POS.POS_PRODUCT_SERVICE_REQUESTS
TABLE - POS.POS_PROMPTS
TABLE - POS.POS_RFI_TEMPLATE_CONFIG
TABLE - POS.POS_SPMNTF_SUBSCRIPTION
TABLE - POS.POS_SUPPLIER_INT_REJECTIONS
TABLE - POS.POS_SUPPLIER_MAPPINGS
TABLE - POS.POS_SUPPLIER_REGISTRATIONS
TABLE - POS.POS_SUPPLIER_UDA_MERGE_GTT
TABLE - POS.POS_SUPP_GENERATE_XML_RPT
TABLE - POS.POS_SUPP_PROF_EXT_B
TABLE - POS.POS_SUPP_PROF_EXT_INTF
TABLE - POS.POS_SUPP_PROF_EXT_TL
TABLE - POS.POS_SUPP_PUB_HISTORY
TABLE - POS.POS_SUPP_PUB_RESPONSES
TABLE - POS.POS_SUP_BANK_ACCOUNT_REQUESTS
TABLE - POS.POS_SUP_ONBOARD_CONFIG
TABLE - POS.POS_SUP_PRODUCTS_SERVICES
TABLE - POS.POS_SURVEY_CONFIG
TABLE - POS.POS_SURVEY_TRANSACTIONS
TABLE - POS.POS_UPGRADE_USERS
TABLE - POS.POS_VENDOR_UPG_TMP
VIEW - APPS.POS_AP_CHECKS_V
VIEW - APPS.POS_AP_INVOICES_V
VIEW - APPS.POS_AP_INVOICE_PAYMENTS_V
VIEW - APPS.POS_ASN_VIEW_FOR_SEARCH
VIEW - APPS.POS_BILL_ONLY_ORDERS_V
VIEW - APPS.POS_BLANKET_AGREE_V
VIEW - APPS.POS_CHV_AUTHORIZATIONS_V
VIEW - APPS.POS_CHV_ITEM_ORDERS_V
VIEW - APPS.POS_CHV_SCHEDULE_HEADERS_V
VIEW - APPS.POS_CHV_SCHEDULE_ITEMS_V
VIEW - APPS.POS_CONSIGNED_SHIPMENTS_V
VIEW - APPS.POS_DISTRIBUTIONS_V
VIEW - APPS.POS_HEADERS_V
VIEW - APPS.POS_HORIZONTAL_SCHEDULE_V
VIEW - APPS.POS_LINES_V
VIEW - APPS.POS_MTL_ONHAND_ITEMS_DMMY_V
VIEW - APPS.POS_MTL_ONHAND_ITEMS_KFV
VIEW - APPS.POS_MTL_ONHAND_LOCATOR_KFV
VIEW - APPS.POS_MTL_ONHAND_LOT_KFV
VIEW - APPS.POS_MTL_ONHAND_REV_KFV
VIEW - APPS.POS_MTL_ONHAND_SERIAL_KFV
VIEW - APPS.POS_MTL_ONHAND_SUB_KFV
VIEW - APPS.POS_ORDER_SUMMARY_V
VIEW - APPS.POS_ORD_MODIFIERS_V
VIEW - APPS.POS_ORG_ADDRESS_V
VIEW - APPS.POS_PARTIES_V
VIEW - APPS.POS_PARTY_SITES_V
VIEW - APPS.POS_PER_PEOPLE_X_V
VIEW - APPS.POS_PLAN_SCHEDULE_HEADERS_V
VIEW - APPS.POS_PO_ARCH_SUMMARY_V
VIEW - APPS.POS_PO_DETAILS_V
VIEW - APPS.POS_PO_EMPLOYEE_DETAILS_V
VIEW - APPS.POS_PO_EXPECTED_RECEIPTS_V
VIEW - APPS.POS_PO_HEADERS_ARCHIVE_V
VIEW - APPS.POS_PO_INVOICE_SUP_ORDERS_V
VIEW - APPS.POS_PO_LATE_RECEIPTS_V
VIEW - APPS.POS_PO_LINES_ARCHIVE_V
VIEW - APPS.POS_PO_LINES_V
VIEW - APPS.POS_PO_LIST_USERS_V
VIEW - APPS.POS_PO_LOCATION_DETAIL_V
VIEW - APPS.POS_PO_OSP_V
VIEW - APPS.POS_PO_QA_SHIPMENTS_V
VIEW - APPS.POS_PO_REVISIONS_HEADER_V
VIEW - APPS.POS_PO_REVISIONS_LINE_V
VIEW - APPS.POS_PO_REVISIONS_TEMP_V
VIEW - APPS.POS_PO_RFQ_HEADERS_V
VIEW - APPS.POS_PO_RFQ_LINES_V
VIEW - APPS.POS_PO_SUMMARY_V
VIEW - APPS.POS_PO_SUPPLIER_AGREEMENTS_V
VIEW - APPS.POS_PO_SUPPLIER_INFO_V
VIEW - APPS.POS_PO_SUPPLIER_ITEMS_V
VIEW - APPS.POS_PO_SUPPLIER_ORDERS_V
VIEW - APPS.POS_PO_USER_DETAILS_V
VIEW - APPS.POS_PO_VENDORS_V
VIEW - APPS.POS_RCV_EARLY_LATE_RECEIPTS_V
VIEW - APPS.POS_RCV_REJECTED_ITEMS_V
VIEW - APPS.POS_RCV_RETURNS_V
VIEW - APPS.POS_RCV_TRANSACTIONS_V
VIEW - APPS.POS_RECEIPT_HEADERS_V
VIEW - APPS.POS_SHIPMENTS_V
VIEW - APPS.POS_SHIP_SCHEDULE_HEADERS_V
VIEW - APPS.POS_SUPPLIER_USERS_V
VIEW - APPS.POS_SUPP_AGREEMENTS_V
VIEW - APPS.POS_SUPP_PROF_EXT_OCV
VIEW - APPS.POS_SUPP_PROF_EXT_VL
VIEW - APPS.POS_SUPP_PUB_HISTORY_V
VIEW - APPS.POS_SUP_AP_BANK_ACCOUNTS_V
VIEW - APPS.POS_VIEW_ASN
VIEW - APPS.POS_VIEW_PO_SUMMARY_V

Table: POS_ACCT_ADDR_REL

Description: Supplier bank account and address assignments
Primary Key: POS_ACCT_ADDR_REL_PK
  1. RELATIONSHIP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_ACCT_ADDR_REL.BANK_BRANCH_ID AP_BANK_BRANCHES
POS_ACCT_ADDR_REL.CURRENCY_CODE FND_CURRENCIES
POS_ACCT_ADDR_REL.REQUEST_ID POS_SUP_BANK_ACCOUNT_REQUESTS
POS_ACCT_ADDR_REL.ADDRESS_ID HZ_PARTY_SITES

[top of page]

POS.POS_ACCT_ADDR_REL does not reference any database object

POS.POS_ACCT_ADDR_REL is referenced by following:

POS
VIEW - POS_ACCT_ADDR_REL#

[top of page]

Table: POS_ACNT_ADDR_REQ

Description: Table for supplier bank account and address assignment requests
Primary Key: POS_ACNT_ADDR_REQ_PK
  1. ASSIGNMENT_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_ACNT_ADDR_REQ.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_ACNT_ADDR_REQ.ADDRESS_REQUEST_ID POS_ADDRESS_REQUESTS
POS_ACNT_ADDR_REQ.PARTY_SITE_ID HZ_PARTY_SITES
Foreign Keys to this table:
Foreign Key Column Foreign Table
POS_ACNT_ADDR_SUMM_REQ.ASSIGNMENT_REQUEST_ID POS_ACNT_ADDR_REQ

[top of page]

POS.POS_ACNT_ADDR_REQ does not reference any database object

POS.POS_ACNT_ADDR_REQ is referenced by following:

POS
VIEW - POS_ACNT_ADDR_REQ#

[top of page]

Table: POS_ACNT_ADDR_SUMM_REQ

Description: This table stores the details of supplier bank account and address assignment requests.
Primary Key: POS_ACNT_ADDR_SUMM_REQ_PK
  1. ASSIGNMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_ACNT_ADDR_SUMM_REQ.EXT_BANK_ACCOUNT_ID IBY_EXT_BANK_ACCOUNTS
POS_ACNT_ADDR_SUMM_REQ.ASSIGNMENT_REQUEST_ID POS_ACNT_ADDR_REQ

[top of page]

POS.POS_ACNT_ADDR_SUMM_REQ does not reference any database object

POS.POS_ACNT_ADDR_SUMM_REQ is referenced by following:

POS
VIEW - POS_ACNT_ADDR_SUMM_REQ#

[top of page]

Table: POS_ACNT_GEN_REQ

Description: Table for supplier bank account requests
Primary Key: PAQ_PK
  1. ACCOUNT_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_ACNT_GEN_REQ.MAPPING_ID POS_SUPPLIER_MAPPINGS

[top of page]

POS.POS_ACNT_GEN_REQ does not reference any database object

POS.POS_ACNT_GEN_REQ is referenced by following:

POS
VIEW - POS_ACNT_GEN_REQ#

[top of page]

Table: POS_ACNT_PAY_PREF

Description: This table stores the payment preferences of suppliers for their addresses.
Primary Key: PAF_PK
  1. PAYMENT_PREFERENCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_ACNT_PAY_PREF.PARTY_ID HZ_PARTIES
POS_ACNT_PAY_PREF.PARTY_SITE_ID HZ_PARTY_SITES

[top of page]

POS.POS_ACNT_PAY_PREF does not reference any database object

POS.POS_ACNT_PAY_PREF is referenced by following:

POS
VIEW - POS_ACNT_PAY_PREF#

[top of page]

Table: POS_ADDRESS_NOTES

Description: Notes for supplier addresses
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_ADDRESS_NOTES.ADDRESS_REQ_ID POS_ADDRESS_REQUESTS
POS_ADDRESS_NOTES.PARTY_SITE_ID HZ_PARTY_SITES

[top of page]

POS.POS_ADDRESS_NOTES does not reference any database object

POS.POS_ADDRESS_NOTES is referenced by following:

POS
VIEW - POS_ADDRESS_NOTES#

[top of page]

Table: POS_ADDRESS_REQUESTS

Description: Supplier Address Requests
Primary Key: POS_ADDRESS_REQUEST_PK
  1. ADDRESS_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_ADDRESS_REQUESTS.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_ADDRESS_REQUESTS.PARTY_SITE_ID HZ_PARTY_SITES
Foreign Keys to this table:
Foreign Key Column Foreign Table
POS_ACNT_ADDR_REQ.ADDRESS_REQUEST_ID POS_ADDRESS_REQUESTS
POS_ADDRESS_NOTES.ADDRESS_REQ_ID POS_ADDRESS_REQUESTS
POS_CONT_ADDR_REQUESTS.ADDRESS_REQ_ID POS_ADDRESS_REQUESTS

[top of page]

POS.POS_ADDRESS_REQUESTS does not reference any database object

POS.POS_ADDRESS_REQUESTS is referenced by following:

POS
VIEW - POS_ADDRESS_REQUESTS#

[top of page]

Table: POS_ADDRESS_UPGRADE

Description: Supplier address upgrade staging table

[top of page]

POS.POS_ADDRESS_UPGRADE does not reference any database object

POS.POS_ADDRESS_UPGRADE is referenced by following:

POS
VIEW - POS_ADDRESS_UPGRADE#

[top of page]

Table: POS_ASN_LOAD

Description: This table will record ALL upload Excel ASN requests

[top of page]

POS.POS_ASN_LOAD does not reference any database object

POS.POS_ASN_LOAD is referenced by following:

POS
VIEW - POS_ASN_LOAD#

[top of page]

Table: POS_ATTRPG_CONFIG

Description: Supplier Data Hub project. Used to store RFI template association to operating unit during onboarding configuration.

[top of page]

POS.POS_ATTRPG_CONFIG does not reference any database object

POS.POS_ATTRPG_CONFIG is referenced by following:

POS
VIEW - POS_ATTRPG_CONFIG#

[top of page]

Table: POS_BANK_ACCNT_OWNERS_INT

Description:

[top of page]

POS.POS_BANK_ACCNT_OWNERS_INT does not reference any database object

POS.POS_BANK_ACCNT_OWNERS_INT is referenced by following:

POS
VIEW - POS_BANK_ACCNT_OWNERS_INT#

[top of page]

Table: POS_BANK_ACCOUNT_DET_INT

Description:

[top of page]

POS.POS_BANK_ACCOUNT_DET_INT does not reference any database object

POS.POS_BANK_ACCOUNT_DET_INT is referenced by following:

POS
VIEW - POS_BANK_ACCOUNT_DET_INT#

[top of page]

Table: POS_BUSINESS_CLASS_INT

Description:

[top of page]

POS.POS_BUSINESS_CLASS_INT does not reference any database object

POS.POS_BUSINESS_CLASS_INT is referenced by following:

POS
VIEW - POS_BUSINESS_CLASS_INT#

[top of page]

Table: POS_BUS_CLASS_ATTR

Description: Supplier Business Classification Attributes
Primary Key: POS_BUS_CLASS_ATTR_PK1
  1. CLASSIFICATION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_BUS_CLASS_ATTR.PARTY_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
POS_BUS_CLASS_REQS.CLASSIFICATION_ID POS_BUS_CLASS_ATTR

[top of page]

POS.POS_BUS_CLASS_ATTR does not reference any database object

POS.POS_BUS_CLASS_ATTR is referenced by following:

POS
VIEW - POS_BUS_CLASS_ATTR#

[top of page]

Table: POS_BUS_CLASS_REQS

Description: Business Classification Requests for Suppliers
Primary Key: POS_BUS_CLASS_REQUEST_PK
  1. BUS_CLASS_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_BUS_CLASS_REQS.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_BUS_CLASS_REQS.CLASSIFICATION_ID POS_BUS_CLASS_ATTR

[top of page]

POS.POS_BUS_CLASS_REQS does not reference any database object

POS.POS_BUS_CLASS_REQS is referenced by following:

POS
VIEW - POS_BUS_CLASS_REQS#

[top of page]

Table: POS_CAPACITY_TOLERANCE_TEMP

Description: This Table is used to Store Cange in Capacity Tolerance Orders
Primary Key: POS_CAP_TMP_PK
  1. CAPACITY_TOLERANCE_ID

[top of page]

POS.POS_CAPACITY_TOLERANCE_TEMP does not reference any database object

POS.POS_CAPACITY_TOLERANCE_TEMP is referenced by following:

POS
VIEW - POS_CAPACITY_TOLERANCE_TEMP#

[top of page]

Table: POS_CONTACT_REQUESTS

Description: Supplier Contact Requests
Primary Key: POS_CONTACT_REQUEST_PK
  1. CONTACT_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_CONTACT_REQUESTS.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_CONTACT_REQUESTS.CONTACT_PARTY_ID HZ_PARTIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
POS_CONT_ADDR_REQUESTS.CONTACT_REQ_ID POS_CONTACT_REQUESTS

[top of page]

POS.POS_CONTACT_REQUESTS does not reference any database object

POS.POS_CONTACT_REQUESTS is referenced by following:

POS
VIEW - POS_CONTACT_REQUESTS#

[top of page]

Table: POS_CONTACT_UPGRADE

Description: Supplier contact upgrade staging table

[top of page]

POS.POS_CONTACT_UPGRADE does not reference any database object

POS.POS_CONTACT_UPGRADE is referenced by following:

POS
VIEW - POS_CONTACT_UPGRADE#

[top of page]

Table: POS_CONT_ADDR_REQUESTS

Description: Requests for supplier contact and address links
Primary Key: POS_CONT_ADDR_REQUEST_PK
  1. CONT_ADDR_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_CONT_ADDR_REQUESTS.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_CONT_ADDR_REQUESTS.CONTACT_PARTY_ID HZ_PARTIES
POS_CONT_ADDR_REQUESTS.CONTACT_REQ_ID POS_CONTACT_REQUESTS
POS_CONT_ADDR_REQUESTS.PARTY_SITE_ID HZ_PARTY_SITES
POS_CONT_ADDR_REQUESTS.ADDRESS_REQ_ID POS_ADDRESS_REQUESTS

[top of page]

POS.POS_CONT_ADDR_REQUESTS does not reference any database object

POS.POS_CONT_ADDR_REQUESTS is referenced by following:

POS
VIEW - POS_CONT_ADDR_REQUESTS#

[top of page]

Table: POS_FISCAL_CLASS_INT

Description:

[top of page]

POS.POS_FISCAL_CLASS_INT does not reference any database object

POS.POS_FISCAL_CLASS_INT is referenced by following:

POS
VIEW - POS_FISCAL_CLASS_INT#

[top of page]

Table: POS_IMP_BATCH_SUMMARY

Description:

[top of page]

POS.POS_IMP_BATCH_SUMMARY does not reference any database object

POS.POS_IMP_BATCH_SUMMARY is referenced by following:

POS
VIEW - POS_IMP_BATCH_SUMMARY#

[top of page]

Table: POS_MFG_CAPACITY_TEMP

Description: This Table is used to Store Cange in Capacity for Orders
Primary Key: POS_MFG_TMP_PK
  1. MFG_CAPACITY_ID

[top of page]

POS.POS_MFG_CAPACITY_TEMP does not reference any database object

POS.POS_MFG_CAPACITY_TEMP is referenced by following:

POS
VIEW - POS_MFG_CAPACITY_TEMP#

[top of page]

Table: POS_ORDER_MODIFIERS_TEMP

Description: This table is used to store the order modifier request
Primary Key: POS_ORDTMP_PK
  1. ORDER_MOD_REQUEST_ID

[top of page]

POS.POS_ORDER_MODIFIERS_TEMP does not reference any database object

POS.POS_ORDER_MODIFIERS_TEMP is referenced by following:

POS
VIEW - POS_ORDER_MODIFIERS_TEMP#

[top of page]

Table: POS_ORG_HASH

Description: Hash keys for operating unit identifier
Primary Key: POS_ORG_HASH_PK
  1. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_ORG_HASH.ORG_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

POS.POS_ORG_HASH does not reference any database object

POS.POS_ORG_HASH is referenced by following:

POS
VIEW - POS_ORG_HASH#

[top of page]

Table: POS_OSN_ASSOCIATIONS

Description: Table for storing the association between Oracle Supplier Network trading partners and the iSP vendors
Primary Key: POS_OSN_ASSOCIATIONS_PK
  1. OSN_EHUB_ID

[top of page]

POS.POS_OSN_ASSOCIATIONS does not reference any database object

POS.POS_OSN_ASSOCIATIONS is referenced by following:

POS
VIEW - POS_OSN_ASSOCIATIONS#

[top of page]

Table: POS_OSN_REQUESTS

Description: Table for storing inbound requests from Oracle Supplier Network
Primary Key: POS_OSN_REQUESTS_PK
  1. INTERNAL_ID

[top of page]

POS.POS_OSN_REQUESTS does not reference any database object

POS.POS_OSN_REQUESTS is referenced by following:

POS
VIEW - POS_OSN_REQUESTS#

[top of page]

Table: POS_PARTY_TAX_PROFILE_INT

Description:

[top of page]

POS.POS_PARTY_TAX_PROFILE_INT does not reference any database object

POS.POS_PARTY_TAX_PROFILE_INT is referenced by following:

POS
VIEW - POS_PARTY_TAX_PROFILE_INT#

[top of page]

Table: POS_PARTY_TAX_REG_INT

Description:

[top of page]

POS.POS_PARTY_TAX_REG_INT does not reference any database object

POS.POS_PARTY_TAX_REG_INT is referenced by following:

POS
VIEW - POS_PARTY_TAX_REG_INT#

[top of page]

Table: POS_PRODUCTS_SERVICES_GT

Description:

[top of page]

APPS.POS_PRODUCTS_SERVICES_GT does not reference any database object

APPS.POS_PRODUCTS_SERVICES_GT is referenced by following:

APPS
PACKAGE BODY - POS_PRODUCT_SERVICE_UTL_PKG

[top of page]

Table: POS_PRODUCT_SERVICE_INT

Description:

[top of page]

POS.POS_PRODUCT_SERVICE_INT does not reference any database object

POS.POS_PRODUCT_SERVICE_INT is referenced by following:

POS
VIEW - POS_PRODUCT_SERVICE_INT#

[top of page]

Table: POS_PRODUCT_SERVICE_REQUESTS

Description: Requests for supplier products and services
Primary Key: POS_PRODUCT_SERVICE_REQ_PK
  1. PS_REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_PRODUCT_SERVICE_REQUESTS.MAPPING_ID POS_SUPPLIER_MAPPINGS

[top of page]

POS.POS_PRODUCT_SERVICE_REQUESTS does not reference any database object

POS.POS_PRODUCT_SERVICE_REQUESTS is referenced by following:

POS
VIEW - POS_PRODUCT_SERVICE_REQUESTS#

[top of page]

Table: POS_PROMPTS

Description: Dummy Table used for AK Region Definitions

[top of page]

POS.POS_PROMPTS does not reference any database object

POS.POS_PROMPTS is referenced by following:

POS
VIEW - POS_PROMPTS#

[top of page]

Table: POS_RFI_TEMPLATE_CONFIG

Description: Supplier Data Hub project. Used to store RFI template association to operating unit during onboarding configuration.

[top of page]

POS.POS_RFI_TEMPLATE_CONFIG does not reference any database object

POS.POS_RFI_TEMPLATE_CONFIG is referenced by following:

POS
VIEW - POS_RFI_TEMPLATE_CONFIG#

[top of page]

Table: POS_SPMNTF_SUBSCRIPTION

Description: This table stores information on which users to send email notifications when supplier makes changes to their profile.
Primary Key: POS_SPMNTF_SUBSCRIPTION_PK
  1. SUBSCRIPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_SPMNTF_SUBSCRIPTION.USER_ID FND_USER

[top of page]

POS.POS_SPMNTF_SUBSCRIPTION does not reference any database object

POS.POS_SPMNTF_SUBSCRIPTION is referenced by following:

POS
VIEW - POS_SPMNTF_SUBSCRIPTION#

[top of page]

Table: POS_SUPPLIER_INT_REJECTIONS

Description:

[top of page]

POS.POS_SUPPLIER_INT_REJECTIONS does not reference any database object

POS.POS_SUPPLIER_INT_REJECTIONS is referenced by following:

POS
VIEW - POS_SUPPLIER_INT_REJECTIONS#

[top of page]

Table: POS_SUPPLIER_MAPPINGS

Description: References to supplier parties and/or supplier requests
Primary Key: POS_SUPPLIER_MAPPING_PK
  1. MAPPING_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_SUPPLIER_MAPPINGS.PARTY_ID HZ_PARTIES
POS_SUPPLIER_MAPPINGS.SUPPLIER_REG_ID POS_SUPPLIER_REGISTRATIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
POS_ACNT_ADDR_REQ.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_ACNT_GEN_REQ.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_ADDRESS_REQUESTS.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_BUS_CLASS_REQS.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_CONTACT_REQUESTS.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_CONT_ADDR_REQUESTS.MAPPING_ID POS_SUPPLIER_MAPPINGS
POS_PRODUCT_SERVICE_REQUESTS.MAPPING_ID POS_SUPPLIER_MAPPINGS

[top of page]

POS.POS_SUPPLIER_MAPPINGS does not reference any database object

POS.POS_SUPPLIER_MAPPINGS is referenced by following:

POS
VIEW - POS_SUPPLIER_MAPPINGS#

[top of page]

Table: POS_SUPPLIER_REGISTRATIONS

Description: Supplier Registrations and Supplier Onboarding Requests
Primary Key: POS_SUPPLIER_REGISTRATIONS_PK
  1. SUPPLIER_REG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_SUPPLIER_REGISTRATIONS.VENDOR_PARTY_ID HZ_PARTIES
POS_SUPPLIER_REGISTRATIONS.COUNTRY FND_TERRITORIES
POS_SUPPLIER_REGISTRATIONS.OU_ID HR_ALL_ORGANIZATION_UNITS
Foreign Keys to this table:
Foreign Key Column Foreign Table
POS_SUPPLIER_MAPPINGS.SUPPLIER_REG_ID POS_SUPPLIER_REGISTRATIONS

[top of page]

POS.POS_SUPPLIER_REGISTRATIONS does not reference any database object

POS.POS_SUPPLIER_REGISTRATIONS is referenced by following:

POS
VIEW - POS_SUPPLIER_REGISTRATIONS#

[top of page]

Table: POS_SUPPLIER_UDA_MERGE_GTT

Description:

[top of page]

POS.POS_SUPPLIER_UDA_MERGE_GTT does not reference any database object

POS.POS_SUPPLIER_UDA_MERGE_GTT is referenced by following:

APPS
SYNONYM - POS_SUPPLIER_UDA_MERGE_GTT

[top of page]

Table: POS_SUPP_GENERATE_XML_RPT

Description:

[top of page]

POS.POS_SUPP_GENERATE_XML_RPT references the following:

SYS
PACKAGE - STANDARD
TYPE - XMLTYPE
POS.POS_SUPP_GENERATE_XML_RPT is referenced by following:

POS
VIEW - POS_SUPP_GENERATE_XML_RPT#

[top of page]

Table: POS_SUPP_PROF_EXT_B

Description: Supplier Data Hub project. Extension table to store user-defined attributes for Supplier related entities.

[top of page]

POS.POS_SUPP_PROF_EXT_B does not reference any database object

POS.POS_SUPP_PROF_EXT_B is referenced by following:

POS
VIEW - POS_SUPP_PROF_EXT_B#

[top of page]

Table: POS_SUPP_PROF_EXT_INTF

Description: Supplier Data Hub project. Interface table for Supplier user-defined attributes

[top of page]

POS.POS_SUPP_PROF_EXT_INTF does not reference any database object

POS.POS_SUPP_PROF_EXT_INTF is referenced by following:

POS
VIEW - POS_SUPP_PROF_EXT_INTF#

[top of page]

Table: POS_SUPP_PROF_EXT_TL

Description: Supplier Data Hub project. Translation table for POS_SUPP_PROF_EXT_B

[top of page]

POS.POS_SUPP_PROF_EXT_TL does not reference any database object

POS.POS_SUPP_PROF_EXT_TL is referenced by following:

POS
VIEW - POS_SUPP_PROF_EXT_TL#

[top of page]

Table: POS_SUPP_PUB_HISTORY

Description:

[top of page]

POS.POS_SUPP_PUB_HISTORY references the following:

SYS
PACKAGE - STANDARD
TYPE - XMLTYPE
POS.POS_SUPP_PUB_HISTORY is referenced by following:

POS
VIEW - POS_SUPP_PUB_HISTORY#

[top of page]

Table: POS_SUPP_PUB_RESPONSES

Description:

[top of page]

POS.POS_SUPP_PUB_RESPONSES does not reference any database object

POS.POS_SUPP_PUB_RESPONSES is referenced by following:

POS
VIEW - POS_SUPP_PUB_RESPONSES#

[top of page]

Table: POS_SUP_BANK_ACCOUNT_REQUESTS

Description: This tables stores supplier bank account requests in release 11.5.10. It is no longer used in release 12.
Primary Key: POS_SUP_BANK_ACCOUNT_REQ_PK
  1. REQUEST_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_SUP_BANK_ACCOUNT_REQUESTS.BANK_BRANCH_ID AP_BANK_BRANCHES
POS_SUP_BANK_ACCOUNT_REQUESTS.COUNTRY FND_TERRITORIES
POS_SUP_BANK_ACCOUNT_REQUESTS.CURRENCY_CODE FND_CURRENCIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
POS_ACCT_ADDR_REL.REQUEST_ID POS_SUP_BANK_ACCOUNT_REQUESTS

[top of page]

POS.POS_SUP_BANK_ACCOUNT_REQUESTS does not reference any database object

POS.POS_SUP_BANK_ACCOUNT_REQUESTS is referenced by following:

POS
VIEW - POS_SUP_BANK_ACCOUNT_REQUESTS#

[top of page]

Table: POS_SUP_ONBOARD_CONFIG

Description: Configurations for flexible supplier registration and onboarding
Primary Key: POS_SUP_ONBOARD_CONFIG_UK1
  1. PROFILE_MODULE
  2. ORG_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_SUP_ONBOARD_CONFIG.ORG_ID HR_ALL_ORGANIZATION_UNITS

[top of page]

POS.POS_SUP_ONBOARD_CONFIG does not reference any database object

POS.POS_SUP_ONBOARD_CONFIG is referenced by following:

POS
VIEW - POS_SUP_ONBOARD_CONFIG#

[top of page]

Table: POS_SUP_PRODUCTS_SERVICES

Description: Supplier product and service classification
Primary Key: POS_SUP_PRODUCTS_SERVICES_PK
  1. CLASSIFICATION_ID

[top of page]

POS.POS_SUP_PRODUCTS_SERVICES does not reference any database object

POS.POS_SUP_PRODUCTS_SERVICES is referenced by following:

POS
VIEW - POS_SUP_PRODUCTS_SERVICES#

[top of page]

Table: POS_SURVEY_CONFIG

Description: Supplier survey configuration

[top of page]

POS.POS_SURVEY_CONFIG does not reference any database object

POS.POS_SURVEY_CONFIG is referenced by following:

POS
VIEW - POS_SURVEY_CONFIG#

[top of page]

Table: POS_SURVEY_TRANSACTIONS

Description: Supplier survey transaction table

[top of page]

POS.POS_SURVEY_TRANSACTIONS does not reference any database object

POS.POS_SURVEY_TRANSACTIONS is referenced by following:

POS
VIEW - POS_SURVEY_TRANSACTIONS#

[top of page]

Table: POS_UPGRADE_USERS

Description: This table will record all the users upgraded for ISP
Foreign Keys from this table:
Foreign Key Column Foreign Table
POS_UPGRADE_USERS.CUSTOMER_ID HZ_PARTIES

[top of page]

POS.POS_UPGRADE_USERS does not reference any database object

POS.POS_UPGRADE_USERS is referenced by following:

POS
VIEW - POS_UPGRADE_USERS#

[top of page]

Table: POS_VENDOR_UPG_TMP

Description: This table is used during release 11i to release 12 upgrade. It stores vendor_ids of vendors who are considered in iSupplier Portal TCA Supplier upgrade scripts.
Primary Key: POS_VENDOR_UPG_TMP_PK1
  1. VENDOR_ID

[top of page]

POS.POS_VENDOR_UPG_TMP does not reference any database object

POS.POS_VENDOR_UPG_TMP is referenced by following:

POS
VIEW - POS_VENDOR_UPG_TMP#

[top of page]

View: POS_AP_CHECKS_V

[top of page]

APPS.POS_AP_CHECKS_V references the following:

APPS
SYNONYM - AP_CHECKS_ALL
PACKAGE - FND_CURRENCY
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
VIEW - PO_VENDORS
- AP_LOOKUP_CODES

APPS.POS_AP_CHECKS_V is not referenced by any database object

[top of page]

View: POS_AP_INVOICES_V

[top of page]

APPS.POS_AP_INVOICES_V references the following:

APPS
SYNONYM - AP_INVOICES_ALL
PACKAGE - FND_CURRENCY_CACHE
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - POS_AP_INVOICES_PKG
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL
- AP_LOOKUP_CODES
- AP_PAYMENT_SCHEDULES_ALL

APPS.POS_AP_INVOICES_V is not referenced by any database object

[top of page]

View: POS_AP_INVOICE_PAYMENTS_V

[top of page]

APPS.POS_AP_INVOICE_PAYMENTS_V references the following:

APPS
SYNONYM - AP_CHECKS_ALL
SYNONYM - AP_INVOICES_ALL
SYNONYM - AP_INVOICE_PAYMENTS_ALL
PACKAGE - FND_CURRENCY

APPS.POS_AP_INVOICE_PAYMENTS_V is not referenced by any database object

[top of page]

View: POS_ASN_VIEW_FOR_SEARCH

[top of page]

APPS.POS_ASN_VIEW_FOR_SEARCH references the following:

APPS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_RELEASES_ALL
SYNONYM - RCV_HEADERS_INTERFACE
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_TRANSACTIONS_INTERFACE

APPS.POS_ASN_VIEW_FOR_SEARCH is not referenced by any database object

[top of page]

View: POS_BILL_ONLY_ORDERS_V

[top of page]

APPS.POS_BILL_ONLY_ORDERS_V references the following:

APPS
PACKAGE - FND_CURRENCY_CACHE
PACKAGE - FND_GLOBAL
PACKAGE - FND_MESSAGE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - HZ_LOCATIONS
PACKAGE - POS_GET
PACKAGE - POS_TOTALS_PO_SV
SYNONYM - PO_HEADERS_ALL
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_BILL_ONLY_ORDERS_V is not referenced by any database object

[top of page]

View: POS_BLANKET_AGREE_V

[top of page]

APPS.POS_BLANKET_AGREE_V references the following:

APPS
PACKAGE - FND_CURRENCY
PACKAGE - FND_GLOBAL
PACKAGE - FND_MESSAGE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - POS_GET
PACKAGE - POS_TOTALS_PO_SV
SYNONYM - PO_HEADERS_ARCHIVE_ALL
VIEW - PO_LOOKUP_CODES
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_BLANKET_AGREE_V is not referenced by any database object

[top of page]

View: POS_CHV_AUTHORIZATIONS_V

[top of page]

APPS.POS_CHV_AUTHORIZATIONS_V references the following:

APPS
SYNONYM - CHV_AUTHORIZATIONS
PACKAGE - FND_GLOBAL
VIEW - PO_LOOKUP_CODES

APPS.POS_CHV_AUTHORIZATIONS_V is not referenced by any database object

[top of page]

View: POS_CHV_ITEM_ORDERS_V

[top of page]

APPS.POS_CHV_ITEM_ORDERS_V references the following:

APPS
SYNONYM - CHV_ITEM_ORDERS
SYNONYM - CHV_SCHEDULE_ITEMS
PACKAGE - FND_GLOBAL
SYNONYM - PO_DOCUMENT_TYPES
SYNONYM - PO_DOCUMENT_TYPES_ALL_TL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ALL
SYNONYM - PO_REQUISITION_HEADERS
SYNONYM - PO_REQUISITION_LINES

APPS.POS_CHV_ITEM_ORDERS_V is not referenced by any database object

[top of page]

View: POS_CHV_SCHEDULE_HEADERS_V

[top of page]

APPS.POS_CHV_SCHEDULE_HEADERS_V references the following:

APPS
SYNONYM - CHV_BUCKET_PATTERNS
SYNONYM - CHV_SCHEDULE_HEADERS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_LOOKUP_CODES
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_CHV_SCHEDULE_HEADERS_V is not referenced by any database object

[top of page]

View: POS_CHV_SCHEDULE_ITEMS_V

[top of page]

APPS.POS_CHV_SCHEDULE_ITEMS_V references the following:

APPS
PACKAGE - CHV_INQ_SV
SYNONYM - CHV_SCHEDULE_HEADERS
SYNONYM - CHV_SCHEDULE_ITEMS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PO_APPROVED_SUPPLIER_LIST
SYNONYM - PO_ASL_ATTRIBUTES
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
VIEW - PO_LOOKUP_CODES
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_TRANSACTIONS

APPS.POS_CHV_SCHEDULE_ITEMS_V is not referenced by any database object

[top of page]

View: POS_CONSIGNED_SHIPMENTS_V

[top of page]

APPS.POS_CONSIGNED_SHIPMENTS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - HR_SECURITY
SYNONYM - HZ_LOCATIONS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_CONSIGNED_SHIPMENTS_V is not referenced by any database object

[top of page]

View: POS_DISTRIBUTIONS_V

[top of page]

APPS.POS_DISTRIBUTIONS_V references the following:

APPS
SYNONYM - PO_DISTRIBUTIONS_ALL

APPS.POS_DISTRIBUTIONS_V is not referenced by any database object

[top of page]

View: POS_HEADERS_V

[top of page]

APPS.POS_HEADERS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - HZ_LOCATIONS
VIEW - PO_VENDORS
SYNONYM - RCV_HEADERS_INTERFACE
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_TRANSACTIONS_INTERFACE
- PO_VENDOR_SITES_ALL
- AP_TERMS_VL

APPS.POS_HEADERS_V is not referenced by any database object

[top of page]

View: POS_HORIZONTAL_SCHEDULE_V

[top of page]

APPS.POS_HORIZONTAL_SCHEDULE_V references the following:

APPS
SYNONYM - CHV_HORIZONTAL_SCHEDULES
PACKAGE - CHV_INQ_SV
PACKAGE - FND_GLOBAL
VIEW - PO_LOOKUP_CODES

APPS.POS_HORIZONTAL_SCHEDULE_V is not referenced by any database object

[top of page]

View: POS_LINES_V

[top of page]

APPS.POS_LINES_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_TERRITORIES_VL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - HZ_LOCATIONS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PER_ALL_PEOPLE_F
PACKAGE - POS_CANCEL_ASN
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
SYNONYM - RCV_HEADERS_INTERFACE
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_TRANSACTIONS_INTERFACE
- PO_VENDOR_SITES_ALL

APPS.POS_LINES_V is not referenced by any database object

[top of page]

View: POS_MTL_ONHAND_ITEMS_DMMY_V

[top of page]

APPS.POS_MTL_ONHAND_ITEMS_DMMY_V references the following:

APPS
SYNONYM - MTL_SYSTEM_ITEMS

APPS.POS_MTL_ONHAND_ITEMS_DMMY_V is not referenced by any database object

[top of page]

View: POS_MTL_ONHAND_ITEMS_KFV

[top of page]

APPS.POS_MTL_ONHAND_ITEMS_KFV references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
VIEW - MTL_ONHAND_QUANTITIES
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.POS_MTL_ONHAND_ITEMS_KFV is not referenced by any database object

[top of page]

View: POS_MTL_ONHAND_LOCATOR_KFV

[top of page]

APPS.POS_MTL_ONHAND_LOCATOR_KFV references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - MTL_ITEM_LOCATIONS_KFV
VIEW - MTL_ONHAND_QUANTITIES
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SECONDARY_INVENTORIES
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.POS_MTL_ONHAND_LOCATOR_KFV is not referenced by any database object

[top of page]

View: POS_MTL_ONHAND_LOT_KFV

[top of page]

APPS.POS_MTL_ONHAND_LOT_KFV references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_LOT_NUMBERS
VIEW - MTL_ONHAND_QUANTITIES
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.POS_MTL_ONHAND_LOT_KFV is not referenced by any database object

[top of page]

View: POS_MTL_ONHAND_REV_KFV

[top of page]

APPS.POS_MTL_ONHAND_REV_KFV references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - MTL_ONHAND_QUANTITIES
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.POS_MTL_ONHAND_REV_KFV is not referenced by any database object

[top of page]

View: POS_MTL_ONHAND_SERIAL_KFV

[top of page]

APPS.POS_MTL_ONHAND_SERIAL_KFV references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - MTL_ITEM_LOCATIONS_KFV
SYNONYM - MTL_SERIAL_NUMBERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.POS_MTL_ONHAND_SERIAL_KFV is not referenced by any database object

[top of page]

View: POS_MTL_ONHAND_SUB_KFV

[top of page]

APPS.POS_MTL_ONHAND_SUB_KFV references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
VIEW - MTL_ONHAND_QUANTITIES
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SECONDARY_INVENTORIES
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.POS_MTL_ONHAND_SUB_KFV is not referenced by any database object

[top of page]

View: POS_ORDER_SUMMARY_V

[top of page]

APPS.POS_ORDER_SUMMARY_V references the following:

APPS
PACKAGE - FND_CURRENCY
PACKAGE - FND_GLOBAL
PACKAGE - POS_GET
PACKAGE - POS_TOTALS_PO_SV
SYNONYM - PO_DOCUMENT_TYPES_ALL_B
SYNONYM - PO_HEADERS_ARCHIVE_ALL
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ARCHIVE_ALL
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_ORDER_SUMMARY_V is not referenced by any database object

[top of page]

View: POS_ORD_MODIFIERS_V

[top of page]

APPS.POS_ORD_MODIFIERS_V references the following:

APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - MTL_PLANNERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PO_APPROVED_SUPPLIER_LIST
SYNONYM - PO_ASL_ATTRIBUTES
VIEW - PO_VENDORS

APPS.POS_ORD_MODIFIERS_V is not referenced by any database object

[top of page]

View: POS_ORG_ADDRESS_V

[top of page]

APPS.POS_ORG_ADDRESS_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - MTL_ORGANIZATIONS

APPS.POS_ORG_ADDRESS_V is not referenced by any database object

[top of page]

View: POS_PARTIES_V

[top of page]

APPS.POS_PARTIES_V references the following:

APPS
SYNONYM - HZ_PARTIES

APPS.POS_PARTIES_V is not referenced by any database object

[top of page]

View: POS_PARTY_SITES_V

[top of page]

APPS.POS_PARTY_SITES_V references the following:

APPS
SYNONYM - HZ_PARTY_SITES

APPS.POS_PARTY_SITES_V is not referenced by any database object

[top of page]

View: POS_PER_PEOPLE_X_V

[top of page]

APPS.POS_PER_PEOPLE_X_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_X

APPS.POS_PER_PEOPLE_X_V is not referenced by any database object

[top of page]

View: POS_PLAN_SCHEDULE_HEADERS_V

[top of page]

APPS.POS_PLAN_SCHEDULE_HEADERS_V references the following:

APPS
SYNONYM - CHV_BUCKET_PATTERNS
SYNONYM - CHV_SCHEDULE_HEADERS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_LOOKUP_CODES
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_PLAN_SCHEDULE_HEADERS_V is not referenced by any database object

[top of page]

View: POS_PO_ARCH_SUMMARY_V

[top of page]

APPS.POS_PO_ARCH_SUMMARY_V references the following:

APPS
PACKAGE - FND_CURRENCY_CACHE
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_MESSAGE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - POS_GET
PACKAGE - POS_TOTALS_PO_SV
PACKAGE - PO_ACKNOWLEDGE_PO_GRP
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_HEADERS_ARCHIVE_ALL
PACKAGE - PO_INQ_SV
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ALL
SYNONYM - PO_RELEASES_ARCHIVE_ALL
VIEW - PO_VENDORS
- AP_TERMS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_ARCH_SUMMARY_V is not referenced by any database object

[top of page]

View: POS_PO_DETAILS_V

[top of page]

APPS.POS_PO_DETAILS_V references the following:

APPS
SYNONYM - AP_TAX_CODES
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - FND_GLOBAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PO_HEADERS_ALL
PACKAGE - PO_INQ_SV
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_DETAILS_V is not referenced by any database object

[top of page]

View: POS_PO_EMPLOYEE_DETAILS_V

[top of page]

APPS.POS_PO_EMPLOYEE_DETAILS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_ALL_POSITIONS

APPS.POS_PO_EMPLOYEE_DETAILS_V is not referenced by any database object

[top of page]

View: POS_PO_EXPECTED_RECEIPTS_V

[top of page]

APPS.POS_PO_EXPECTED_RECEIPTS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL_TL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - HZ_LOCATIONS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
PACKAGE - POS_GET
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - RCV_ROUTING_HEADERS
- PO_VENDOR_SITES_ALL
- AP_TERMS

APPS.POS_PO_EXPECTED_RECEIPTS_V is not referenced by any database object

[top of page]

View: POS_PO_HEADERS_ARCHIVE_V

[top of page]

APPS.POS_PO_HEADERS_ARCHIVE_V references the following:

APPS
PACKAGE - FND_CURRENCY
PACKAGE - FND_GLOBAL
PACKAGE - FND_MESSAGE
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - POS_GET
PACKAGE - POS_TOTALS_PO_SV
SYNONYM - PO_HEADERS_ARCHIVE_ALL
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ARCHIVE_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
- AP_TERMS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_HEADERS_ARCHIVE_V is not referenced by any database object

[top of page]

View: POS_PO_INVOICE_SUP_ORDERS_V

[top of page]

APPS.POS_PO_INVOICE_SUP_ORDERS_V references the following:

APPS
SYNONYM - AP_INVOICE_DISTRIBUTIONS_ALL
PACKAGE - FND_CURRENCY
PACKAGE - FND_GLOBAL
PACKAGE - POS_GET
PACKAGE - POS_TOTALS_PO_SV
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_INVOICE_SUP_ORDERS_V is not referenced by any database object

[top of page]

View: POS_PO_LATE_RECEIPTS_V

[top of page]

APPS.POS_PO_LATE_RECEIPTS_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - HZ_LOCATIONS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PO_DOC_STYLE_HEADERS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_LINE_TYPES
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_LATE_RECEIPTS_V is not referenced by any database object

[top of page]

View: POS_PO_LINES_ARCHIVE_V

[top of page]

APPS.POS_PO_LINES_ARCHIVE_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - HR_SECURITY
SYNONYM - MTL_SYSTEM_ITEMS
VIEW - ORG_ORGANIZATION_DEFINITIONS
PACKAGE - POS_GET
SYNONYM - PO_DOCUMENT_TYPES_ALL_TL
SYNONYM - PO_HEADERS_ARCHIVE_ALL
SYNONYM - PO_LINES_ARCHIVE_ALL
SYNONYM - PO_LINE_LOCATIONS_ARCHIVE_ALL
SYNONYM - PO_LINE_TYPES
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ARCHIVE_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - RCV_ROUTING_HEADERS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_LINES_ARCHIVE_V is not referenced by any database object

[top of page]

View: POS_PO_LINES_V

[top of page]

APPS.POS_PO_LINES_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - MTL_SYSTEM_ITEMS_KFV
PACKAGE - POS_GET
VIEW - PO_DOCUMENT_TYPES_ALL_VL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_LINE_TYPES
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
VIEW - RCV_ROUTING_HEADERS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_LINES_V is not referenced by any database object

[top of page]

View: POS_PO_LIST_USERS_V

[top of page]

APPS.POS_PO_LIST_USERS_V references the following:

APPS
SYNONYM - FND_USER
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_SECURITY
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
PACKAGE - POS_GET
SYNONYM - PO_REQUISITION_HEADERS

APPS.POS_PO_LIST_USERS_V is not referenced by any database object

[top of page]

View: POS_PO_LOCATION_DETAIL_V

[top of page]

APPS.POS_PO_LOCATION_DETAIL_V references the following:

APPS
SYNONYM - HR_LOCATIONS_ALL

APPS.POS_PO_LOCATION_DETAIL_V is not referenced by any database object

[top of page]

View: POS_PO_OSP_V

[top of page]

APPS.POS_PO_OSP_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - FND_ATTACHMENT_UTIL_PKG
PACKAGE - FND_MESSAGE
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_DOCUMENT_TYPES_ALL
VIEW - PO_DOCUMENT_TYPES_ALL_VL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_LINE_TYPES
SYNONYM - PO_RELEASES_ALL
SYNONYM - WIP_ENTITIES
SYNONYM - WIP_LINES
PACKAGE - WIP_WORK_ORDER_PVT

APPS.POS_PO_OSP_V is not referenced by any database object

[top of page]

View: POS_PO_QA_SHIPMENTS_V

[top of page]

APPS.POS_PO_QA_SHIPMENTS_V references the following:

APPS
SYNONYM - AP_SUPPLIERS
SYNONYM - AP_SUPPLIER_SITES_ALL
PACKAGE - FND_MESSAGE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HZ_PARTIES
SYNONYM - MTL_CATEGORIES_KFV
SYNONYM - MTL_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PO_DOC_STYLE_HEADERS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL
PACKAGE - QA_SS_SHIP

APPS.POS_PO_QA_SHIPMENTS_V is not referenced by any database object

[top of page]

View: POS_PO_REVISIONS_HEADER_V

[top of page]

APPS.POS_PO_REVISIONS_HEADER_V references the following:

APPS
PACKAGE - POS_GET
VIEW - POS_PO_REVISIONS_TEMP_V

APPS.POS_PO_REVISIONS_HEADER_V is not referenced by any database object

[top of page]

View: POS_PO_REVISIONS_LINE_V

[top of page]

APPS.POS_PO_REVISIONS_LINE_V references the following:

APPS
PACKAGE - POS_GET
VIEW - POS_PO_REVISIONS_TEMP_V

APPS.POS_PO_REVISIONS_LINE_V is not referenced by any database object

[top of page]

View: POS_PO_REVISIONS_TEMP_V

[top of page]

APPS.POS_PO_REVISIONS_TEMP_V references the following:

APPS
VIEW - AK_REGION_ITEMS_VL
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
SYNONYM - ICX_PO_REVISIONS_TEMP
SYNONYM - MTL_SYSTEM_ITEMS
PACKAGE - POS_GET
APPS.POS_PO_REVISIONS_TEMP_V is referenced by following:

APPS
VIEW - POS_PO_REVISIONS_HEADER_V
VIEW - POS_PO_REVISIONS_LINE_V

[top of page]

View: POS_PO_RFQ_HEADERS_V

[top of page]

APPS.POS_PO_RFQ_HEADERS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_DOCUMENT_TYPES_ALL_VL
SYNONYM - PO_HEADERS_ALL
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RFQ_VENDORS
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
- AP_TERMS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_RFQ_HEADERS_V is not referenced by any database object

[top of page]

View: POS_PO_RFQ_LINES_V

[top of page]

APPS.POS_PO_RFQ_LINES_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - MTL_SYSTEM_ITEMS
SYNONYM - MTL_UNITS_OF_MEASURE
PACKAGE - POS_GET
SYNONYM - PO_HAZARD_CLASSES
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_LINE_TYPES
SYNONYM - PO_UN_NUMBERS
- AP_TERMS

APPS.POS_PO_RFQ_LINES_V is not referenced by any database object

[top of page]

View: POS_PO_SUMMARY_V

[top of page]

APPS.POS_PO_SUMMARY_V references the following:

APPS
PACKAGE - FND_CURRENCY_CACHE
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUP_VALUES_VL
PACKAGE - FND_MESSAGE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - POS_GET
PACKAGE - POS_TOTALS_PO_SV
SYNONYM - PO_ACCEPTANCES
SYNONYM - PO_HEADERS_ALL
PACKAGE - PO_INQ_SV
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL
- AP_TERMS

APPS.POS_PO_SUMMARY_V is not referenced by any database object

[top of page]

View: POS_PO_SUPPLIER_AGREEMENTS_V

[top of page]

APPS.POS_PO_SUPPLIER_AGREEMENTS_V references the following:

APPS
PACKAGE - FND_CURRENCY
PACKAGE - FND_GLOBAL
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL_TL
PACKAGE - POS_GET
PACKAGE - POS_TOTALS_PO_SV
SYNONYM - PO_HEADERS_ALL
VIEW - PO_LOOKUP_CODES
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
- AP_TERMS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_SUPPLIER_AGREEMENTS_V is not referenced by any database object

[top of page]

View: POS_PO_SUPPLIER_INFO_V

[top of page]

APPS.POS_PO_SUPPLIER_INFO_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_SUPPLIER_INFO_V is not referenced by any database object

[top of page]

View: POS_PO_SUPPLIER_ITEMS_V

[top of page]

APPS.POS_PO_SUPPLIER_ITEMS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - MTL_PARAMETERS
VIEW - MTL_SYSTEM_ITEMS_VL
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PO_APPROVED_SUPPLIER_LIST
SYNONYM - PO_ASL_ATTRIBUTES
SYNONYM - PO_ASL_STATUS_RULES
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_SUPPLIER_ITEMS_V is not referenced by any database object

[top of page]

View: POS_PO_SUPPLIER_ORDERS_V

[top of page]

APPS.POS_PO_SUPPLIER_ORDERS_V references the following:

APPS
PACKAGE - FND_CURRENCY
PACKAGE - FND_GLOBAL
SYNONYM - GL_DAILY_CONVERSION_TYPES
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - POS_GET
PACKAGE - POS_TOTALS_PO_SV
SYNONYM - PO_DOCUMENT_TYPES_ALL_TL
SYNONYM - PO_HEADERS_ALL
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
- AP_TERMS
- PO_VENDOR_SITES_ALL

APPS.POS_PO_SUPPLIER_ORDERS_V is not referenced by any database object

[top of page]

View: POS_PO_USER_DETAILS_V

[top of page]

APPS.POS_PO_USER_DETAILS_V references the following:

APPS
SYNONYM - FND_USER

APPS.POS_PO_USER_DETAILS_V is not referenced by any database object

[top of page]

View: POS_PO_VENDORS_V

[top of page]

APPS.POS_PO_VENDORS_V references the following:

APPS
VIEW - PO_VENDORS

APPS.POS_PO_VENDORS_V is not referenced by any database object

[top of page]

View: POS_RCV_EARLY_LATE_RECEIPTS_V

[top of page]

APPS.POS_RCV_EARLY_LATE_RECEIPTS_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_TRANSACTION_REASONS
SYNONYM - PER_ALL_PEOPLE_F
PACKAGE - POS_PO_RCV_QTY
SYNONYM - PO_DOC_STYLE_HEADERS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
VIEW - RCV_ROUTING_HEADERS
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_TRANSACTIONS
- PO_VENDOR_SITES_ALL

APPS.POS_RCV_EARLY_LATE_RECEIPTS_V is not referenced by any database object

[top of page]

View: POS_RCV_REJECTED_ITEMS_V

[top of page]

APPS.POS_RCV_REJECTED_ITEMS_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - HR_SECURITY
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_TRANSACTION_REASONS
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PER_ALL_PEOPLE_F
PACKAGE - POS_PO_RCV_QTY
SYNONYM - PO_DISTRIBUTIONS_ALL
SYNONYM - PO_HAZARD_CLASSES
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL
SYNONYM - PO_REQUISITION_HEADERS_ALL
SYNONYM - PO_REQUISITION_LINES_ALL
SYNONYM - PO_UN_NUMBERS
VIEW - PO_VENDORS
VIEW - RCV_ROUTING_HEADERS
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_TRANSACTIONS
- PO_VENDOR_SITES_ALL

APPS.POS_RCV_REJECTED_ITEMS_V is not referenced by any database object

[top of page]

View: POS_RCV_RETURNS_V

[top of page]

APPS.POS_RCV_RETURNS_V references the following:

APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMS_ALL
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - HR_SECURITY
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_TRANSACTION_REASONS
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PER_ALL_PEOPLE_F
PACKAGE - POS_PO_RCV_QTY
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_TRANSACTIONS
- PO_VENDOR_SITES_ALL

APPS.POS_RCV_RETURNS_V is not referenced by any database object

[top of page]

View: POS_RCV_TRANSACTIONS_V

[top of page]

APPS.POS_RCV_TRANSACTIONS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - PER_ALL_PEOPLE_F
PACKAGE - POS_PO_RCV_QTY
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_TRANSACTIONS
- PO_VENDOR_SITES_ALL

APPS.POS_RCV_TRANSACTIONS_V is not referenced by any database object

[top of page]

View: POS_RECEIPT_HEADERS_V

[top of page]

APPS.POS_RECEIPT_HEADERS_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
PACKAGE - HR_SECURITY
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_VENDORS
SYNONYM - RCV_SHIPMENT_HEADERS
- PO_VENDOR_SITES_ALL

APPS.POS_RECEIPT_HEADERS_V is not referenced by any database object

[top of page]

View: POS_SHIPMENTS_V

[top of page]

APPS.POS_SHIPMENTS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - HZ_LOCATIONS
SYNONYM - MTL_SYSTEM_ITEMS_KFV
SYNONYM - MTL_UNITS_OF_MEASURE
PACKAGE - POS_ASN_CREATE_PVT
SYNONYM - PO_DOC_STYLE_HEADERS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS_ALL
VIEW - PO_LOOKUP_CODES
SYNONYM - PO_RELEASES_ALL
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_SHIPMENTS_V is not referenced by any database object

[top of page]

View: POS_SHIP_SCHEDULE_HEADERS_V

[top of page]

APPS.POS_SHIP_SCHEDULE_HEADERS_V references the following:

APPS
SYNONYM - CHV_BUCKET_PATTERNS
SYNONYM - CHV_SCHEDULE_HEADERS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - ORG_ORGANIZATION_DEFINITIONS
SYNONYM - PER_ALL_PEOPLE_F
VIEW - PO_LOOKUP_CODES
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_SHIP_SCHEDULE_HEADERS_V is not referenced by any database object

[top of page]

View: POS_SUPPLIER_USERS_V

[top of page]

APPS.POS_SUPPLIER_USERS_V references the following:

APPS
SYNONYM - AK_WEB_USER_SEC_ATTR_VALUES
SYNONYM - FND_USER
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
VIEW - PO_VENDORS

APPS.POS_SUPPLIER_USERS_V is not referenced by any database object

[top of page]

View: POS_SUPP_AGREEMENTS_V

[top of page]

APPS.POS_SUPP_AGREEMENTS_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - PO_HEADERS_ARCHIVE_ALL
VIEW - PO_LOOKUP_CODES
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_SUPP_AGREEMENTS_V is not referenced by any database object

[top of page]

View: POS_SUPP_PROF_EXT_OCV

[top of page]

APPS.POS_SUPP_PROF_EXT_OCV references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - FND_NEW_MESSAGES
SYNONYM - FND_TERRITORIES_TL
SYNONYM - HZ_CLASS_CATEGORIES
PACKAGE - POS_PRODUCT_SERVICE_UTL_PKG
TYPE - SYS_PLSQL_849016_495_1

APPS.POS_SUPP_PROF_EXT_OCV is not referenced by any database object

[top of page]

View: POS_SUPP_PROF_EXT_VL

[top of page]

APPS.POS_SUPP_PROF_EXT_VL references the following:

APPS
SYNONYM - POS_SUPP_PROF_EXT_B
SYNONYM - POS_SUPP_PROF_EXT_TL

APPS.POS_SUPP_PROF_EXT_VL is not referenced by any database object

[top of page]

View: POS_SUPP_PUB_HISTORY_V

[top of page]

APPS.POS_SUPP_PUB_HISTORY_V references the following:

APPS
SYNONYM - AP_SUPPLIERS
SYNONYM - FND_USER
SYNONYM - HZ_PARTIES
SYNONYM - POS_SUPP_PUB_HISTORY
SYS
PACKAGE - STANDARD
TYPE - XMLTYPE

APPS.POS_SUPP_PUB_HISTORY_V is not referenced by any database object

[top of page]

View: POS_SUP_AP_BANK_ACCOUNTS_V

[top of page]

APPS.POS_SUP_AP_BANK_ACCOUNTS_V references the following:

APPS
VIEW - IBY_EXT_BANK_ACCOUNTS_V
SYNONYM - POS_SUPPLIER_MAPPINGS

APPS.POS_SUP_AP_BANK_ACCOUNTS_V is not referenced by any database object

[top of page]

View: POS_VIEW_ASN

[top of page]

APPS.POS_VIEW_ASN references the following:

APPS
SYNONYM - AP_INVOICES_ALL
PACKAGE - FND_GLOBAL
SYNONYM - HZ_PARTY_SITES
VIEW - PO_VENDORS
SYNONYM - RCV_HEADERS_INTERFACE
SYNONYM - RCV_SHIPMENT_HEADERS
SYNONYM - RCV_SHIPMENT_LINES
SYNONYM - RCV_TRANSACTIONS_INTERFACE
- PO_VENDOR_SITES_ALL

APPS.POS_VIEW_ASN is not referenced by any database object

[top of page]

View: POS_VIEW_PO_SUMMARY_V

[top of page]

APPS.POS_VIEW_PO_SUMMARY_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_MESSAGE_CACHE
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - PO_DOCUMENT_TYPES_ALL
SYNONYM - PO_DOCUMENT_TYPES_ALL_B
SYNONYM - PO_DOC_STYLE_HEADERS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_HEADERS_ARCHIVE_ALL
SYNONYM - PO_RELEASES_ALL
SYNONYM - PO_RELEASES_ARCHIVE_ALL
VIEW - PO_VENDORS
- PO_VENDOR_SITES_ALL

APPS.POS_VIEW_PO_SUMMARY_V is not referenced by any database object

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract