Results for “sold_from_org_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OE_AK_DELIVER_TO_ORGS_V is a view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the ONT (Order Management) product family. Its purpose is to present delivery-related organization attributes for a customer's deliver-to organization, augmented with the corresponding Bill-To site use information. The "AK" prefix in the name follows the historical Oracle order-entry attribute interface ("AK" attributes) conventions that appear throughout Order Management and its related region-functionality.
The view is documented as a VALID object in the ETRM repository for both 12.1.1 and 12.2.2. Because it consolidates shipping, freight, pricing, and billing attributes in a single denormalized row, it serves as a convenient read-only source for reporting, integrations, and lookups where a flat deliver-to/Bill-To perspective is required.
Underlying Base Objects
The documented definition references two objects:
- OE_DELIVER_TO_ORGS_V (VIEW) — the primary driving source, supplying the deliver-to organization's shipping, freight, pricing, and contact attributes.
- HZ_CUST_SITE_USES_ALL (referenced via SYNONYM) — the Trading Community Architecture site-use table, providing the Bill-To site use link.
The two objects are joined with an outer join so that a deliver-to record contributes a row even when no active Bill-To site use exists. The join predicate restricts the TCA side to site-use code 'BILL_TO' and status 'A' (active), thereby ensuring only active Bill-To accounts are matched. The driver side, OE_DELIVER_TO_ORGS_V, is itself a view in the Order Management schema, meaning OE_AK_DELIVER_TO_ORGS_V is a view-over-view layered on TCA data.
Key Columns
The view exposes the following columns, most of which correspond to order-entry attributes controlled at the deliver-to level:
- ORGANIZATION_ID — identifier of the deliver-to customer organization.
- PRICE_LIST_ID — default price list associated with the deliver-to organization.
- FOB_POINT_CODE — Free On Board point used for shipping determinations.
- FREIGHT_TERMS_CODE — default freight terms for orders shipped to this organization.
- SHIP_PARTIAL_ALLOWED — flag indicating whether partial shipments are permitted.
- SHIPPING_METHOD_CODE — default shipping method.
- CONTACT_ID — contact associated with the deliver-to record.
- SOLD_FROM_ORG_ID — operating unit/organization that owns the sale.
- SHIP_FROM_ORG_ID — default shipping warehouse organization.
- BILL_TO_SITE_USE_ID — the Bill-To site use identifier supplied by the TCA side.
- INVOICE_TO_ORG_ID — the site-use identifier exposed as the invoice-to organization reference (the alias applied to INV_TO.SITE_USE_ID).
Common Use Cases and Queries
Typical usages include resolving default shipping and freight attributes for a customer organization, reconciling deliver-to records with their active Bill-To site uses, and populating Order Management integration payloads. A representative query retrieving active Bill-To mappings is shown below.
SELECT organization_id, price_list_id, fob_point_code, freight_terms_code, shipping_method_code, sold_from_org_id, ship_from_org_id, bill_to_site_use_id, invoice_to_org_id FROM apps.oe_ak_deliver_to_orgs_v WHERE organization_id = :p_org_id;
Because the join to HZ_CUST_SITE_USES_ALL is an outer join, consumers should test BILL_TO_SITE_USE_ID and INVOICE_TO_ORG_ID for null values when a deliver-to organization has no active Bill-To site use; such rows still surface the deliver-to attributes. When only active Bill-To data is wanted, an additional predicate such as bill_to_site_use_id IS NOT NULL should be applied. As with all APPS views, direct updates are not supported; changes must be made to the underlying Order Management and TCA entities.
-
APPS.OE_AK_DELIVER_TO_ORGS_V·↳ HZ_CUST_SITE_USES_ALL·↳ OE_DELIVER_TO_ORGS_V·Explore ONT module →
-
APPS.OE_AK_DELIVER_TO_ORGS_V·↳ HZ_CUST_SITE_USES_ALL·↳ OE_DELIVER_TO_ORGS_V·Explore ONT module →
-
View: OE_AK_SHIP_TO_ORGS_V 12.1.1
APPS.OE_AK_SHIP_TO_ORGS_V·↳ HZ_CUST_SITE_USES·↳ HZ_CUST_SITE_USES_ALL·Explore ONT module →
-
View: WSH_OE_LINES_V2 12.2.2
APPS.WSH_OE_LINES_V2·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_ALL·Explore WSH module →
-
View: OE_CRM_ORDER_HEADERS_V 12.2.2
Compatible view provoded for CRM usage only. The view is based on oe_order_headers_all table.
APPS.OE_CRM_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ONT module →
-
View: OE_CRM_ORDER_HEADERS_V 12.1.1
Compatible view provoded for CRM usage only. The view is based on oe_order_headers_all table.
APPS.OE_CRM_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ONT module →
-
View: OE_SHIP_TO_ORGS_V 12.1.1
Ship To Organizations.
APPS.OE_SHIP_TO_ORGS_V·↳ HZ_CUST_ACCT_SITES·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
This view includes all columns from the Oracle Order Management tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ASO module →
-
View: WMS_SHIP_TO_SITES_V 12.1.1
Customer Ship to Site
APPS.WMS_SHIP_TO_SITES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore WMS module →
-
View: WSH_OE_LINES_V2 12.1.1
APPS.WSH_OE_LINES_V2·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_ALL·Explore WSH module →
-
This view includes all columns from the Oracle Order Management tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ASO module →
-
View: OE_CRM_ORDER_LINES_V 12.1.1
Compatible view provoded for CRM usage only. The view is based on oe_order_lines_all table.
APPS.OE_CRM_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ONT module →
-
View: ASO_I_OE_ORDER_LINES_V 12.1.1
This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ASO module →
-
View: OE_AK_SHIP_TO_ORGS_V 12.2.2
APPS.OE_AK_SHIP_TO_ORGS_V·↳ HZ_CUST_SITE_USES·↳ HZ_CUST_SITE_USES_ALL·Explore ONT module →
-
View: WMS_SHIP_TO_SITES_V 12.2.2
Customer Ship to Site
APPS.WMS_SHIP_TO_SITES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore WMS module →
-
View: AMS_DS_ORDERS_V 12.2.2
APPS.AMS_DS_ORDERS_V·↳ HZ_CUST_ACCOUNTS·↳ MTL_DEFAULT_CATEGORY_SETS·↳ MTL_ITEM_CATEGORIES·Explore AMS module →
-
View: OE_LINE_ACKS_V 12.1.1
Information about the acknowledgements for Order Lines
-
View: OE_LINE_ACKS_V 12.2.2
Information about the acknowledgements for Order Lines
-
View: OE_SHIP_TO_ORGS_V 12.2.2
Ship To Organizations.
APPS.OE_SHIP_TO_ORGS_V·↳ HZ_CUST_ACCT_SITES·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_DELIVER_TO_ORGS_V 12.1.1
This view is used to get and validate the delivery to organizations.
APPS.OE_DELIVER_TO_ORGS_V·↳ HZ_CUST_ACCT_SITES·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OE_DELIVER_TO_ORGS_V 12.2.2
This view is used to get and validate the delivery to organizations.
APPS.OE_DELIVER_TO_ORGS_V·↳ HZ_CUST_ACCT_SITES·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: ASO_I_OE_ORDER_LINES_V 12.2.2
This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ASO module →
-
View: OKX_ORDER_LINES_V 12.2.2
Order line information
APPS.OKX_ORDER_LINES_V·↳ ASO_ORDER_INT·↳ OE_ORDER_LINES_ALL·Explore OKX module →
-
View: OE_PRN_ORDER_HEADERS_V 12.1.1
APPS.OE_PRN_ORDER_HEADERS_V·↳ FND_CURRENCIES_TL·↳ FND_CURRENCY·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
View: WSH_OE_LINES_V1 12.2.2
APPS.WSH_OE_LINES_V1·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_ALL·↳ WSH_DELIVERY_ASSIGNMENTS_V·Explore WSH module →
-
View: WSH_OE_LINES_V1 12.1.1
APPS.WSH_OE_LINES_V1·↳ OE_ORDER_HEADERS_ALL·↳ OE_ORDER_LINES_ALL·↳ WSH_DELIVERY_ASSIGNMENTS_V·Explore WSH module →
-
View: OE_PRN_ORDER_HEADERS_V 12.2.2
APPS.OE_PRN_ORDER_HEADERS_V·↳ FND_CURRENCIES_TL·↳ FND_CURRENCY·↳ OE_AGREEMENTS_TL·Explore ONT module →
-
View: OE_AK_ORDER_HEADERS_V 12.1.1
APPS.OE_AK_ORDER_HEADERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_HEADERS_ALL·Explore ONT module →
-
View: OE_BLANKET_HEADERS_V 12.2.2
APPS.OE_BLANKET_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
-
View: OE_ORDER_HEADERS_V 12.2.2
View for Order header used in sales order form.
APPS.OE_ORDER_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_CRM_ORDER_LINES_V 12.2.2
Compatible view provoded for CRM usage only. The view is based on oe_order_lines_all table.
APPS.OE_CRM_ORDER_LINES_V·↳ OE_ORDER_LINES·Explore ONT module →
-
View: OE_BLANKET_HEADERS_V 12.1.1
APPS.OE_BLANKET_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_ORDER_HEADERS_RM_V 12.2.2
APPS.OE_ORDER_HEADERS_RM_V·↳ FND_LANGUAGES·↳ OE_ORDER_HEADERS_ALL·↳ OE_TRANSACTION_TYPES_TL·Explore ONT module →
-
View: OE_ORDER_LINES_HIST_V 12.1.1
APPS.OE_ORDER_LINES_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: OKX_ORDER_LINES_V 12.1.1
Order line information
APPS.OKX_ORDER_LINES_V·↳ ASO_ORDER_INT·↳ OE_ORDER_LINES_ALL·Explore OKX module →
-
View: AMS_DS_ORDERS_V 12.1.1
APPS.AMS_DS_ORDERS_V·↳ HZ_CUST_ACCOUNTS·↳ MTL_DEFAULT_CATEGORY_SETS·↳ MTL_ITEM_CATEGORIES·Explore AMS module →
-
This view is used to retrieve the Order History. This is used by the history form.
APPS.OE_ORDER_HEADERS_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: OE_SCH_ORDER_LINES_V 12.2.2
APPS.OE_SCH_ORDER_LINES_V·↳ AR_LOOKUPS·↳ FND_GLOBAL·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_HEADER_ACKS_V 12.2.2
Information about the acknowledgements for Order Headers.
APPS.OE_HEADER_ACKS_V·↳ ECE_TP_DETAILS·↳ ECE_TP_HEADERS·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_BLANKET_LINES_V 12.1.1
This view is used to get the BSA lines information, used in BSA entry UI.
APPS.OE_BLANKET_LINES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore ONT module →
-
View: OEFV_ORDER_HEADERS 12.2.2
APPS.OEFV_ORDER_HEADERS·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ FND_USER·Explore ONT module →
-
This tables stores information about the acknowledgements for Order Headers.
-
This tables stores information about the acknowledgements for Order Headers.
-
View: OE_ORDER_LINES_HIST_V 12.2.2
APPS.OE_ORDER_LINES_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
Table to capture sales agreement header details..
-
Stores history of attribute change for Order Headers
-
This is a multi-org table for sales order lines open interface.
-
OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
-
View: OE_ORDER_HEADERS_V 12.1.1
View for Order header used in sales order form.
APPS.OE_ORDER_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →