ONT Views (296)

ONT - Order Management — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`EDW_SALES_CHANNEL_FKV`
`OEBV_CUSTOMER_AGREEMENTS`	Base BIS Business View for Customer Agreements.
`OEBV_HOLD_AUTHORIZATIONS`	Base BIS Business View for Order Hold Authorization.
`OEBV_HOLD_REASONS`	Base BIS Business View for Order Hold Reasons.
`OEBV_HOLD_RELEASES`	Base BIS Business View for Order Hold Releases.
`OEBV_ORDER_CANCELLATIONS`	Base BIS Business View for Order Cancellations.
`OEBV_ORDER_HEADERS`	BIS View for Order Headers - required for Oracle IT
`OEBV_ORDER_HOLDS`	Base BIS Business View for Order Holds.
`OEBV_ORDER_LINES`
`OEBV_SALES_CREDIT_TYPES`	Base BIS Business View for Sales Credit Types.
`OEBV_SALES_ORDER_TYPES`	Base BIS Business View for Sales Order Types.
`OEFV_CUSTOMER_AGREEMENTS`
`OEFV_FULFILLMENT_SETS`
`OEFV_HEADER_END_CUSTOMER`	Full BIS Business View for End Customer Information
`OEFV_HOLD_AUTHORIZATIONS`	Full BIS Business View for Order Hold Authorizations .
`OEFV_HOLD_REASONS`	Full BIS Business View for Order Hold Reasons.
`OEFV_HOLD_RELEASES`	Full BIS Business View for Order Hold Releases.
`OEFV_LINE_END_CUSTOMER`	Full BIS Business View for End Customer Information
`OEFV_ORDER_AGREEMENTS`
`OEFV_ORDER_CANCELLATIONS`
`OEFV_ORDER_CHARGES`
`OEFV_ORDER_HEADERS`
`OEFV_ORDER_HOLDS`	Full BIS Business View for Order Holds.
`OEFV_ORDER_LINES`	Full BIS View for Order lines
`OEFV_ORDER_PRICE_ATTRIBS`	Full BIS Business view for Oracle Price Attributes
`OEFV_SALES_CREDITS`	Full BIS Business View for Sales Credits.
`OEFV_SALES_CREDIT_TYPES`	Full BIS Business View for Sales Credit Types.
`OEFV_SALES_ORDER_TYPES`	Full BIS Business View for Sales Order Types.
`OE_ACCRUALS_V`	This view shows accrued price adjustments in Order Management System.
`OE_ACTIONS`	Internal Forms View for the default actions and the customized actions for an user.
`OE_AGREEMENTS_LOV_V`	List of agreements.
`OE_AK_ACC_RULES_V`
`OE_AK_ARRIVAL_SETS_V`
`OE_AK_BLANKET_HEADERS_V`
`OE_AK_BLANKET_LINES_V`
`OE_AK_CHARGE_PERIODICITY_V`	View for defaulting charge_periodicity_code in OM
`OE_AK_CONVERSION_TYPES_V`
`OE_AK_CUST_PO_NUMBER_V`
`OE_AK_DEFAULT_FULFILMENT_SET_V`
`OE_AK_DEFAULT_LINE_SET_V`
`OE_AK_DELIVER_TO_ORGS_V`
`OE_AK_DEL_TO_CONTACT_V`
`OE_AK_DEMAND_CLASS_V`
`OE_AK_DEP_PLAN_REQD_V`
`OE_AK_EAR_SCH_LIMIT_V`
`OE_AK_END_CUS_CONT_V`	Used for Defautling of End Customer Contact
`OE_AK_END_CUS_SITEUSE_V`	Used for defaulting of End Customer Site
`OE_AK_END_CUS_V`	Used for Defaulting of End Customer
`OE_AK_FOB_POINT_V`
`OE_AK_FREIGHT_TERMS_V`
`OE_AK_HEADER_PAYMENTS_V`
`OE_AK_HEADER_PRCADJS_V`
`OE_AK_HEADER_SCREDITS_V`
`OE_AK_IB_CURR_LOC_V`	Used for defaulting of IB Current Location
`OE_AK_IB_INSTALL_LOC_V`	Used for defaulting of IB Installed At Location
`OE_AK_IB_OWNER_V`	Used for defaulting of IB Owner
`OE_AK_INVENTORY_ITEMS_V`
`OE_AK_INVOICE_TO_ORGS_V`
`OE_AK_INV_RULES_V`
`OE_AK_INV_TO_CONTACT_V`
`OE_AK_ITEM_IDENTIFIER_TYPE_V`
`OE_AK_ITEM_ORD_RULES_V`
`OE_AK_LAT_SCH_LIMIT_V`
`OE_AK_LINE_PAYMENTS_V`
`OE_AK_LINE_PRCADJS_V`
`OE_AK_LINE_SCREDITS_V`
`OE_AK_LINE_TYPES_V`
`OE_AK_MTL_CUST_ITEMS_V`
`OE_AK_ORDER_CATEGORY_V`
`OE_AK_ORDER_DATE_TYPE_V`
`OE_AK_ORDER_HEADERS_V`
`OE_AK_ORDER_LINES_V`
`OE_AK_ORDER_TYPES_V`
`OE_AK_ORD_FIRMED_DATE_V`
`OE_AK_PACK_INST_V`
`OE_AK_PAYMENT_TERM_V`
`OE_AK_PREFERRED_GRADES_V`
`OE_AK_PRIMARY_UOM_V`
`OE_AK_REQUEST_DATE_V`
`OE_AK_RETURN_REASON_V`
`OE_AK_SALESREPS_V`
`OE_AK_SALES_CHANNEL_V`
`OE_AK_SHIPPING_METHOD_V`
`OE_AK_SHIP_FROM_ORGS_V`
`OE_AK_SHIP_INST_V`
`OE_AK_SHIP_PARTIAL_V`
`OE_AK_SHIP_PRIORITIES_V`
`OE_AK_SHIP_SETS_V`
`OE_AK_SHIP_TOL_ABOVE_V`
`OE_AK_SHIP_TOL_BELOW_V`
`OE_AK_SHIP_TO_CONTACT_V`
`OE_AK_SHIP_TO_ORGS_V`
`OE_AK_SOLD_TO_ORGS_V`
`OE_AK_SOLD_TO_SITE_USES_V`	Selects defaultable attributes from customer location;
`OE_AK_SOURCE_TYPE_V`
`OE_AK_SRV_DURATION_V`	Used for defaulting Service Duration
`OE_AK_SRV_PERIOD_V`	Used for defaulting Service Period
`OE_AK_SRV_TEMPLATE_V`	Used for defaulting of Coverage Template and Subscription Template on Service Items
`OE_AK_TAX_EXEMPT_V`
`OE_AK_TAX_POINT_V`
`OE_AK_TOL_CUST_ITEMS_V`
`OE_AK_TOL_ITEM_BILLTO_V`
`OE_AK_TOL_ITEM_SHIPTO_V`
`OE_AK_TRXN_PHASE_V`	Used in Defaulting Transaction Phase
`OE_AK_T_EXEMPT_REASON_V`
`OE_AR_CUSTOMER_PROFILES_V`
`OE_AR_LOOKUPS_V`	This view is based on ar_lookups
`OE_AS_ORDER_HEADERS_V`	View to provide details of all existing orders in the Order Management.
`OE_ATTACHMENT_OBJECT_REFS_V`	No longer used
`OE_ATTACHMENT_OBJECT_REFS_VL`	No longer used
`OE_ATTACHMENT_RULES_V`	This view stores the attachment rules.
`OE_ATTACHMENT_RULE_ELEMENTS_V`	This view stores the elements of the attachment rules.
`OE_AUDIT_ATTR_DESC_V`
`OE_BLANKET_HDRS_HIST_V`
`OE_BLANKET_HEADERS_V`
`OE_BLANKET_LINES_HIST_V`	This view is used to get BSA line history information, and it is udes in BSA version comparison UI.
`OE_BLANKET_LINES_V`	This view is used to get the BSA lines information, used in BSA entry UI.
`OE_BLANKET_VERSIONS_V`
`OE_BLKTPRT_FLEX_HDR_V`	Obsolete
`OE_BLKTPRT_FLEX_LINES_V`	Obsolete
`OE_BLKTPRT_LINES_V`	This view is used to print the blanket lines information from the blanket sales agreement
`OE_BLKT_HEADERS_HIST_V`	This view is used to get BSA history headers information, and which is used in BSA organizer.
`OE_BLKT_LINES_HIST_V`	This view is used to get BSA history lines information, which is used in BSA organizer.
`OE_BLKT_LINES_VSET_V`	Internal Use.
`OE_CHARGE_LINES_V`	Used for Freight and Special Charges.
`OE_CONTACTS_V`	This is view is based on ra_contacts
`OE_CREDIT_CHECK_RULES_115`	No longer used
`OE_CRM_ORDER_HEADERS_V`	Compatible view provoded for CRM usage only. The view is based on oe_order_headers_all table.
`OE_CRM_ORDER_LINES_V`	Compatible view provoded for CRM usage only. The view is based on oe_order_lines_all table.
`OE_CRM_SALES_CREDITS_V`	Compatible view provoded for CRM usage only. The view is based on oe_sales_credits and ra_salesreps.
`OE_CUSTOMERS_ACTIVE_V`
`OE_CUSTOMER_ADDRESSES_V`
`OE_CUSTOMER_SITE_CONTACTS_V`
`OE_CUST_SITE_PHONE_V`
`OE_DEF_AK_ATTR_EXT_V`
`OE_DEF_AK_FKEYS_V`
`OE_DEF_AK_FKEY_COLS_V`
`OE_DEF_AK_OBJ_EXT_V`
`OE_DEF_AK_UKEY_COLS_V`
`OE_DEF_ATTR_CONDNS_V`	This view stores the attribute level defaulting conditions.
`OE_DEF_ATTR_DEF_RULES_V`	This view stores the defaulting rules.
`OE_DEF_ATTR_RULES_V`
`OE_DEF_CONDITIONS_VL`	This view stores the defaulting conditions.
`OE_DEF_CONDN_ELEMS_V`	This view stores the elements of the defaulting conditions.
`OE_DEF_RELATED_ATTR_V`
`OE_DEF_RELATED_OBJ_V`
`OE_DELIVERY_LINES_V`	This view is for interfacing the lines to shipping, for departure planning.
`OE_DELIVER_TO_ORGS_V`	This view is used to get and validate the delivery to organizations.
`OE_DEMAND_CLASSES_V`	This is view is used for the Demand Class LOV in Sales Orders form.
`OE_DROP_SHIP_LINKS_V`	This view is used for Dropship Tab in the additional line information of the Sales Orders form.
`OE_EM_PURGE_LOV_V`
`OE_FLOW_STATUS_AIA_SYNC_V`	This view is created to build the AIA UI (AIA Sales Order status Synchronization) and let user query on the FLOW STATUS field.
`OE_FND_COMMON_LOOKUPS_V`	This view is based on fnd_common_lookups.
`OE_FND_CURRENCIES_V`	This view is based on fnd_currencies.
`OE_FOBS_ACTIVE_V`	This view is a freight on board view.
`OE_FRGHT_CARR_ACTIVE_V`	No longer used
`OE_FRGHT_TERMS_ACTIVE_V`	This view is used for freight terms.
`OE_GL_DAILY_CONVERSION_TYPES_V`	This view is used to validate the conversion type code.
`OE_GL_SETS_OF_BOOKS_V`	No longer used
`OE_HEADERS_INTEROP_115_V`	No longer used
`OE_HEADERS_IOP_115_V`	No longer used
`OE_HEADER_ACKS_V`	Information about the acknowledgements for Order Headers.
`OE_HOLDS_HISTORY_V`
`OE_HOLD_SOURCES_V`	This view is used in the Holds form to display all the holds.
`OE_HR_ORGANIZATION_INFO_V`	No longer used
`OE_INLINE_FOUR_LEVEL_V`	Used in Add Customer. Based on table ar_location_values.
`OE_INLINE_ONE_LEVEL_V`	Used in Add Customer. Based on table ar_location_values.
`OE_INLINE_THREE_LEVEL_V`	Used in Add Customer. Based on table ar_location_values.
`OE_INLINE_TWO_LEVEL_V`	Used in Add Customer. Based on table ar_location_values.
`OE_INVOICE_TO_ORGS_V`	Bill to organization
`OE_ITEMS_ORD_MV`	This view is based on the materialized view OE_ITEMS_MV. This view displays all the Orderable items after taking the Orderability Rules into
`OE_ITEMS_V`	This view is union of inventory items, customer items and generic items.
`OE_LINES_VIEW_RETURNS_V`	No longer used
`OE_LINE_ACKS_V`	Information about the acknowledgements for Order Lines
`OE_LINE_PRC_ADJ_HIST_V`
`OE_LINE_SAL_CRDT_HIST_V`
`OE_LINE_TYPES_V`	This is a view to show line transaction types types for a specific organization and language.
`OE_LOOKUPS`	Order Management QuickCodes values.
`OE_LOOKUPS_115`	No longer used
`OE_LOTSERIAL_ACKS_V`	View based on the oe_lotserial_acks table, striped on organization.
`OE_MRP_OPEN_DEMANDS_V`	This vew is used by MRP for their Scheduler's Workbench.
`OE_MTL_SYSTEM_ITEMS_V`	No longer used
`OE_MULTIORG_ITEMS_V`	This view is used for the ValueSet OM: MultiOrg Items
`OE_NOTES_OBJECT_REFS_V`	No longer used
`OE_NOTES_OBJECT_REFS_VL`	No longer used
`OE_NOTES_RULES_V`	No longer used
`OE_OPTION_ITEMS_V`	View for Option Items LOV
`OE_ORDER_HEADERS_ALL_EXT_VL`
`OE_ORDER_HEADERS_HIST_V`	This view is used to retrieve the Order History. This is used by the history form.
`OE_ORDER_HEADERS_RM_V`
`OE_ORDER_HEADERS_V`	View for Order header used in sales order form.
`OE_ORDER_HOLDS_115`	No longer used
`OE_ORDER_HOLDS_V`	View for releasing orders from hold.
`OE_ORDER_LINES_ALL_EXT_VL`
`OE_ORDER_LINES_AUDIT_V`
`OE_ORDER_LINES_HIST_V`
`OE_ORDER_LINES_RM_V`
`OE_ORDER_LINES_V`	View for Order Lines used in the Sales Order form.
`OE_ORDER_PRICE_ATTRIBS_V`
`OE_ORDER_SOURCES_115`	No longer used
`OE_ORDER_TYPES_115`	No longer used
`OE_ORDER_TYPES_115_ALL`	No longer used
`OE_ORDER_TYPES_V`	This is a view to show order transaction types for a specific organization and language.
`OE_ORDER_VERSIONS_V`
`OE_ORD_PRC_ADJ_HIST_V`
`OE_ORD_SAL_CRDT_HIST_V`
`OE_ORG_FREIGHT_V`	No longer used
`OE_PAYMENT_TYPES_VL`
`OE_PC_ATTRIBUTES_V`	This view stores the attributes of sales order entities.
`OE_PC_CONDITIONS_V`
`OE_PC_CONDITIONS_VL`
`OE_PC_CONSTRAINTS_V`	This view stores the processing constraints.
`OE_PC_CONSTRAINT_CNDS_V`	This view stores the conditions of the processing constraints.
`OE_PC_ENTITIES_V`
`OE_PC_FKEYS_V`
`OE_PC_FKEY_COLS_V`
`OE_PC_RENTITIES_V`
`OE_PC_RESPS_V`	This view stores responsibilities associated with processing constraints.
`OE_PC_RSETS_V`	This view stores the processing constraints record sets.
`OE_PC_RSETS_VL`
`OE_PC_RSET_SEL_COLS_V`	This view stores the columns to be matched for the record set.
`OE_PC_UKEY_COLS_V`
`OE_PC_VENTITIES_V`
`OE_PC_VTMPLTS_V`	This view stores the processing constraint validation templates.
`OE_PC_VTMPLTS_VL`
`OE_PC_VTMPLT_COLS_V`	This view stores columns for the validation templates.
`OE_PO_ENTER_RECEIPTS_V`	For enter receipts to invoice.
`OE_PO_REQUISITION_LINES_V`	Purchase order requisition lines view.
`OE_PRICE_ADJS_HISTORY_V`	This view is used to retrieve Price Adjustments history. This is used by the history form.
`OE_PRICE_ADJUSTMENTS_V`	This is a view on table OE_PRICE_ADJUSTMENTS.
`OE_PRICE_ADJ_ASSOCS_V`	This is a view on table OE_PRICE_ADJ_ASSOCS.
`OE_PRICE_ADJ_ATTRIBS_V`	This is a view on table OE_PRICE_ADJ_ATTRIBS.
`OE_PRICE_FORMULA_ATTRIBS_V`	This view stores the pricing formula attributes for freight charges.
`OE_PRINT_CONT_POINTS_V`	This view is used to print the details of the various modes of communication for the Customer Contact
`OE_PRINT_CUST_ADDRESS_V`	This view is used to print the Bill-To, Ship-To and Deliver-To address of Customers from the Blanket Sales Agreement lines.
`OE_PRINT_CUST_CONTACT_V`	This view is used to print the Customer Contact information.
`OE_PRINT_INTERNAL_ORG_V`	This view is used to print the Name and Address of the vendor
`OE_PRINT_SREP_LOCTN_V`
`OE_PRINT_SREP_PHONES_V`
`OE_PRN_CHG_PERIODICITY_V`	The view is for obtaining recurring charges while printing a Sales Order
`OE_PRN_ORDER_HEADERS_V`
`OE_PRN_ORDER_LINES_V`	The view is for obtaining line details for printing a sales order
`OE_PROCESSING_MSGS_VL`	This view is a view built on oe_processing_msgs and oe_processing_msgs_tl for de-normalization to resolve multilingual issue and names for c
`OE_RA_ADDRESSES_V`	This view is used for validation of addresses.
`OE_RA_CONTACTS_Q_V`
`OE_RA_CONTACTS_V`	This view is used for validation of contact idnetification.
`OE_RA_CONTACT_ROLES_V`	This View is used for validation of contact roles.
`OE_RA_CUSTOMERS_V`
`OE_RA_CUSTOMER_TRX_PERF_V`	Invoice/Credit memo information
`OE_RA_CUSTOMER_TRX_V`	Invoice/Credit memo information
`OE_RA_CUST_TRX_HDR_PERF_V`	This will be used by the Invoices / Credit Memos tab in Addition Order Information screen.
`OE_RA_CUST_TRX_HDR_V`	This will be used by the Invoices / Credit Memos tab in Addition Order Information screen.
`OE_RA_RULES_V`	Invoicing and Accounting rules.
`OE_RA_TERMS_V`	This view is based on RA TERMS
`OE_REASONS_V`	Reason History
`OE_RELATED_ITEMS_MV`	This view is based on the materialized view OE_RELATED_ITEMS_MV. This view displays all the Orderable Related items after taking the Orderab
`OE_RELATED_ITEMS_V`
`OE_RELATED_PO_NUMBERS_V`	Internal
`OE_RESERVATION_SETS_V`	View for Reservation set information
`OE_RETROBILLED_INFO_V`	View is to show retrobilled activities
`OE_RETURN_ITEMS_V`	Added a view for return items LOV.
`OE_RMA_INVOICE_NUMBER_V`	This view is used for the ValueSet
`OE_SALES_CONTINGENCY_RM_V`
`OE_SALES_CREDITS_V`	This view is to show all sales credits for an order and is used by UI.
`OE_SALES_CREDIT_TYPES_115`	No longer used
`OE_SALES_CR_HISTORY_V`	Sales Credit History View
`OE_SCH_ORDER_LINES_V`
`OE_SCH_RSV_SET_LINES_V`	View used by the new form for scheduling across orders with Reservation set information
`OE_SHIP_FROM_ORGS_V`	Ship From Organizations.
`OE_SHIP_METHODS_V`	This is a view for ship methods.
`OE_SHIP_TO_ADDRESSES_V`	No longer used
`OE_SHIP_TO_ORGS_V`	Ship To Organizations.
`OE_SOLD_TO_CUSTOMERS_V`	No longer used
`OE_SOLD_TO_ORGS_V`	List of customers.
`OE_SUBINVENTORIES_V`	Use by defaulting LOV to list subinventories
`OE_SYSTEM_PARAMETERS`	ORG stripped view based on oe_system_parameters_All table to get the system patarameters for the current operating unit as set in the client
`OE_SYS_PARAMETERS_V`
`OE_SYS_PARAMETER_DEF_VL`
`OE_SYS_PARAMS_ALL_UPG`	This view shows all the Parameter Values in OE_SYS_PARAMETERS_ALL table.
`OE_SYS_PARAMS_UPG`
`OE_SYS_PARAMS_UPG_V`
`OE_TAX_EXEMPTIONS_QP_V`	This view is used in deriving the Tax Exemption details defined for Customer/Customer Sites.
`OE_TAX_LINES_SUMMARY_V`	This view is used by Tax Engine to calculate the Tax on order line.
`OE_TAX_LINES_SUMMARY_V_A`	This view is used by Tax Engine to calculate the Tax on order line when theexternal Tax Vendor "Taxware" is used.
`OE_TAX_LINES_SUMMARY_V_V`	view is used by Tax Engine to calculate the Tax on order line when theexternal TaxVendor "Vertex" is used.
`OE_TRANSACTION_TYPES_V`
`OE_TRANSACTION_TYPES_VL`	MLS transaction types view for an organization.
`OE_TRXT_TYPES_NOORGS_VL`	Org independent VL view for Shipping integration team to get the Order Type name.
`OE_UPGRADE_LOG_V`
`OE_UPGRADE_WF_MULGRP_V`
`OE_UPGRADE_WF_VLD_CYC_V`
`OE_WF_LINE_ASSIGN_V`	View to show workflow assignments for a line transaction type and is used by UI.
`OE_WF_ORDER_ASSIGN_V`	View to show workflow assignments for a order transaction type and is used by UI.
`OE_WIP_OPEN_DEMANDS_V`
`ONT_PRT_BILL_TO_ADDR_V`
`ONT_PRT_CST_MARGIN_SUMMARY_V`