[Home] [Help] [Dependency Information]

VIEW: APPS.HR_EDW_WRK_ACTVTY_FCV

Object Details

Object Name:	HR_EDW_WRK_ACTVTY_FCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HRI.HR_EDW_WRK_ACTVTY_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 ASSIGNMENT_CHANGE_PK
,      AGE_BAND_FK
,      APPLICATION_FK
,      ASSIGNMENT_FK
,      ASSIGNMENT_CHANGE_FK
,      GEOGRAPHY_FROM_FK
,      GEOGRAPHY_TO_FK
,      GRADE_FROM_FK
,      GRADE_TO_FK
,      INSTANCE_FK
,      JOB_FROM_FK
,      JOB_TO_FK
,      ORGANIZATION_FROM_FK
,      ORGANIZATION_TO_FK
,      PERSON_FK
,      PERSON_TYPE_FK
,      POSITION_FROM_FK
,      POSITION_TO_FK
,      MOVEMENT_FK
,      REASON_FK
,      SERVICE_BAND_FK
,      TIME_FROM_FK
,      TIME_TO_FK
,      JOB_CHANGE_FLAG
,      GRD_CHANGE_FLAG
,      POS_CHANGE_FLAG
,      ORG_CHANGE_FLAG
,      GEOG_CHANGE_FLAG
,      EMPLYMNT_START_FLAG
,      ASSGNMNT_ENDED_FLAG
,      OTHER_CHANGE_FLAG
,      ASG_CHANGE_HEADCOUNT
,      ASG_CHANGE_FTE
,      DAYS_SINCE_LAST_ORG_X
,      DAYS_SINCE_LAST_JOB_X
,      DAYS_SINCE_LAST_POS_X
,      DAYS_SINCE_LAST_GRD_X
,      DAYS_SINCE_LAST_GEOG_X
,      DAYS_EMP_START_TO_TERM
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      ASSIGNMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      RECRUITER_ID
,      GRADE_ID
,      POSITION_ID
,      JOB_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      PAYROLL_ID
,      LOCATION_ID
,      PERSON_REFERRED_BY_ID
,      SUPERVISOR_ID
,      SPECIAL_CEILING_STEP_ID
,      PERSON_ID
,      RECRUITMENT_ACTIVITY_ID
,      SOURCE_ORGANIZATION_ID
,      ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      SOFT_CODING_KEYFLEX_ID
,      VACANCY_ID
,      PAY_BASIS_ID
,      ASSIGNMENT_SEQUENCE
,      ASSIGNMENT_TYPE
,      PRIMARY_FLAG
,      APPLICATION_ID
,      ASSIGNMENT_NUMBER
,      CHANGE_REASON
,      COMMENT_ID
,      DATE_PROBATION_END
,      DEFAULT_CODE_COMB_ID
,      EMPLOYMENT_CATEGORY
,      FREQUENCY
,      INTERNAL_ADDRESS_LINE
,      MANAGER_FLAG
,      NORMAL_HOURS
,      PERF_REVIEW_PERIOD
,      PERF_REVIEW_PERIOD_FREQUENCY
,      PERIOD_OF_SERVICE_ID
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      SAL_REVIEW_PERIOD
,      SAL_REVIEW_PERIOD_FREQUENCY
,      SET_OF_BOOKS_ID
,      SOURCE_TYPE
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      ASG_REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ASG_TITLE
,      OBJECT_VERSION_NUMBER
,      BARGAINING_UNIT_CODE
,      LABOUR_UNION_MEMBER_FLAG
,      HOURLY_SALARIED_CODE
,      CONTRACT_ID
,      COLLECTIVE_AGREEMENT_ID
,      CAGR_ID_FLEX_NUM
,      CAGR_GRADE_DEF_ID
,      ESTABLISHMENT_ID
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
FROM APPS.HR_EDW_WRK_ACTVTY_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

HRI_EDW_FCT_WRKFC_SPRTN - show dependent code

HRI_EDW_FCT_WRK_ACTVTY - show dependent code

HR_EDWBV_WRK_ACTVTY_FCV

APPS

HR_EDW_WRK_ACTVTY_F_C - show dependent code

PUBLIC

HR_EDW_WRK_ACTVTY_FCV