Results for “org_freight_code_val_v”

2 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.ORG_FREIGHT_CODE_VAL_V view is a validation-oriented database object delivered as part of the Oracle Purchasing (PO) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes organization-specific freight code definitions for use by the Oracle ETRM (E-Business Suite Technology Reference Model) and related validation logic. Its documented status is VALID in the APPS schema, and the ETRM metadata describes it as "Retrofitted," indicating that the object was reintroduced or regenerated to maintain compatibility across release levels, particularly between 12.1.1 and 12.2.2.

Functionally, the view serves as a filtered validation source for freight codes. Rather than exposing every row recorded in the underlying freight code table, it limits output to those codes that remain active as of the current system date. This makes it suitable for value-set validation, list-of-values (LOV) population, and reporting where only enabled freight codes should be selectable or displayed.

Underlying Base Objects

According to the documented view text, ORG_FREIGHT_CODE_VAL_V is defined over a single referenced base object: the ORG_FREIGHT synonym. The ETRM metadata lists Referenced base objects: ORG_FREIGHT (SYNONYM), confirming that the view does not aggregate multiple tables but instead projects a subset of columns and rows from that object. The ORG_FREIGHT synonym typically resolves to an underlying organization-level freight table within the Purchasing schema, keyed by organization, so that freight terms can be validated per operating unit or inventory organization.

Key Columns

The view exposes exactly three columns as documented in the ETRM view text:

  • FREIGHT_CODE — The identifier of the freight code or freight term. This is the primary value validated and selected by consuming forms, value sets, and interfaces.
  • DESCRIPTION — The descriptive text associated with the freight code, providing human-readable meaning for selection lists and reports.
  • ORGANIZATION_ID — The organization identifier that scopes each freight code to a specific inventory or operating organization, supporting multi-organization validation.

No additional columns are documented. The row set is constrained by the WHERE clause NVL(DISABLE_DATE, SYSDATE + 1) > SYSDATE, which excludes any freight code whose disable date has passed, while treating a null disable date as perpetually valid.

Common Use Cases and Queries

Typical usages include freight code validation in purchasing document entry, freight term LOVs, organization-scoped reference data extracts, and integration lookups where only currently enabled freight codes are acceptable. Because validation is date-driven, scheduled reports against this view automatically reflect codes that remain active.

A representative query returning all enabled freight codes is:

  • SELECT freight_code, description, organization_id FROM apps.org_freight_code_val_v;

To restrict results to a single organization, the query becomes:

  • SELECT freight_code, description FROM apps.org_freight_code_val_v WHERE organization_id = :p_org_id;

For integration or interface loading, joining this view to purchasing document lines allows the source system to verify that a submitted freight code is valid for the referenced organization at the time of processing. Developers should note that only three columns are exposed; any need for disable dates or other freight attributes requires querying the underlying ORG_FREIGHT object directly.