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

Object Details

Object Name:	EDW_HR_PRSN_TYP_FKV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HRI.EDW_HR_PRSN_TYP_FKV
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
PERSON_TYPE_PK	VARCHAR2	(2030)
PW_EMPLOYEE_TYPE	VARCHAR2	(80)
DH_PERMENANT_TYPE	VARCHAR2	(80)
DH_INTERN_TYPE	VARCHAR2	(80)
DH_FXD_TRM_LOWER_TYPE	VARCHAR2	(80)
DH_FXD_TRM_UPPER_TYPE	VARCHAR2	(80)
DH_EMP_STUDENT_FLAG	VARCHAR2	(80)
CW_AGNCY_CNTRCTR_TYPE	VARCHAR2	(80)
CW_SELF_EMPLOYED_TYPE	VARCHAR2	(80)
CW_CONSULTANT_TYPE	VARCHAR2	(80)
PW_EX_EMPLOYEE_TYPE	VARCHAR2	(80)
PW_APPLICANT_TYPE	VARCHAR2	(80)
NW_CONTACT_FLAG	VARCHAR2	(80)
NW_DEPENDENT_TYPE	VARCHAR2	(80)
NW_RETIREE_TYPE	VARCHAR2	(80)
NW_BENEFICIARY_TYPE	VARCHAR2	(80)
SRVIVNG_FMLY_MBR_TYPE	VARCHAR2	(80)
SRVIVNG_SPOUSE_TYPE	VARCHAR2	(80)
EX_APPLICANT_TYPE	VARCHAR2	(80)
OTHER_TYPE	VARCHAR2	(80)
PARTICIPANT_TYPE	VARCHAR2	(80)
FORMER_SPOUSE_TYPE	VARCHAR2	(80)
FORMER_FMLY_MBR_TYPE	VARCHAR2	(80)

Query Text

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


SELECT PERSON_TYPE_PK
,      PW_EMPLOYEE_TYPE
,      DH_PERMENANT_TYPE
,      DH_INTERN_TYPE
,      DH_FXD_TRM_LOWER_TYPE
,      DH_FXD_TRM_UPPER_TYPE
,      DH_EMP_STUDENT_FLAG
,      CW_AGNCY_CNTRCTR_TYPE
,      CW_SELF_EMPLOYED_TYPE
,      CW_CONSULTANT_TYPE
,      PW_EX_EMPLOYEE_TYPE
,      PW_APPLICANT_TYPE
,      NW_CONTACT_FLAG
,      NW_DEPENDENT_TYPE
,      NW_RETIREE_TYPE
,      NW_BENEFICIARY_TYPE
,      SRVIVNG_FMLY_MBR_TYPE
,      SRVIVNG_SPOUSE_TYPE
,      EX_APPLICANT_TYPE
,      OTHER_TYPE
,      PARTICIPANT_TYPE
,      FORMER_SPOUSE_TYPE
,      FORMER_FMLY_MBR_TYPE
FROM APPS.EDW_HR_PRSN_TYP_FKV;

Dependencies

[top of page]

APPS.EDW_HR_PRSN_TYP_FKV references the following:

APPS: EDW_LOCAL_INSTANCE; HRI_PERSON_TYPE_CMBNS

APPS.EDW_HR_PRSN_TYP_FKV is not referenced by any database object