Results for “ec_code”

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

Overview

JAI_CMN_ORG_DTLS_V is an APPS-owned database view shipped with the JA (Asia/Pacific Localizations) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It provides a consolidated, region-specific inventory of organizations that participate in the Asia/Pacific localization flows, exposing each organization alongside its "EC Code" (Excise/Customs registration code) and an organization-type classification. The view is a UNION ALL of two branches: one returning manufacturing organizations (identified from JAI_CMN_INVENTORY_ORGS.EC_CODE) and one returning trading organizations (identified from JAI_CMN_INVENTORY_ORGS.TR_EC_CODE). Each branch restricts results to master organizations (MASTER_ORG_FLAG = 'Y') and filters by manufacturing/trading flags, and each branch discards rows where the relevant EC code is null.

Its primary role is to support localization reporting, statutory extracts, and downstream integrations that require a clean list of organizations with valid excise/customs registrations. Because the underlying organization flags are maintained in a localization setup table rather than the standard organization definition, this view abstracts that logic so developers and report writers do not need to reproduce the flag conditions.

Underlying Base Objects

The view is defined over the following documented base objects:

• JAI_CMN_INVENTORY_ORGS (SYNONYM) — the localization setup table holding EC_CODE, TR_EC_CODE, ORGANIZATION_ID, LOCATION_ID, and the manufacturing/trading indicators. This is the driving table and the source of the EC Code values.
• ORG_ORGANIZATION_DEFINITIONS (VIEW) — supplies ORGANIZATION_CODE, ORGANIZATION_NAME, and ORGANIZATION_ID, and its MASTER_ORG_FLAG column is used to restrict rows to master organizations.
• HR_LOCATIONS (VIEW) — supplies LOCATION_CODE via an outer join on LOCATION_ID, so organizations without a defined location still appear with a null location code.
• HR_GENERAL and HR_SECURITY (PACKAGE) — referenced for the location view's underlying security and utility logic, not directly filtered by the view text.

The joins are: JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID = ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_ID, and JAI_CMN_INVENTORY_ORGS.LOCATION_ID = HR_LOCATIONS.LOCATION_ID (+). The outer join symbol (+) preserves rows even when no matching location exists.

Key Columns

• EC_CODE — the excise/customs registration code. For manufacturing rows this is EC_CODE; for trading rows it is TR_EC_CODE. The union aligns both into a single column, and rows with a null value are excluded.
• ORGANIZATION_CODE — the organization's short code from ORG_ORGANIZATION_DEFINITIONS.
• ORGANIZATION_NAME — the descriptive organization name.
• ORGANIZATION_ID — the unique organization identifier, used as the join key to other EBS entities.
• LOCATION_CODE — the location code from HR_LOCATIONS; may be null due to the outer join.
• ORGTYPE — a literal discriminator, either 'MANUFACTURING' or 'TRADING', indicating which branch produced the row.

Note that the manufacturing branch labels its organization code column as ORAGNIZATION_CODE (a typographical variant); the union nevertheless resolves to the standard ORGANIZATION_CODE column name.

Common Use Cases and Queries

Typical scenarios include listing organizations eligible for excise reporting, validating that an organization has a populated EC code before a statutory extract, and separating manufacturing from trading entities for tax documentation. A representative query is:

• List all localization organizations: SELECT ec_code, organization_code, organization_name, organization_id, location_code, orgtype FROM apps.jai_cmn_org_dtls_v;
• Filter manufacturing organizations: SELECT organization_code, ec_code FROM apps.jai_cmn_org_dtls_v WHERE orgtype = 'MANUFACTURING';
• Filter trading organizations: SELECT organization_code, ec_code FROM apps.jai_cmn_org_dtls_v WHERE orgtype = 'TRADING';
• Resolve an organization by ID: SELECT ec_code, orgtype FROM apps.jai_cmn_org_dtls_v WHERE organization_id = :p_org_id;

Because the view already enforces the master-organization and flag conditions and removes null EC codes, consumers can query it directly without re-implementing those filters, reducing the risk of inconsistent localization output across reports.