eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CSC_HZ_ORG_PROFILES_V

Object Details

Object Name:	CSC_HZ_ORG_PROFILES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSC.CSC_HZ_ORG_PROFILES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER	(15)	Yes	Party identifier. FK to HZ_PARTIES
OBJ_SIC_CODE	VARCHAR2	(30)		Standard Industry Classification Code
OBJ_ALIAS	VARCHAR2	(240)		An alias or other name by which a party is known
OBJ_COMPANY_NAME	VARCHAR2	(360)	Yes	Party name
OBJ_ANALYSIS_FY	VARCHAR2	(5)		Fiscal Year upon which financial information is based (net worth, number of employees, potential revenue.)
OBJ_FISCAL_YEAREND_MONTH	VARCHAR2	(30)		Potential revenue this fiscal year for organization.
OBJ_NUM_OF_EMPLOYEES	NUMBER			Total number of employees
OBJ_POT_REVENUE_CURR_FY	NUMBER			Potential revenue this fiscal year for organization.
OBJ_POT_REVENUE_NEXT_FY	NUMBER			Potential revenue next fiscal year for organization.
OBJ_TAX_REFERENCE	VARCHAR2	(50)		Taxpayer identification number.
OBJ_YEAR_ESTABLISHED	NUMBER	(4)		Year in which organization began doing business.
OBJ_INTERNAL_FLAG	VARCHAR2	(1)		Indicates whether the organization is internal or external. Y for Internal, N for External.
OBJ_PUB_PRIVATE_OWNER_FLAG	VARCHAR2	(1)		Y if ownership of organization is private, N if ownership is public
OBJ_DUNS_NUMBER	NUMBER			a unique, nine digit identification number assigned to every business entity by Dun & Bradstreet
OBJ_JGZZ_FISCAL_CODE	VARCHAR2	(20)		This column is used as the "Fiscal Code" for certain European countries
ORGPR_LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LINE_OF_BUSINESS	VARCHAR2	(240)		Type of business activities performed at this site
CATEGORY_CODE	VARCHAR2	(30)		User-definable category (lookup type= CUSTOMER_CATEGORY)
OBJ_DUNS_NUMBER_C	VARCHAR2	(30)		a unique, nine digit identification number assigned to every business entity by Dun & Bradstreet

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OBJECT_ID
,      OBJ_SIC_CODE
,      OBJ_ALIAS
,      OBJ_COMPANY_NAME
,      OBJ_ANALYSIS_FY
,      OBJ_FISCAL_YEAREND_MONTH
,      OBJ_NUM_OF_EMPLOYEES
,      OBJ_POT_REVENUE_CURR_FY
,      OBJ_POT_REVENUE_NEXT_FY
,      OBJ_TAX_REFERENCE
,      OBJ_YEAR_ESTABLISHED
,      OBJ_INTERNAL_FLAG
,      OBJ_PUB_PRIVATE_OWNER_FLAG
,      OBJ_DUNS_NUMBER
,      OBJ_JGZZ_FISCAL_CODE
,      ORGPR_LAST_UPDATE_DATE
,      LINE_OF_BUSINESS
,      CATEGORY_CODE
,      OBJ_DUNS_NUMBER_C
FROM APPS.CSC_HZ_ORG_PROFILES_V;

Dependencies

[top of page]

APPS.CSC_HZ_ORG_PROFILES_V references the following:

APPS: HZ_ORGANIZATION_PROFILES; HZ_PARTIES

APPS.CSC_HZ_ORG_PROFILES_V is not referenced by any database object