iSupplier portal Table Names

Oracle iSupplier Portal - Base Tables

TABLE NAME	DESCRIPTION
POS_ACCT_ADDR_REL	Supplier bank account and address assignments
POS_ACNT_ADDR_REQ	Table for supplier bank account and address assignment requests
POS_ACNT_ADDR_SUMM_REQ	This table stores the details of supplier bank account and address assignment requests.
POS_ACNT_GEN_REQ	Table for supplier bank account requests
POS_ACNT_PAY_PREF	This table stores the payment preferences of suppliers for their addresses.
POS_ADDRESS_NOTES	Notes for supplier addresses
POS_ADDRESS_REQUESTS	Supplier Address Requests
POS_ADDRESS_UPGRADE	Supplier address upgrade staging table
POS_ASN_LOAD	This table will record ALL upload Excel ASN requests
POS_ATTRPG_CONFIG	Supplier Data Hub project.  Used to store RFI template association to operating unit during onboarding configuration.
POS_BANK_ACCNT_OWNERS_INT
POS_BANK_ACCOUNT_DET_INT
POS_BUS_CLASS_ATTR	Supplier Business Classification Attributes
POS_BUS_CLASS_REQS	Business Classification Requests for Suppliers
POS_BUSINESS_CLASS_INT
POS_CAPACITY_TOLERANCE_TEMP	This Table is used to Store Cange in Capacity Tolerance Orders
POS_CONT_ADDR_REQUESTS	Requests for supplier contact and address links
POS_CONTACT_REQUESTS	Supplier Contact Requests
POS_CONTACT_UPGRADE	Supplier contact upgrade staging table
POS_FISCAL_CLASS_INT
POS_IMP_BATCH_SUMMARY
POS_MFG_CAPACITY_TEMP	This Table is used to Store Cange in Capacity for Orders
POS_ORDER_MODIFIERS_TEMP	This table is used to store the order modifier request
POS_ORG_HASH	Hash keys for operating unit identifier
POS_OSN_ASSOCIATIONS	Table for storing the association between Oracle Supplier Network trading partners and the iSP vendors
POS_OSN_REQUESTS	Table for storing inbound requests from Oracle Supplier Network
POS_PARTY_TAX_PROFILE_INT
POS_PARTY_TAX_REG_INT
POS_PRODUCT_SERVICE_INT
POS_PRODUCT_SERVICE_REQUESTS	Requests for supplier products and services
POS_PRODUCTS_SERVICES_GT
POS_PROMPTS	Dummy Table used for AK Region Definitions
POS_RFI_TEMPLATE_CONFIG	Supplier Data Hub project.  Used to store RFI template association to operating unit during onboarding configuration.
POS_SPMNTF_SUBSCRIPTION	This table stores information on which users to send email notifications when supplier makes changes to their profile.
POS_SUP_BANK_ACCOUNT_REQUESTS	This tables stores supplier bank account requests in release 11.5.10. It is no longer used in release 12.
POS_SUP_ONBOARD_CONFIG	Configurations for flexible supplier registration and onboarding
POS_SUP_PRODUCTS_SERVICES	Supplier product and service classification
POS_SUPP_GENERATE_XML_RPT
POS_SUPP_PROF_EXT_B	Supplier Data Hub project.  Extension table to store user-defined attributes for Supplier related entities.
POS_SUPP_PROF_EXT_INTF	Supplier Data Hub project.  Interface table for Supplier user-defined attributes
POS_SUPP_PROF_EXT_TL	Supplier Data Hub project.  Translation table for POS_SUPP_PROF_EXT_B
POS_SUPP_PUB_HISTORY
POS_SUPP_PUB_RESPONSES
POS_SUPPLIER_INT_REJECTIONS
POS_SUPPLIER_MAPPINGS	References to supplier parties and/or supplier requests
POS_SUPPLIER_REGISTRATIONS	Supplier Registrations and Supplier Onboarding Requests
POS_SUPPLIER_UDA_MERGE_GTT
POS_SURVEY_CONFIG	Supplier survey configuration
POS_SURVEY_TRANSACTIONS	Supplier survey transaction table
POS_UPGRADE_USERS	This table will record all the users upgraded for ISP
POS_VENDOR_UPG_TMP	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.

Oracle iSupplier Portal - View Tables

VIEW NAME	DESCRIPTION
POS_AP_CHECKS_V	used to select the payment info details
POS_AP_INVOICES_V	used to select the invoice details
POS_AP_INVOICE_PAYMENTS_V	used to select the payment  info associated with an  invoice
POS_ASN_VIEW_FOR_SEARCH
POS_BILL_ONLY_ORDERS_V	used to select consumption advices.
POS_BLANKET_AGREE_V	View used to display blanket agreements. This view is created for convenience to be used to define the BC4J object
POS_CHV_AUTHORIZATIONS_V	used to select the detailed info related to authorization
POS_CHV_ITEM_ORDERS_V	used to select the item orders details info
POS_CHV_SCHEDULE_HEADERS_V	used to select the schedule and vendor info
POS_CHV_SCHEDULE_ITEMS_V	is one of the views used to select schedule related info
POS_CONSIGNED_SHIPMENTS_V	Used to select consigned shipments.
POS_DISTRIBUTIONS_V	used to select the detailed info for distributions
POS_HEADERS_V	used to select the header info for Advance Shipment Notice created
POS_HORIZONTAL_SCHEDULE_V	used to select schedule related info
POS_LINES_V	used to select the line-level info for the Advance Shipment Notice
POS_MTL_ONHAND_ITEMS_DMMY_V	used to select the inventory_item_id info for on-hand items
POS_MTL_ONHAND_ITEMS_KFV	used to select the detailed info for on-hand items
POS_MTL_ONHAND_LOCATOR_KFV	used to select the location info for on-hand items
POS_MTL_ONHAND_LOT_KFV	used to select the lot_number and related  info for on-hand items
POS_MTL_ONHAND_REV_KFV	used to select the  info related to on-hand items
POS_MTL_ONHAND_SERIAL_KFV	used to select the serial number info for on-hand items
POS_MTL_ONHAND_SUB_KFV	used to select the sub_inventory  info for on-hand items
POS_ORDER_SUMMARY_V
POS_ORD_MODIFIERS_V	Fetches the items from approved supplier lists
POS_ORG_ADDRESS_V	This view is used to fetch address information from the mtl_organizations view
POS_PARTIES_V	View for use with Party Merge
POS_PARTY_SITES_V	View used in party merge
POS_PER_PEOPLE_X_V	This is a view which retrieves the data related to an employee.
POS_PLAN_SCHEDULE_HEADERS_V	Used to select schedule and vendor info for planning schedules.
POS_PO_ARCH_SUMMARY_V
POS_PO_DETAILS_V	Fetches all the information related to a purchase order
POS_PO_EMPLOYEE_DETAILS_V	View to retrieve employee details.
POS_PO_EXPECTED_RECEIPTS_V	This view fetches the orders which are available to receive
POS_PO_HEADERS_ARCHIVE_V	Displays PO Revison Histories
POS_PO_INVOICE_SUP_ORDERS_V	Fetches the invoices associated with a Purchase Order and the details of the PO and the invoice.
POS_PO_LATE_RECEIPTS_V	Displays Overdue receipts
POS_PO_LINES_ARCHIVE_V	Fetches information from the po_lines_archive_all table. Needed to show Purchase Order History information.
POS_PO_LINES_V	Fetches information related to shipments for the Purchase Order. Used to fetch records for which an ASN could be created.
POS_PO_LIST_USERS_V	Not Used
POS_PO_LOCATION_DETAIL_V	Fetches address information from HR_LOCATIONS
POS_PO_OSP_V	Fetches PO details related to items which need outside processing.
POS_PO_QA_SHIPMENTS_V	Fetches shipment information for POs created for outside processing items.
POS_PO_REVISIONS_HEADER_V
POS_PO_REVISIONS_LINE_V
POS_PO_REVISIONS_TEMP_V
POS_PO_RFQ_HEADERS_V	Displays RFQ Headers
POS_PO_RFQ_LINES_V	Displays RFQ Lines
POS_PO_SUMMARY_V	Displays all Purchase Orders
POS_PO_SUPPLIER_AGREEMENTS_V	Displays Blankets
POS_PO_SUPPLIER_INFO_V	Displays Supplier Information
POS_PO_SUPPLIER_ITEMS_V	Displays all items from ASL
POS_PO_SUPPLIER_ORDERS_V	Displays All Types of PO's
POS_PO_USER_DETAILS_V	Displays User Information
POS_PO_VENDORS_V	Displays Vendors
POS_RCV_EARLY_LATE_RECEIPTS_V	Displays All receipts
POS_RCV_REJECTED_ITEMS_V	This view contains the information about Rejected Items
POS_RCV_RETURNS_V	Displays Returns for Shipments
POS_RCV_TRANSACTIONS_V	Displays Receiving Transactions
POS_RECEIPT_HEADERS_V	Displays Receipts
POS_SHIPMENTS_V	Displays Shipments
POS_SHIP_SCHEDULE_HEADERS_V	Used to select schedule and vendor info for shipment schedules.
POS_SUPPLIER_USERS_V	Queries the list of supplier users
POS_SUPP_AGREEMENTS_V
POS_SUPP_PROF_EXT_OCV	Supplier Data Hub project.  Supplier Profile Extension Classification View
POS_SUPP_PROF_EXT_VL	Supplier data hub project.  User-defined attribute MLS view.
POS_SUPP_PUB_HISTORY_V
POS_SUP_AP_BANK_ACCOUNTS_V	An internal view for supplier bank accounts in Oracle Payables
POS_VIEWPO_SUMMARY_V
POS_VIEW_ASN	This View is used to Display ASN's in the Buyers System
POS_VIEW_PO_SUMMARY_V	This view is used to display all Purchase Orders from archive tables.