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.HRI_OBI_CL_PER_PERSONSC_V

Object Details

Object Name:	HRI_OBI_CL_PER_PERSONSC_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
PERS_PERSONSC_PK	VARCHAR2	(61)
PERS_PERSONSC_NAME	VARCHAR2	(4000)
PERS_PERSONSC_NAME_UNQ	VARCHAR2	(4000)
PERS_PERSON_NAME_CRNT	VARCHAR2	(4000)
PERS_PERSONSC_NAME_CRNT_UNQ	VARCHAR2	(4000)
PERS_DATE_START	DATE
PERS_DATE_END	DATE
PERS_ORDER_BY	VARCHAR2	(4000)
PERS_PERSON_FK	NUMBER
PERS_LAST_NAME	VARCHAR2	(4000)
PERS_APPLICANT_NUMBER	VARCHAR2	(30)
PERS_EMPLOYEE_NUMBER	VARCHAR2	(30)
PERS_NPW_NUMBER	VARCHAR2	(30)
PERS_APL_FLAG_CODE	VARCHAR2	(30)
PERS_EMP_FLAG_CODE	VARCHAR2	(30)
PERS_CWK_FLAG_CODE	VARCHAR2	(30)
PERS_EMP_OR_APL_FLAG_CODE	VARCHAR2	(30)
PERS_WORKER_FLAG_CODE	VARCHAR2	(30)
PERS_MARITAL_STATUS_CODE	VARCHAR2	(30)
PERS_GENDER_CODE	VARCHAR2	(30)
PERS_APL_FLAG	VARCHAR2	(4000)
PERS_EMP_FLAG	VARCHAR2	(4000)
PERS_CWK_FLAG	VARCHAR2	(4000)
PERS_EMP_OR_APL_FLAG	VARCHAR2	(4000)
PERS_WORKER_FLAG	VARCHAR2	(4000)
PERS_MARITAL_STATUS	VARCHAR2	(4000)
PERS_GENDER	VARCHAR2	(4000)
PERS_MIDDLE_NAMES	VARCHAR2	(4000)

Query Text

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


SELECT PERS_PERSONSC_PK
,      PERS_PERSONSC_NAME
,      PERS_PERSONSC_NAME_UNQ
,      PERS_PERSON_NAME_CRNT
,      PERS_PERSONSC_NAME_CRNT_UNQ
,      PERS_DATE_START
,      PERS_DATE_END
,      PERS_ORDER_BY
,      PERS_PERSON_FK
,      PERS_LAST_NAME
,      PERS_APPLICANT_NUMBER
,      PERS_EMPLOYEE_NUMBER
,      PERS_NPW_NUMBER
,      PERS_APL_FLAG_CODE
,      PERS_EMP_FLAG_CODE
,      PERS_CWK_FLAG_CODE
,      PERS_EMP_OR_APL_FLAG_CODE
,      PERS_WORKER_FLAG_CODE
,      PERS_MARITAL_STATUS_CODE
,      PERS_GENDER_CODE
,      PERS_APL_FLAG
,      PERS_EMP_FLAG
,      PERS_CWK_FLAG
,      PERS_EMP_OR_APL_FLAG
,      PERS_WORKER_FLAG
,      PERS_MARITAL_STATUS
,      PERS_GENDER
,      PERS_MIDDLE_NAMES
FROM APPS.HRI_OBI_CL_PER_PERSONSC_V;

Dependencies

[top of page]

APPS.HRI_OBI_CL_PER_PERSONSC_V references the following:

APPS: FND_PROFILE - show dependent code; HRI_OLTP_VIEW_MESSAGE - show dependent code; HRI_UNASSIGNED; HR_BIS - show dependent code; HR_GENERAL - show dependent code; PER_ALL_PEOPLE_F

APPS.HRI_OBI_CL_PER_PERSONSC_V is not referenced by any database object