DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HRI_OBI_MDP_WRKFC_MGRH_TRN_V

Object Details
Object Name: HRI_OBI_MDP_WRKFC_MGRH_TRN_V
Object Type: VIEW
Owner: APPS
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
Name Datatype Length Mandatory Comments
MGR_SUP_PERSON_FK NUMBER

Supervisor person id
MGR_SUP_MNGRSC_FK NUMBER

Supervisor MNGRSC
PER_PERSON_FK NUMBER

Person ID
ASG_ASSGNMNT_FK NUMBER

Assignment ID
PTYP_WRKTYP_FK VARCHAR2 (40)
Person type id
TIME_DAY_EVT_FK DATE

Time Day Event
TRANSFER_IN_IND NUMBER

Transfer in
TRANSFER_OUT_IND NUMBER

Transfer out
SUP_DIRECT_MNGR_FLAG VARCHAR2 (1)
Supervisor Direct Manager
HEADCOUNT_TRN_IN NUMBER

Headcount Transaction In
HEADCOUNT_TRN_OUT NUMBER

Headcount Transaction out
HEADCOUNT_TRN_IN_EMP NUMBER

Headcount Transaction in Emp
HEADCOUNT_TRN_OUT_EMP NUMBER

Headcount Transaction out Emp
HEADCOUNT_TRN_IN_CWK NUMBER

Headcount Transaction in contingent worker
HEADCOUNT_TRN_OUT_CWK NUMBER

Headcount Transaction out contingent worker
FTE_TRN_IN NUMBER

Full Time Employement in
FTE_TRN_OUT NUMBER

Full Time Employement out
FTE_TRN_IN_EMP NUMBER

Full Time Employement in employee
FTE_TRN_OUT_EMP NUMBER

Full Time Employement out employee
FTE_TRN_IN_CWK NUMBER

Full Time Employement in contingent worker
FTE_TRN_OUT_CWK NUMBER

Full Time Employement out contingent worker
Query Text

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


SELECT MGR_SUP_PERSON_FK
,      MGR_SUP_MNGRSC_FK
,      PER_PERSON_FK
,      ASG_ASSGNMNT_FK
,      PTYP_WRKTYP_FK
,      TIME_DAY_EVT_FK
,      TRANSFER_IN_IND
,      TRANSFER_OUT_IND
,      SUP_DIRECT_MNGR_FLAG
,      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_MGRH_TRN_V;

Dependencies

[top of page]

APPS.HRI_OBI_MDP_WRKFC_MGRH_TRN_V references the following:

SchemaAPPS
SynonymHRI_MB_WRKFC_EVT_CT
SynonymHRI_MDP_MGRH_TRANSFERS_CT

APPS.HRI_OBI_MDP_WRKFC_MGRH_TRN_V is not referenced by any database object