[Home] [Help] [Dependency Information]
Object Name: | HRI_OBI_CL_PER_PERSON_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PER_PERSON_PK | NUMBER | (10) | ||
PER_PERSON_NAME | VARCHAR2 | (4000) | ||
PER_FIRST_NAME | VARCHAR2 | (4000) | ||
PER_MIDDLE_NAMES | VARCHAR2 | (4000) | ||
PER_LAST_NAME | VARCHAR2 | (4000) | ||
PER_PERSON_NAME_UNQ | VARCHAR2 | (4000) | ||
PER_PERSON_LCL_NAME | VARCHAR2 | (4000) | ||
PER_PERSON_GBL_NAME | VARCHAR2 | (4000) | ||
PER_SUFFIX | VARCHAR2 | (30) | ||
PER_HONORS | VARCHAR2 | (45) | ||
PER_KNOWN_AS | VARCHAR2 | (150) | ||
PER_TITLE | VARCHAR2 | (30) | ||
PER_PRE_NAME_ADJUNCT | VARCHAR2 | (30) | ||
PER_ORDER_BY | VARCHAR2 | (301) | ||
PER_APPLICANT_NUMBER | VARCHAR2 | (4000) | ||
PER_EMPLOYEE_NUMBER | VARCHAR2 | (4000) | ||
PER_NPW_NUMBER | VARCHAR2 | (4000) | ||
PER_APL_FLAG_CODE | VARCHAR2 | (30) | ||
PER_EMP_FLAG_CODE | VARCHAR2 | (30) | ||
PER_CWK_FLAG_CODE | VARCHAR2 | (30) | ||
PER_WORKER_FLAG_CODE | VARCHAR2 | (30) | ||
PER_BUYER_FLAG_CODE | VARCHAR2 | (30) | ||
PER_APL_FLAG | VARCHAR2 | (4000) | ||
PER_EMP_FLAG | VARCHAR2 | (4000) | ||
PER_CWK_FLAG | VARCHAR2 | (4000) | ||
PER_WORKER_FLAG | VARCHAR2 | (4000) | ||
PER_BUYER_FLAG | VARCHAR2 | (4000) | ||
PER_DATE_OF_BIRTH | DATE | |||
PER_PLACE_OF_BIRTH | VARCHAR2 | (4000) | ||
PER_COUNTRY_OF_BIRTH | VARCHAR2 | (4000) | ||
PER_DATE_OF_DEATH | DATE | |||
PER_WORK_EMAIL | VARCHAR2 | (4000) | ||
PER_WORK_PHONE_NUMBER | VARCHAR2 | (4000) | ||
PER_MARITAL_STATUS_CRNT_CODE | VARCHAR2 | (30) | ||
PER_GENDER_CRNT_CODE | VARCHAR2 | (30) | ||
PER_MARITAL_STATUS_CRNT | VARCHAR2 | (4000) | ||
PER_GENDER_CRNT | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT PER_PERSON_PK
, PER_PERSON_NAME
, PER_FIRST_NAME
, PER_MIDDLE_NAMES
, PER_LAST_NAME
, PER_PERSON_NAME_UNQ
, PER_PERSON_LCL_NAME
, PER_PERSON_GBL_NAME
, PER_SUFFIX
, PER_HONORS
, PER_KNOWN_AS
, PER_TITLE
, PER_PRE_NAME_ADJUNCT
, PER_ORDER_BY
, PER_APPLICANT_NUMBER
, PER_EMPLOYEE_NUMBER
, PER_NPW_NUMBER
, PER_APL_FLAG_CODE
, PER_EMP_FLAG_CODE
, PER_CWK_FLAG_CODE
, PER_WORKER_FLAG_CODE
, PER_BUYER_FLAG_CODE
, PER_APL_FLAG
, PER_EMP_FLAG
, PER_CWK_FLAG
, PER_WORKER_FLAG
, PER_BUYER_FLAG
, PER_DATE_OF_BIRTH
, PER_PLACE_OF_BIRTH
, PER_COUNTRY_OF_BIRTH
, PER_DATE_OF_DEATH
, PER_WORK_EMAIL
, PER_WORK_PHONE_NUMBER
, PER_MARITAL_STATUS_CRNT_CODE
, PER_GENDER_CRNT_CODE
, PER_MARITAL_STATUS_CRNT
, PER_GENDER_CRNT
FROM APPS.HRI_OBI_CL_PER_PERSON_V;
APPS.HRI_OBI_CL_PER_PERSON_V is not referenced by any database object
|
|
|