[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | 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'. |
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;
APPS.CSC_HZ_PER_PROFILES_V is not referenced by any database object
|
|
|