[Home] [Help] [Dependency Information]
Object Name: | HRI_OBI_MDS_WRKFC_MGRH_SMRY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUP_PERSON_FK | NUMBER | |||
SUP_MNGRSC_FK | NUMBER | |||
SUP_DIRECTS_ONLY_FLAG | VARCHAR2 | (30) | ||
TIME_DAY_MNTH_START_FK | DATE | |||
TIME_DAY_MNTH_END_FK | DATE | |||
TIME_MONTH_SNP_FK | NUMBER | |||
PTYP_WRKTYP_FK | VARCHAR2 | (40) | ||
HEADCOUNT_START | NUMBER | |||
HEADCOUNT_END | NUMBER | |||
HEADCOUNT_HIRE | NUMBER | |||
HEADCOUNT_TRN_IN | NUMBER | |||
HEADCOUNT_TRN_OUT | NUMBER | |||
HEADCOUNT_TERM | NUMBER | |||
HEADCOUNT_SEP_VOL | NUMBER | |||
HEADCOUNT_SEP_INVOL | NUMBER | |||
HEADCOUNT_START_EMP | NUMBER | |||
HEADCOUNT_END_EMP | NUMBER | |||
HEADCOUNT_HIRE_EMP | NUMBER | |||
HEADCOUNT_TRN_IN_EMP | NUMBER | |||
HEADCOUNT_TRN_OUT_EMP | NUMBER | |||
HEADCOUNT_TERM_EMP | NUMBER | |||
HEADCOUNT_SEP_VOL_EMP | NUMBER | |||
HEADCOUNT_SEP_INVOL_EMP | NUMBER | |||
HEADCOUNT_START_CWK | NUMBER | |||
HEADCOUNT_END_CWK | NUMBER | |||
HEADCOUNT_HIRE_CWK | NUMBER | |||
HEADCOUNT_TRN_IN_CWK | NUMBER | |||
HEADCOUNT_TRN_OUT_CWK | NUMBER | |||
HEADCOUNT_TERM_CWK | NUMBER | |||
FTE_START | NUMBER | |||
FTE_END | NUMBER | |||
FTE_HIRE | NUMBER | |||
FTE_TRN_IN | NUMBER | |||
FTE_TRN_OUT | NUMBER | |||
FTE_TERM | NUMBER | |||
FTE_SEP_VOL | NUMBER | |||
FTE_SEP_INVOL | NUMBER | |||
FTE_START_EMP | NUMBER | |||
FTE_END_EMP | NUMBER | |||
FTE_HIRE_EMP | NUMBER | |||
FTE_TRN_IN_EMP | NUMBER | |||
FTE_TRN_OUT_EMP | NUMBER | |||
FTE_TERM_EMP | NUMBER | |||
FTE_SEP_VOL_EMP | NUMBER | |||
FTE_SEP_INVOL_EMP | NUMBER | |||
FTE_START_CWK | NUMBER | |||
FTE_END_CWK | NUMBER | |||
FTE_HIRE_CWK | NUMBER | |||
FTE_TRN_IN_CWK | NUMBER | |||
FTE_TRN_OUT_CWK | NUMBER | |||
FTE_TERM_CWK | NUMBER | |||
COUNT_PASG_START_EMP | NUMBER | |||
COUNT_PASG_END_EMP | NUMBER | |||
COUNT_PASG_HIRE_EMP | NUMBER | |||
COUNT_PASG_TERM_EMP | NUMBER | |||
COUNT_PASG_TRN_IN_EMP | NUMBER | |||
COUNT_PASG_TRN_OUT_EMP | NUMBER | |||
COUNT_PASG_START_CWK | NUMBER | |||
COUNT_PASG_END_CWK | NUMBER | |||
COUNT_PASG_HIRE_CWK | NUMBER | |||
COUNT_PASG_TERM_CWK | NUMBER | |||
COUNT_PASG_TRN_IN_CWK | NUMBER | |||
COUNT_PASG_TRN_OUT_CWK | NUMBER | |||
COUNT_PASG_SEP_VOL | NUMBER | |||
COUNT_PASG_SEP_INVOL | NUMBER | |||
COUNT_PASG_SEP_VOL_EMP | NUMBER | |||
COUNT_PASG_SEP_INVOL_EMP | NUMBER | |||
COUNT_ASG_START_EMP | NUMBER | |||
COUNT_ASG_END_EMP | NUMBER | |||
COUNT_ASG_HIRE_EMP | NUMBER | |||
COUNT_ASG_TERM_EMP | NUMBER | |||
COUNT_ASG_TRN_IN_EMP | NUMBER | |||
COUNT_ASG_TRN_OUT_EMP | NUMBER | |||
COUNT_ASG_START_CWK | NUMBER | |||
COUNT_ASG_END_CWK | NUMBER | |||
COUNT_ASG_HIRE_CWK | NUMBER | |||
COUNT_ASG_TERM_CWK | NUMBER | |||
COUNT_ASG_TRN_IN_CWK | NUMBER | |||
COUNT_ASG_TRN_OUT_CWK | NUMBER | |||
COUNT_ASG_SEP_VOL | NUMBER | |||
COUNT_ASG_SEP_INVOL | NUMBER | |||
COUNT_ASG_SEP_VOL_EMP | NUMBER | |||
COUNT_ASG_SEP_INVOL_EMP | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SUP_PERSON_FK
, SUP_MNGRSC_FK
, SUP_DIRECTS_ONLY_FLAG
, TIME_DAY_MNTH_START_FK
, TIME_DAY_MNTH_END_FK
, TIME_MONTH_SNP_FK
, PTYP_WRKTYP_FK
, HEADCOUNT_START
, HEADCOUNT_END
, HEADCOUNT_HIRE
, HEADCOUNT_TRN_IN
, HEADCOUNT_TRN_OUT
, HEADCOUNT_TERM
, HEADCOUNT_SEP_VOL
, HEADCOUNT_SEP_INVOL
, HEADCOUNT_START_EMP
, HEADCOUNT_END_EMP
, HEADCOUNT_HIRE_EMP
, HEADCOUNT_TRN_IN_EMP
, HEADCOUNT_TRN_OUT_EMP
, HEADCOUNT_TERM_EMP
, HEADCOUNT_SEP_VOL_EMP
, HEADCOUNT_SEP_INVOL_EMP
, HEADCOUNT_START_CWK
, HEADCOUNT_END_CWK
, HEADCOUNT_HIRE_CWK
, HEADCOUNT_TRN_IN_CWK
, HEADCOUNT_TRN_OUT_CWK
, HEADCOUNT_TERM_CWK
, FTE_START
, FTE_END
, FTE_HIRE
, FTE_TRN_IN
, FTE_TRN_OUT
, FTE_TERM
, FTE_SEP_VOL
, FTE_SEP_INVOL
, FTE_START_EMP
, FTE_END_EMP
, FTE_HIRE_EMP
, FTE_TRN_IN_EMP
, FTE_TRN_OUT_EMP
, FTE_TERM_EMP
, FTE_SEP_VOL_EMP
, FTE_SEP_INVOL_EMP
, FTE_START_CWK
, FTE_END_CWK
, FTE_HIRE_CWK
, FTE_TRN_IN_CWK
, FTE_TRN_OUT_CWK
, FTE_TERM_CWK
, COUNT_PASG_START_EMP
, COUNT_PASG_END_EMP
, COUNT_PASG_HIRE_EMP
, COUNT_PASG_TERM_EMP
, COUNT_PASG_TRN_IN_EMP
, COUNT_PASG_TRN_OUT_EMP
, COUNT_PASG_START_CWK
, COUNT_PASG_END_CWK
, COUNT_PASG_HIRE_CWK
, COUNT_PASG_TERM_CWK
, COUNT_PASG_TRN_IN_CWK
, COUNT_PASG_TRN_OUT_CWK
, COUNT_PASG_SEP_VOL
, COUNT_PASG_SEP_INVOL
, COUNT_PASG_SEP_VOL_EMP
, COUNT_PASG_SEP_INVOL_EMP
, COUNT_ASG_START_EMP
, COUNT_ASG_END_EMP
, COUNT_ASG_HIRE_EMP
, COUNT_ASG_TERM_EMP
, COUNT_ASG_TRN_IN_EMP
, COUNT_ASG_TRN_OUT_EMP
, COUNT_ASG_START_CWK
, COUNT_ASG_END_CWK
, COUNT_ASG_HIRE_CWK
, COUNT_ASG_TERM_CWK
, COUNT_ASG_TRN_IN_CWK
, COUNT_ASG_TRN_OUT_CWK
, COUNT_ASG_SEP_VOL
, COUNT_ASG_SEP_INVOL
, COUNT_ASG_SEP_VOL_EMP
, COUNT_ASG_SEP_INVOL_EMP
FROM APPS.HRI_OBI_MDS_WRKFC_MGRH_SMRY_V;
APPS.HRI_OBI_MDS_WRKFC_MGRH_SMRY_V is not referenced by any database object
|
|
|