Results for “oragnization_code”

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

Overview

APPS.JAI_CMN_ORG_DTLS_V is a custom Oracle E-Business Suite view delivered as part of the India localization (JAI) module, which supports statutory reporting requirements for Indian operations. The view consolidates inventory organization details and classifies each organization as either a manufacturing or a trading entity. It is defined as a UNION ALL of two distinct queries, one returning manufacturing organizations and the other returning trading organizations, so that the result set presents a unified list of valid organizational entities along with their corresponding excise registration identifiers.

The view is commonly referenced in localization reporting, excise and VAT-related setup validation, and integration routines where downstream processes must resolve the correct organization together with its manufacturing or trading classification. Because the result set is filtered on the MASTER_ORG_FLAG attribute, only organizations flagged as master organizations are returned, which is significant for users who search on this term.

Underlying Base Objects

The documented base objects referenced by this view are:

• JAI_CMN_INVENTORY_ORGS (SYNONYM) — the localization table holding inventory organization setup, including ORGANIZATION_ID, LOCATION_ID, EC_CODE, TR_EC_CODE, MASTER_ORG_FLAG, MANUFACTURING, and TRADING flags.
• ORG_ORGANIZATION_DEFINITIONS (VIEW) — the standard inventory organization definition view supplying ORGANIZATION_CODE, ORGANIZATION_NAME, and ORGANIZATION_ID.
• HR_LOCATIONS (VIEW) — supplies LOCATION_CODE, joined via an outer join (HRL.LOCATION_ID(+)), so organizations without a defined location still appear.
• HR_GENERAL (PACKAGE) and HR_SECURITY (PACKAGE) — standard HR security infrastructure referenced by the underlying HR views to enforce organization-level security access.

Key Columns

• EC_CODE — the excise registration code. In the manufacturing branch it comes from JHR.EC_CODE; in the trading branch it comes from JHR.TR_EC_CODE. The EC_CODE IS NOT NULL filter ensures only registered organizations are returned.
• ORAGNIZATION_CODE — the organization code from ORG_ORGANIZATION_DEFINITIONS (note the documented misspelling in the first branch alias).
• ORGANIZATION_NAME — the descriptive name of the inventory organization.
• ORGANIZATION_ID — the unique identifier of the organization, used as the join key across all three base objects.
• LOCATION_CODE — the location code sourced from HR_LOCATIONS.
• ORGTYPE — a literal value of 'Manufacturing' or 'Trading' that identifies which branch produced the row.

Common Use Cases and Queries

The view is typically queried to obtain a list of valid manufacturing or trading organizations for a given localization setup, or to look up the excise code associated with an organization. Typical SQL statements include:

• Retrieving all manufacturing organizations: SELECT * FROM APPS.JAI_CMN_ORG_DTLS_V WHERE ORGTYPE = 'Manufacturing';
• Retrieving trading organizations only: SELECT * FROM APPS.JAI_CMN_ORG_DTLS_V WHERE ORGTYPE = 'Trading';
• Resolving the excise code for one organization: SELECT EC_CODE, ORGTYPE FROM APPS.JAI_CMN_ORG_DTLS_V WHERE ORGANIZATION_ID = :p_org_id;

Because the view enforces NVL(MASTER_ORG_FLAG,'N')='Y', only organizations designated as master organizations appear, and the manufacturing branch additionally requires MANUFACTURING='Y' and TRADING='N', while the trading branch requires the inverse combination. This makes the view a reliable single source for organization classification in Indian localization reporting.