Search Results obj_tax_reference

Overview

APPS.CSC_HZ_ORG_PROFILES_V is a supplementary database view registered in the Oracle E-Business Suite Applications (APPS) schema. Its FND Design Data identifier is CSC.CSC_HZ_ORG_PROFILES_V, and its documented status is VALID. The object is defined as a "supplementary view used to simplify forms coding," which places it in the class of views Oracle builds to flatten and rename underlying TCA (Trading Community Architecture) columns for consumption by Oracle Forms-based application windows rather than for ad hoc reporting or integration development.

Oracle explicitly warns that this view should not be queried or altered directly, because its definition may change substantially in subsequent minor or major releases. In EBS 12.1.1 and 12.2.2 the object remains part of the Customer/Party (CSC) forms support layer surrounding the HZ schema. It exposes organization-level profile attributes — SIC codes, DUNS numbers, employee counts, revenue estimates, tax references, and fiscal characteristics — through column aliases prefixed with "OBJ_", which map to the equivalent "ORG_" attributes in the underlying HZ tables.

Underlying Base Objects

The documented referenced base objects are HZ_ORGANIZATION_PROFILES and HZ_PARTIES, both accessed through synonyms in the APPS schema. HZ_PARTIES is the master entity table in TCA and supplies the party identity, while HZ_ORGANIZATION_PROFILES stores the organization-specific extension of that party record, including financial, classification, and demographic data. The view therefore joins or projects the two to present a single organization profile row keyed by OBJECT_ID, which is documented as the party identifier and a foreign key to HZ_PARTIES.

Because the view is a CSC-layer forms simplification object rather than a documented public interface, its column list and join conditions are subject to change without notice, reinforcing Oracle's recommendation that supported interfaces such as the TCA APIs or the HZ_ORGANIZATION_PROFILES base table be used for programmatic access.

Key Columns

OBJECT_ID (NUMBER(15)) — Party identifier; foreign key to HZ_PARTIES.
OBJ_DUNS_NUMBER (NUMBER) — The unique nine-digit identification number assigned to a business entity by Dun & Bradstreet. This is the column associated with the search term "obj_duns_number" and is the primary DUNS attribute exposed by the view.
OBJ_DUNS_NUMBER_C (VARCHAR2(30)) — A character-format counterpart of the DUNS number; the metadata excerpt is truncated after the description.
OBJ_COMPANY_NAME (VARCHAR2(360)) — Party name of the organization.
OBJ_ALIAS (VARCHAR2(240)) — An alternate name by which the party is known.
OBJ_SIC_CODE (VARCHAR2(30)) — Standard Industry Classification code.
OBJ_TAX_REFERENCE (VARCHAR2(50)) — Taxpayer identification number.
OBJ_NUM_OF_EMPLOYEES (NUMBER) — Total number of employees.
OBJ_POT_REVENUE_CURR_FY / OBJ_POT_REVENUE_NEXT_FY (NUMBER) — Potential revenue for the current and next fiscal year.
OBJ_ANALYSIS_FY, OBJ_FISCAL_YEAREND_MONTH — Fiscal year basis and fiscal year-end month.
OBJ_YEAR_ESTABLISHED (NUMBER) — Year the organization began doing business.
OBJ_INTERNAL_FLAG (VARCHAR2) — Y for internal, N for external organizations.
OBJ_PUB_PRIVATE_OWNER_FLAG (VARCHAR2) — Y if private ownership, N if public.
OBJ_JGZZ_FISCAL_CODE (VARCHAR2(20)) — Fiscal Code used for certain European countries.
ORGPR_LAST_UPDATE_DATE (DATE) — Standard WHO audit column.
LINE_OF_BUSINESS (VARCHAR2(240)) and CATEGORY_CODE (VARCHAR2(30)) — Business activity type and a user-definable customer category lookup.

Common Use Cases and Queries

The principal practical use of this view is read-only diagnostic and reporting access to organization profile attributes in a forms-friendly layout, most commonly to retrieve DUNS numbers, SIC codes, or employee and revenue figures for a party. A typical query might join the view to HZ_PARTIES or HZ_CUST_ACCOUNTS to correlate the organization profile with customer accounts. For example:

SELECT object_id, obj_company_name, obj_duns_number, obj_sic_code, obj_num_of_employees FROM apps.csc_hz_org_profiles_v WHERE obj_duns_number IS NOT NULL;

Because Oracle designates the object a supplementary forms view, production integrations should instead read from HZ_ORGANIZATION_PROFILES or use the supported TCA APIs, reserving queries against CSC_HZ_ORG_PROFILES_V for investigation, troubleshooting, and reference purposes only. This mitigates the risk of breakage across EBS minor and major upgrades between 12.1.1 and 12.2.2.

VIEW: APPS.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,
VIEW: APPS.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,
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: APPS.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,
VIEW: APPS.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,
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_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: APPS.JTF_PARTIES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:JTF.JTF_PARTIES_V, object_name:JTF_PARTIES_V, status:VALID,
VIEW: APPS.JTF_PARTIES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JTF.JTF_PARTIES_V, object_name:JTF_PARTIES_V, status:VALID,
View: JTF_PARTIES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:JTF.JTF_PARTIES_V, object_name:JTF_PARTIES_V, status:VALID, product: JTF - CRM Foundation , description: Party (Organization or Group or Person) and relationship information , implementation_dba_data: APPS.JTF_PARTIES_V ,
View: JTF_PARTIES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:JTF.JTF_PARTIES_V, object_name:JTF_PARTIES_V, status:VALID, product: JTF - CRM Foundation , description: Party (Organization or Group or Person) and relationship information , implementation_dba_data: APPS.JTF_PARTIES_V ,
eTRM - CSC Tables and Views 12.2.2
description: Translation table to Store Drilldown details for a profile variable. This stores the column and table names for the drilldown form. Also stores the object_code, which provides the form_function to drilldown ,
eTRM - CSC Tables and Views 12.1.1
description: Translation table to Store Drilldown details for a profile variable. This stores the column and table names for the drilldown form. Also stores the object_code, which provides the form_function to drilldown ,
eTRM - JTF Tables and Views 12.2.2
description: Interface table to store data that needs to be displayed in Excel ,
eTRM - JTF Tables and Views 12.1.1
description: Interface table to store data that needs to be displayed in Excel ,