POS Views (41)

POS - iSupplier Portal — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`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_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_PARTIES_V`	View for use with Party Merge
`POS_PARTY_SITES_V`	View used in party merge
`POS_PLAN_SCHEDULE_HEADERS_V`	Used to select schedule and vendor info for planning schedules.
`POS_PO_ARCH_SUMMARY_V`
`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_LOCATION_DETAIL_V`	Fetches address information from HR_LOCATIONS
`POS_PO_REVISIONS_HEADER_V`
`POS_PO_RFQ_LINES_V`	Displays RFQ Lines
`POS_PO_SUPPLIER_AGREEMENTS_V`	Displays Blankets
`POS_PO_USER_DETAILS_V`	Displays User Information
`POS_PO_VENDORS_V`	Displays Vendors
`POS_RCV_RETURNS_V`	Displays Returns for 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.