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


TABLE: APPS.HRI_MDP_SUP_WRKFC_CIT_MV

Object Details
Object Name: HRI_MDP_SUP_WRKFC_CIT_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HRI_MDP_SUP_WRKFC_CIT_MV_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSUPERVISOR_PERSON_ID
ColumnGEO_COUNTRY_CODE
ColumnGEO_REGION_CODE
ColumnGEO_CITY_CID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
ColumnANL_SLRY_CURRENCY
Columns
Name Datatype Length Mandatory Comments
SUPERVISOR_PERSON_ID NUMBER

EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

GEO_COUNTRY_CODE VARCHAR2 (70)
GEO_REGION_CODE VARCHAR2 (160)
GEO_CITY_CID VARCHAR2 (300)
ANL_SLRY_CURRENCY VARCHAR2 (30)
TOTAL_ANL_SLRY NUMBER

TOTAL_HEADCOUNT NUMBER

DIRECT_ANL_SLRY NUMBER

DIRECT_HEADCOUNT NUMBER

Query Text

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


SELECT SUPERVISOR_PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      GEO_COUNTRY_CODE
,      GEO_REGION_CODE
,      GEO_CITY_CID
,      ANL_SLRY_CURRENCY
,      TOTAL_ANL_SLRY
,      TOTAL_HEADCOUNT
,      DIRECT_ANL_SLRY
,      DIRECT_HEADCOUNT
FROM APPS.HRI_MDP_SUP_WRKFC_CIT_MV;

Dependencies

[top of page]

APPS.HRI_MDP_SUP_WRKFC_CIT_MV does not reference any database object

APPS.HRI_MDP_SUP_WRKFC_CIT_MV is referenced by following:

SchemaAPPS
Materialized ViewHRI_MDP_SUP_WRKFC_CIT_MV