Results for “invbv_freight_carriers”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
INVBV_FREIGHT_CARRIERS is a read-only Oracle EBS view owned by the APPS schema and classified under the INV (Inventory) product family. It presents freight carrier information, also referred to as freight codes, that is maintained for inventory organizations. In the Oracle E-Business Suite data model, freight carriers represent the parties or services used to ship goods, along with the accounting relationship used to record freight-related charges. This view exposes that data in a denormalized, report-friendly format so that carriers can be queried without directly accessing the underlying transactional table.
The view is secured. Its defining query includes a predicate of the form '_SEC:MOF.ORGANIZATION_ID' IS NOT NULL, which is the standard Oracle EBS mechanism for applying organization-level security through the MO (Organization Security) profile. As a result, a user querying this view only sees freight carrier rows for the inventory organizations to which that user is granted access. The view is defined WITH READ ONLY, so it supports query and reporting operations only; it cannot be used for inserts, updates, or deletions.
Underlying Base Objects
According to the documented ETRM metadata, INVBV_FREIGHT_CARRIERS is defined over a single referenced base object, ORG_FREIGHT, which is accessed through a synonym. The view text confirms a direct projection from ORG_FREIGHT (aliased MOF), with every exposed column sourced from that table. Because the view wraps a single base table with a security predicate and a read-only clause, it functions as a controlled, security-filtered presentation layer rather than as a join or aggregation view.
ORG_FREIGHT stores freight carrier definitions keyed by freight code and organization. Managing carriers in the base table and consuming them through INVBV_FREIGHT_CARRIERS ensures that reports and integrations automatically inherit the organization security rules configured in the EBS instance.
Key Columns
- CARRIER_NAME — The freight carrier code, corresponding to the FREIGHT_CODE column in ORG_FREIGHT; the primary business identifier for a carrier.
- ORGANIZATION_ID — The inventory organization to which the carrier definition belongs; the column governed by the view's security predicate.
- DESCRIPTION — A descriptive name or free-text explanation of the carrier or freight service.
- INACTIVE_DATE — The date from which the carrier is disabled; sourced from DISABLE_DATE.
- DISTRIBUTION_ACCOUNT — The accounting flexfield combination used to charge freight costs for this carrier.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns recording who created and last modified the carrier record and when.
Common Use Cases and Queries
This view is typically used for carrier lists in reports, validation queries in interfaces, and reconciliation of freight accounting setups across organizations. A common query lists active carriers for accessible organizations:
- SELECT carrier_name, organization_id, description, distribution_account FROM apps.invbv_freight_carriers;
- SELECT carrier_name, inactive_date FROM apps.invbv_freight_carriers WHERE inactive_date IS NULL;
- SELECT organization_id, carrier_name FROM apps.invbv_freight_carriers ORDER BY organization_id, carrier_name;
Because organization security is applied automatically, developers need not add their own organization filter, although an explicit ORGANIZATION_ID predicate can still be supplied for a targeted report. The read-only nature of the view means any maintenance of carrier data must be performed against ORG_FREIGHT through supported Inventory forms or APIs, not through this view.
-
View: INVBV_FREIGHT_CARRIERS 12.1.1
APPS.INVBV_FREIGHT_CARRIERS·↳ ORG_FREIGHT·Explore INV module →
-
View: INVBV_FREIGHT_CARRIERS 12.2.2
APPS.INVBV_FREIGHT_CARRIERS·↳ ORG_FREIGHT·Explore INV module →
-
SYNONYM: APPS.ORG_FREIGHT 12.1.1
-
SYNONYM: APPS.ORG_FREIGHT 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - INV Tables and Views 12.2.2
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.1.1
-
eTRM - INV Tables and Views 12.2.2