[Home] [Help] [Dependency Information]

VIEW: APPS.HR_EDWBV_WRK_SPRTN_FCV

Object Details

Object Name:	HR_EDWBV_WRK_SPRTN_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HRI.HR_EDWBV_WRK_SPRTN_FCV
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

Query Text

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

SELECT SEPARATION_PK
,      ASSIGNMENT_FK
,      AGE_BAND_FK
,      SERVICE_BAND_FK
,      GEOGRAPHY_FK
,      GRADE_FK
,      INSTANCE_FK
,      JOB_FK
,      ORGANIZATION_FK
,      PERSON_FK
,      PERSON_TYPE_FK
,      POSITION_FK
,      TIME_TRM_NTFD_FK
,      TIME_EMP_STRT_FK
,      TIME_TRM_ACCPTD_FK
,      TIME_TRM_PRJCTD_FK
,      TIME_TRM_PRCSS_FK
,      TIME_TRM_OCCRD_FK
,      REASON_FK
,      MOVEMENT_TYPE_FK
,      ASG_ASSIGNMENT_ID
,      ASG_BUSINESS_GROUP_ID
,      ASG_GRADE_ID
,      ASG_JOB_ID
,      ASG_LOCATION_ID
,      ASG_ORGANIZATION_ID
,      ASG_PERSON_ID
,      ASG_POSITION_ID
,      PPS_PRD_OF_SRVC_ID
,      PPS_TRM_ACPTD_PRSN_ID
,      DATE_OF_BIRTH
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      EMP_START_FTE
,      EMP_START_HDCNT
,      SPRTN_NTFD_FTE
,      SPRTN_NTFD_HDCNT
,      SPRTN_ACCPTD_FTE
,      SPRTN_ACCPTD_HDCNT
,      SPRTN_PRJCTD_FTE
,      SPRTN_PRJCTD_HDCNT
,      EMP_SPRTN_FTE
,      EMP_SPRTN_HDCNT
,      FINAL_PRCSS_FTE
,      FINAL_PRCSS_HDCNT
,      SEPARATION_FTE
,      SEPARATION_HEADCOUNT
,      DYS_FRM_STRT_TO_LST_UPDT
,      DYS_FRM_STRT_TO_LST_UPDT_ASG
,      LATEST_ASG_DURATION
,      SPRTN_NTFD_VL
,      SPRTN_ACCPTD_VL
,      SPRTN_PLND_VL
,      SPRTN_CNCLD_VL
,      SPRTN_OCCRRD_VL
,      SPRTN_FNL_PRCSSNG_VL
,      DYS_FRM_STRT_TO_NTFD_ASG
,      DYS_FRM_STRT_TO_ACCPTD_ASG
,      DYS_FRM_STRT_TO_PLND_ASG
,      DYS_FRM_STRT_TO_TRM_ASG
,      DYS_FRM_STRT_TO_PRCSS_ASG
,      DYS_FRM_STRT_TO_NTFD
,      DYS_FRM_STRT_TO_ACCPTD
,      DYS_FRM_STRT_TO_PLND
,      DYS_FRM_STRT_TO_TRM
,      DYS_FRM_STRT_TO_PRCSS
,      DYS_FRM_NTFD_TO_ACPTD
,      DYS_FRM_NTFD_TO_PLND
,      DYS_FRM_NTFD_TO_OCRD
,      DYS_FRM_ACPTD_TO_PLND
,      DYS_FRM_ACPTD_TO_OCRD
,      NTFD_TRMNTN_DT
,      ACCPTD_TRMNTN_DT
,      PRJCTD_TRMNTN_DT
,      ACTUAL_TRMNTN_DT
,      FINAL_PROCESS_DT
,      LEAVING_REASON
,      _DF:POS:_EDW
,      _DF:PSD:_EDW
FROM APPS.HR_EDWBV_WRK_SPRTN_FCV;

Dependencies

[top of page]

APPS

EDW_HR_AGE_BAND_PKG - show dependent code

EDW_HR_PRSN_TYP_PKG - show dependent code

EDW_HR_SERVICE_PKG - show dependent code

EDW_LOCAL_INSTANCE

HRI_EDW_FCT_WRKFC_SPRTN - show dependent code

HRI_EDW_PERIOD_OF_SERVICE

HR_GENERAL - show dependent code

PER_ALL_ASSIGNMENTS_F

PER_ALL_PEOPLE_F

PER_PERIODS_OF_SERVICE

SYS

DUAL

APPS

HR_EDW_WRK_SPRTN_FCV

PUBLIC

HR_EDWBV_WRK_SPRTN_FCV