[Home] [Help] [Dependency Information]
Object Name: | HRI_OBI_MDP_WRKFC_ORGH_TRN_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_SUP_ORGANZTN_FK | NUMBER | |||
PER_PERSON_FK | NUMBER | |||
ASG_ASSGNMNT_FK | NUMBER | |||
PTYP_WRKTYP_FK | VARCHAR2 | (40) | ||
TIME_DAY_EVT_FK | DATE | |||
TRANSFER_IN_IND | NUMBER | |||
TRANSFER_OUT_IND | NUMBER | |||
HEADCOUNT_TRN_IN | NUMBER | |||
HEADCOUNT_TRN_OUT | NUMBER | |||
HEADCOUNT_TRN_IN_EMP | NUMBER | |||
HEADCOUNT_TRN_OUT_EMP | NUMBER | |||
HEADCOUNT_TRN_IN_CWK | NUMBER | |||
HEADCOUNT_TRN_OUT_CWK | NUMBER | |||
FTE_TRN_IN | NUMBER | |||
FTE_TRN_OUT | NUMBER | |||
FTE_TRN_IN_EMP | NUMBER | |||
FTE_TRN_OUT_EMP | NUMBER | |||
FTE_TRN_IN_CWK | NUMBER | |||
FTE_TRN_OUT_CWK | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_SUP_ORGANZTN_FK
, PER_PERSON_FK
, ASG_ASSGNMNT_FK
, PTYP_WRKTYP_FK
, TIME_DAY_EVT_FK
, TRANSFER_IN_IND
, TRANSFER_OUT_IND
, HEADCOUNT_TRN_IN
, HEADCOUNT_TRN_OUT
, HEADCOUNT_TRN_IN_EMP
, HEADCOUNT_TRN_OUT_EMP
, HEADCOUNT_TRN_IN_CWK
, HEADCOUNT_TRN_OUT_CWK
, FTE_TRN_IN
, FTE_TRN_OUT
, FTE_TRN_IN_EMP
, FTE_TRN_OUT_EMP
, FTE_TRN_IN_CWK
, FTE_TRN_OUT_CWK
FROM APPS.HRI_OBI_MDP_WRKFC_ORGH_TRN_V;
APPS.HRI_OBI_MDP_WRKFC_ORGH_TRN_V is not referenced by any database object
|
|
|