Showing posts with label iSupplier Portal. Show all posts
Showing posts with label iSupplier Portal. Show all posts

Thursday, September 01, 2016

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.