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.

[Home] [Help]

View: CSC_HZ_ORG_PROFILES_V

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 Text

SELECT ORG_PROFILE.PARTY_ID
, PARTY.SIC_CODE
, PARTY.KNOWN_AS
, PARTY.PARTY_NAME
, ORG_PROFILE.ANALYSIS_FY
, ORG_PROFILE.FISCAL_YEAREND_MONTH
, ORG_PROFILE.EMPLOYEES_TOTAL
, ORG_PROFILE.CURR_FY_POTENTIAL_REVENUE
, ORG_PROFILE.NEXT_FY_POTENTIAL_REVENUE
, ORG_PROFILE.TAX_REFERENCE
, ORG_PROFILE.YEAR_ESTABLISHED
, ORG_PROFILE.INTERNAL_FLAG
, ORG_PROFILE.PUBLIC_PRIVATE_OWNERSHIP_FLAG
, ORG_PROFILE.DUNS_NUMBER
, ORG_PROFILE.JGZZ_FISCAL_CODE
, ORG_PROFILE.LAST_UPDATE_DATE
, ORG_PROFILE.LINE_OF_BUSINESS
, PARTY.CATEGORY_CODE
, ORG_PROFILE.DUNS_NUMBER_C
FROM HZ_ORGANIZATION_PROFILES ORG_PROFILE
, HZ_PARTIES PARTY
WHERE PARTY.PARTY_ID = ORG_PROFILE.PARTY_ID
AND PARTY.PARTY_TYPE = 'ORGANIZATION'
AND (ORG_PROFILE.EFFECTIVE_END_DATE IS NULL OR SYSDATE BETWEEN ORG_PROFILE.EFFECTIVE_START_DATE
AND ORG_PROFILE.EFFECTIVE_END_DATE)

Columns

Name
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