Search Results conc_company_cc_segments

Overview

The APPS.HR_COMPANY_COST_CENTERS view is a supplementary database object in Oracle E-Business Suite, owned by the APPS schema and registered under the FND Design Data identifier PER.HR_COMPANY_COST_CENTERS. Oracle classifies it as a "supplementary view used to simplify forms coding," and explicitly warns that it is not intended for direct querying or data manipulation because its definition may change dramatically across minor or major releases. In 12.1.1 and 12.2.2 the object retains a VALID status in the data dictionary.

Functionally, the view flattens Human Resources organization classification data into a reporting-friendly shape that associates a business group and organization with a concatenated company and cost center segment string. The presence of the CONC_COMPANY_CC_SEGMENTS column, and of a search term of the same name, indicates that the view's principal purpose is to expose the concatenated company/cost-center key derived from organization information flexibilities. It is used primarily by Oracle Forms-based HR setup screens and by downstream reporting and integration views.

Underlying Base Objects

The view is defined over three documented base objects, all referenced through APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS — the core organization definition table supplying ORGANIZATION_ID, BUSINESS_GROUP_ID, and effective dating columns.
• HR_ALL_ORGANIZATION_UNITS_TL — the translation table supplying the organization NAME.
• HR_ORGANIZATION_INFORMATION — the key flexfield and descriptive flexfield repository holding organization information types, including the company and cost center segment values surfaced as COMPANY_VS, COMPANY_CODE, COST_CENTER_VS, COST_CENTER_CODE, and CONC_COMPANY_CC_SEGMENTS.

The view is itself referenced by APPS.FII_LOB_ASSIGNMENTS_V and is published as a PUBLIC synonym HR_COMPANY_COST_CENTERS, which allows external schemas and custom code to address it without schema qualification. Because the join relies on effective-dated organization rows, the view returns a date-bounded snapshot controlled by DATE_FROM and DATE_TO.

Key Columns

• BUSINESS_GROUP_ID (NUMBER 15) — identifies the HR business group, the top-level security and legislative grouping.
• ORGANIZATION_ID (NUMBER 15) — the organization unit identifier used to join to inventory, HR, and other EBS entities.
• NAME (VARCHAR2 240) — the translated organization name.
• DATE_FROM / DATE_TO (DATE) — effective start and end dates of the organization record.
• COMPANY_VS (VARCHAR2 150) — the value set identifier qualifying the company segment.
• COMPANY_CODE (VARCHAR2 150) — the company segment value.
• COST_CENTER_VS (VARCHAR2 150) — the value set identifier qualifying the cost center segment.
• COST_CENTER_CODE (VARCHAR2 150) — the cost center segment value.
• CONC_COMPANY_CC_SEGMENTS (VARCHAR2 150) — the concatenated company and cost center segment representation, the column most commonly targeted by searches such as conc_company_cc_segments.

Common Use Cases and Queries

The view is typically consumed to resolve an organization to its company and cost center accounting identity, frequently as an intermediate step before feeding general ledger or project accounting logic. A basic query listing active organizations follows:

• SELECT organization_id, name, company_code, cost_center_code, conc_company_cc_segments FROM apps.hr_company_cost_centers WHERE business_group_id = :p_bg_id AND SYSDATE BETWEEN date_from AND NVL(date_to, SYSDATE);
• SELECT organization_id, conc_company_cc_segments FROM apps.hr_company_cost_centers WHERE conc_company_cc_segments LIKE '01%';

Because Oracle discourages direct querying of supplementary views, production code should preferably resolve the same data from HR_ORGANIZATION_INFORMATION and HR_ALL_ORGANIZATION_UNITS directly, treating HR_COMPANY_COST_CENTERS as a convenience layer only.