VIEW: APPS.HRI_OBI_MB_WRKFC_EVT_V

Source

View Text - Preformatted

SELECT WEVT_EVTYPCMB_FK ,ASG_ASSGNMNT_FK ,PER_PERSON_FK ,PER_PERSON_MGR_FK ,PER_PERSON_MGR_PRV_FK ,MGR_MNGRSC_FK ,MGR_MNGRSC_PRV_FK ,ORG_ORGANZTN_FK ,ORG_ORGANZTN_PRV_FK ,JOB_JOB_FK ,JOB_JOB_PRV_FK ,GRD_GRADE_FK ,GRD_GRADE_PRV_FK ,POS_POSITION_FK ,POS_POSITION_PRV_FK ,GEO_LOCATION_FK ,GEO_LOCATION_PRV_FK ,ASGRSN_ASGRSN_FK ,SPRN_SPRTNRSN_FK ,SCAT_SPCATGRY_FK ,PTYP_PERTYP_FK ,PRFM_PERFBAND_FK ,POW_POWBAND_FK ,TIME_DAY_EVT_FK ,TIME_DAY_EVT_END_FK ,CUR_CURRENCY_FK ,HEADCOUNT ,HEADCOUNT_PRV ,HEADCOUNT_HIRE ,HEADCOUNT_TERM ,FTE ,FTE_PRV ,FTE_HIRE ,FTE_TERM ,POW_DAYS_ON_EVENT_DATE ,POW_MONTHS_ON_EVENT_DATE ,ANL_SLRY ,ANL_SLRY_PRV ,ASSIGNMENT_CHANGE_IND ,HEADCOUNT_GAIN_IND ,HEADCOUNT_LOSS_IND ,FTE_GAIN_IND ,FTE_LOSS_IND ,CONTINGENT_IND ,EMPLOYEE_IND ,GRADE_CHANGE_IND ,JOB_CHANGE_IND ,POSITION_CHANGE_IND ,LOCATION_CHANGE_IND ,ORGANIZATION_CHANGE_IND ,SUPERVISOR_CHANGE_IND ,WORKER_HIRE_IND ,TERM_VOLUNTARY_IND ,TERM_INVOLUNTARY_IND ,WORKER_TERM_IND ,START_ASG_SSPNSN_IND ,END_ASG_SSPNSN_IND ,POST_HIRE_ASGN_START_IND ,PRE_SPRTN_ASGN_END_IND ,PRSNTYP_CHANGE_IND ,MGRH_NODE_CHANGE_IND ,ADT_EVENT_ID ,ADT_ASSIGNMENT_ID ,ADT_ASG_EFFCTV_START_DATE ,ADT_ASG_EFFCTV_END_DATE ,ADT_PERF_REVIEW_ID ,ADT_PERIOD_OF_SERVICE_ID ,ADT_PERIOD_OF_PLACEMENT_ID FROM HRI_MB_WRKFC_EVT_CT WITH READ ONLY

View Text - HTML Formatted

SELECT WEVT_EVTYPCMB_FK
, ASG_ASSGNMNT_FK
, PER_PERSON_FK
, PER_PERSON_MGR_FK
, PER_PERSON_MGR_PRV_FK
, MGR_MNGRSC_FK
, MGR_MNGRSC_PRV_FK
, ORG_ORGANZTN_FK
, ORG_ORGANZTN_PRV_FK
, JOB_JOB_FK
, JOB_JOB_PRV_FK
, GRD_GRADE_FK
, GRD_GRADE_PRV_FK
, POS_POSITION_FK
, POS_POSITION_PRV_FK
, GEO_LOCATION_FK
, GEO_LOCATION_PRV_FK
, ASGRSN_ASGRSN_FK
, SPRN_SPRTNRSN_FK
, SCAT_SPCATGRY_FK
, PTYP_PERTYP_FK
, PRFM_PERFBAND_FK
, POW_POWBAND_FK
, TIME_DAY_EVT_FK
, TIME_DAY_EVT_END_FK
, CUR_CURRENCY_FK
, HEADCOUNT
, HEADCOUNT_PRV
, HEADCOUNT_HIRE
, HEADCOUNT_TERM
, FTE
, FTE_PRV
, FTE_HIRE
, FTE_TERM
, POW_DAYS_ON_EVENT_DATE
, POW_MONTHS_ON_EVENT_DATE
, ANL_SLRY
, ANL_SLRY_PRV
, ASSIGNMENT_CHANGE_IND
, HEADCOUNT_GAIN_IND
, HEADCOUNT_LOSS_IND
, FTE_GAIN_IND
, FTE_LOSS_IND
, CONTINGENT_IND
, EMPLOYEE_IND
, GRADE_CHANGE_IND
, JOB_CHANGE_IND
, POSITION_CHANGE_IND
, LOCATION_CHANGE_IND
, ORGANIZATION_CHANGE_IND
, SUPERVISOR_CHANGE_IND
, WORKER_HIRE_IND
, TERM_VOLUNTARY_IND
, TERM_INVOLUNTARY_IND
, WORKER_TERM_IND
, START_ASG_SSPNSN_IND
, END_ASG_SSPNSN_IND
, POST_HIRE_ASGN_START_IND
, PRE_SPRTN_ASGN_END_IND
, PRSNTYP_CHANGE_IND
, MGRH_NODE_CHANGE_IND
, ADT_EVENT_ID
, ADT_ASSIGNMENT_ID
, ADT_ASG_EFFCTV_START_DATE
, ADT_ASG_EFFCTV_END_DATE
, ADT_PERF_REVIEW_ID
, ADT_PERIOD_OF_SERVICE_ID
, ADT_PERIOD_OF_PLACEMENT_ID
FROM HRI_MB_WRKFC_EVT_CT WITH READ ONLY