Search Results obj_sic_code

Overview

CSC_HZ_ORG_PROFILES_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the CSC — Customer Care product family and presents a consolidated, denormalized projection of organization-level party data drawn from the Oracle Trading Community Architecture (TCA) model. Its stated purpose is to retrieve organization details of a party, combining core party identity attributes with the extended organization profile attributes maintained in the TCA organization profile entity.

The view is documented as VALID and is principally consumed by Customer Care and related CRM-style extensions that require a flat, single-row representation of an organization party. Rather than forcing callers to join the party header and the organization profile separately — and to reproduce the effective-dating filter by hand — the view encapsulates that logic. This makes it suitable for reporting, concurrent program data sources, and integration extracts where a stable, pre-joined organizational snapshot is preferable to ad hoc TCA joins.

Underlying Base Objects

Per the ETRM metadata for 12.2.2, the view is defined over two referenced base objects, both exposed to APPS through synonyms: HZ_ORGANIZATION_PROFILES and HZ_PARTIES. The view text aliases these as ORG_PROFILE and PARTY respectively.

HZ_PARTIES supplies the party-level identity attributes: PARTY_ID, PARTY_NAME, KNOWN_AS, SIC_CODE, and CATEGORY_CODE.
HZ_ORGANIZATION_PROFILES supplies the organization-specific profile attributes: ANALYSIS_FY, FISCAL_YEAREND_MONTH, EMPLOYEES_TOTAL, CURR_FY_POTENTIAL_REVENUE, NEXT_FY_POTENTIAL_REVENUE, TAX_REFERENCE, YEAR_ESTABLISHED, INTERNAL_FLAG, PUBLIC_PRIVATE_OWNERSHIP_FLAG, DUNS_NUMBER, JGZZ_FISCAL_CODE, LINE_OF_BUSINESS, DUNS_NUMBER_C, and LAST_UPDATE_DATE.

The join is an equi-join on PARTY_ID. The view restricts results to rows where PARTY.PARTY_TYPE = 'ORGANIZATION', and it applies an effective-dating predicate on the profile: it returns rows where EFFECTIVE_END_DATE is null, or where the current system date falls between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. This yields only the currently effective organization profile for each party.

Key Columns

Although the view text selects TCA column names, the documented column list presents the view's exposed interface names, which differ and must be used when querying the view:

OBJECT_ID — the organization party identifier (mapped from PARTY_ID); the primary join key to other party-based views.
OBJ_ALIAS and OBJ_COMPANY_NAME — the known-as alias and the formal party name.
OBJ_SIC_CODE and CATEGORY_CODE — industry classification and party category.
OBJ_ANALYSIS_FY, OBJ_FISCAL_YEAREND_MONTH, OBJ_YEAR_ESTABLISHED — fiscal and establishment attributes.
OBJ_NUM_OF_EMPLOYEES — total employee headcount.
OBJ_POT_REVENUE_CURR_FY and OBJ_POT_REVENUE_NEXT_FY — potential revenue for the current and next fiscal year.
OBJ_TAX_REFERENCE and OBJ_JGZZ_FISCAL_CODE — tax registration identifiers.
OBJ_INTERNAL_FLAG and OBJ_PUB_PRIVATE_OWNER_FLAG — internal-party and ownership indicators.
OBJ_DUNS_NUMBER and OBJ_DUNS_NUMBER_C — D-U-N-S number and its cleaned counterpart.
LINE_OF_BUSINESS and ORGPR_LAST_UPDATE_DATE — line of business and the profile's last update timestamp.

Common Use Cases and Queries

The view is commonly used to populate organization search results, account detail regions, and outbound extracts that need firmographic data (employees, revenue potential, D-U-N-S, year established) without navigating the effective-dated TCA profile table. A typical query retrieving organization details by party identifier:

SELECT object_id, obj_company_name, obj_alias, obj_num_of_employees, obj_duns_number, line_of_business FROM csc_hz_org_profiles_v WHERE object_id = :p_party_id;
Filtering by name or D-U-N-S for account lookups: SELECT object_id, obj_company_name FROM csc_hz_org_profiles_v WHERE upper(obj_company_name) LIKE upper(:p_name)||'%';
Reporting on revenue potential and headcount by line of business: SELECT line_of_business, count(*), sum(obj_num_of_employees) FROM csc_hz_org_profiles_v GROUP BY line_of_business;

Because only effective profile rows are returned and party type is constrained to 'ORGANIZATION', consumers need not repeat either predicate. Note that the view is read-only; DML must target the underlying TCA entities, and responsibility-level security on parties still governs visibility of the returned rows.

View: CSC_HZ_ORG_PROFILES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CSC.CSC_HZ_ORG_PROFILES_V, object_name:CSC_HZ_ORG_PROFILES_V, status:VALID, product: CSC - Customer Care , description: View of HZ_ORGANIZATION, HZ_PARTIES. This view is used to get organization details of a party , implementation_dba_data: APPS.CSC_HZ_ORG_PROFILES_V ,
View: CSC_HZ_ORG_PROFILES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CSC.CSC_HZ_ORG_PROFILES_V, object_name:CSC_HZ_ORG_PROFILES_V, status:VALID, product: CSC - Customer Care , description: View of HZ_ORGANIZATION, HZ_PARTIES. This view is used to get organization details of a party , implementation_dba_data: APPS.CSC_HZ_ORG_PROFILES_V ,
View: CSC_HZ_PARTIES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CSC.CSC_HZ_PARTIES_V, object_name:CSC_HZ_PARTIES_V, status:VALID, product: CSC - Customer Care , description: View of HZ_PARTIES, HZ_PARTY_RELATIONSHIPS. This view is used to get party relationships details , implementation_dba_data: APPS.CSC_HZ_PARTIES_V ,
View: CSC_HZ_PARTIES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CSC.CSC_HZ_PARTIES_V, object_name:CSC_HZ_PARTIES_V, status:VALID, product: CSC - Customer Care , description: View of HZ_PARTIES, HZ_PARTY_RELATIONSHIPS. This view is used to get party relationships details , implementation_dba_data: APPS.CSC_HZ_PARTIES_V ,
View: CSC_HZ_PARTIES_SELF_NEW_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CSC.CSC_HZ_PARTIES_SELF_NEW_V, object_name:CSC_HZ_PARTIES_SELF_NEW_V, status:VALID, product: CSC - Customer Care , description: View of HZ_PARTIES, HZ_RELATIONSHIPS. This view is used in Contact center form to get party relationships details along with self party relationship details (Fetches data from the new Relationships model) , implementation_dba_data: APPS.CSC_HZ_PARTIES_SELF_NEW_V ,
View: CSC_HZ_PARTIES_SELF_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CSC.CSC_HZ_PARTIES_SELF_V, object_name:CSC_HZ_PARTIES_SELF_V, status:VALID, product: CSC - Customer Care , description: View of HZ_PARTIES, HZ_PARTY_RELATIONSHIPS. This view is used in Contact center form to get party relationships details along with self party relationship details , implementation_dba_data: APPS.CSC_HZ_PARTIES_SELF_V ,
View: CSC_CUSTOMER_RESPONSE_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:CSC.CSC_CUSTOMER_RESPONSE_V, object_name:CSC_CUSTOMER_RESPONSE_V, status:VALID, product: CSC - Customer Care , description: Contains Relationship information, Subject (Caller) and Object (Person/Group/Organization) information , implementation_dba_data: APPS.CSC_CUSTOMER_RESPONSE_V ,
View: CSC_HZ_PARTIES_SELF_NEW_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CSC.CSC_HZ_PARTIES_SELF_NEW_V, object_name:CSC_HZ_PARTIES_SELF_NEW_V, status:VALID, product: CSC - Customer Care , description: View of HZ_PARTIES, HZ_RELATIONSHIPS. This view is used in Contact center form to get party relationships details along with self party relationship details (Fetches data from the new Relationships model) , implementation_dba_data: APPS.CSC_HZ_PARTIES_SELF_NEW_V ,
View: CSC_CUSTOMER_RESPONSE_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CSC.CSC_CUSTOMER_RESPONSE_V, object_name:CSC_CUSTOMER_RESPONSE_V, status:VALID, product: CSC - Customer Care , description: Contains Relationship information, Subject (Caller) and Object (Person/Group/Organization) information , implementation_dba_data: APPS.CSC_CUSTOMER_RESPONSE_V ,
View: CSC_HZ_PARTIES_SELF_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:CSC.CSC_HZ_PARTIES_SELF_V, object_name:CSC_HZ_PARTIES_SELF_V, status:VALID, product: CSC - Customer Care , description: View of HZ_PARTIES, HZ_PARTY_RELATIONSHIPS. This view is used in Contact center form to get party relationships details along with self party relationship details , implementation_dba_data: APPS.CSC_HZ_PARTIES_SELF_V ,