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_PER_PROFILES_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
SUBJECT_ID	NUMBER	(15)	Party Identifier. FK to HZ_PARTIES.
SUB_NICKNAME	VARCHAR2	(240)	An alias or other name by which a person is known
SUB_PERSON_NAME_PHONETIC	VARCHAR2	(320)	Japanese Kana, or phonetic representation of person name
SUB_DATE_OF_BIRTH	DATE		Date the person was born
SUB_PERSONAL_INCOME	NUMBER		An estimated gross annual income of the person in US dollars
PERSU_LAST_UPDATE_DATE	DATE		Standard Who column
PEROB_LAST_UPDATE_DATE	DATE		Standard Who column
SUB_ORG_CONTACT_ID	NUMBER		Identifier of the organization contact
SUB_DECISION_MAKER_FLAG	VARCHAR2	(1)	Y if the person is a decision-maker, N otherwise
SUB_JOB_TITLE	VARCHAR2	(100)	Job title (free form text)
SUB_JOB_TITLE_CODE	VARCHAR2	(30)	Lookup: RESPONSIBILITY
SUB_MANAGED_BY	NUMBER		FK to HZ_PEOPLE
SUB_NATIVE_LANGUAGE	VARCHAR2	(30)	Language of the contact
SUB_REFERENCE_USE_FLAG	VARCHAR2	(1)	Y if this contact can be used as a reference, N otherwise
SUB_OTHER_LANGUAGE_1	VARCHAR2	(30)	Mailing language
SUB_OTHER_LANGUAGE_2	VARCHAR2	(30)	Mailing language
SUB_RANK	VARCHAR2	(30)	Importance of the contact relative to other contacts
SUB_DEPARTMENT_CODE	VARCHAR2	(30)	Used by OSM
SUB_DEPARTMENT	VARCHAR2	(60)	Used by OSM
ORGCT_LAST_UPDATE_DATE	DATE		Used by OSM
MAIL_STOP	VARCHAR2	(60)	An internal designation of where to deliver mail within the organization.
PERSON_NAME_SUFFIX	VARCHAR2	(30)	Indicates the place in a family structure. For example, in "Tom Jones III", the "III".
PERSON_TITLE	VARCHAR2	(60)	A professional or family title. For example, 'Don', or 'The Right Honorable'.

Query Text

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


SELECT SUBJECT_ID
,      SUB_NICKNAME
,      SUB_PERSON_NAME_PHONETIC
,      SUB_DATE_OF_BIRTH
,      SUB_PERSONAL_INCOME
,      PERSU_LAST_UPDATE_DATE
,      PEROB_LAST_UPDATE_DATE
,      SUB_ORG_CONTACT_ID
,      SUB_DECISION_MAKER_FLAG
,      SUB_JOB_TITLE
,      SUB_JOB_TITLE_CODE
,      SUB_MANAGED_BY
,      SUB_NATIVE_LANGUAGE
,      SUB_REFERENCE_USE_FLAG
,      SUB_OTHER_LANGUAGE_1
,      SUB_OTHER_LANGUAGE_2
,      SUB_RANK
,      SUB_DEPARTMENT_CODE
,      SUB_DEPARTMENT
,      ORGCT_LAST_UPDATE_DATE
,      MAIL_STOP
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
FROM APPS.CSC_HZ_PER_PROFILES_V;

Dependencies

[top of page]

APPS.CSC_HZ_PER_PROFILES_V references the following:

APPS: HZ_ORG_CONTACTS; HZ_PERSON_PROFILES; HZ_RELATIONSHIPS

APPS.CSC_HZ_PER_PROFILES_V is not referenced by any database object