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

TABLE: APPS.HRI_MDS_SUP_WCNT_TERM_CTR_MV

Object Details
Object Name: HRI_MDS_SUP_WCNT_TERM_CTR_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.HRI_MDS_SUP_WCNT_TERM_CTR_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_HRI_MDS_SUP_WCNT_T FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("SUPERVISOR_PERSON_ID")
ColumnSYS_OP_MAP_NONNULL("EFFECTIVE_DATE")
ColumnSYS_OP_MAP_NONNULL("PERIOD_TYPE")
ColumnSYS_OP_MAP_NONNULL("COMPARISON_TYPE")
ColumnSYS_OP_MAP_NONNULL("WKTH_WKTYP_SK_FK")
ColumnSYS_OP_MAP_NONNULL("DIRECT_IND")
ColumnSYS_OP_MAP_NONNULL("GEO_AREA_CODE")
ColumnSYS_OP_MAP_NONNULL("GEO_COUNTRY_CODE")
HRI_MDS_SUP_WCNT_TERM_CTR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSUPERVISOR_PERSON_ID
ColumnEFFECTIVE_DATE
ColumnPERIOD_TYPE
ColumnCOMPARISON_TYPE
ColumnGEO_AREA_CODE
ColumnGEO_COUNTRY_CODE
Columns
Name Datatype Length Mandatory Comments
SUPERVISOR_PERSON_ID NUMBER

EFFECTIVE_DATE DATE

PERIOD_TYPE VARCHAR2 (30)
COMPARISON_TYPE VARCHAR2 (30)
WKTH_WKTYP_SK_FK VARCHAR2 (40)
DIRECT_IND NUMBER

GEO_AREA_CODE VARCHAR2 (40)
GEO_COUNTRY_CODE VARCHAR2 (70)
POW_DAYS NUMBER

POW_MONTHS NUMBER

SEPARATION_HDC NUMBER

SEP_INVOL_HDC NUMBER

SEP_VOL_HDC NUMBER

Query Text

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


SELECT SUPERVISOR_PERSON_ID
,      EFFECTIVE_DATE
,      PERIOD_TYPE
,      COMPARISON_TYPE
,      WKTH_WKTYP_SK_FK
,      DIRECT_IND
,      GEO_AREA_CODE
,      GEO_COUNTRY_CODE
,      POW_DAYS
,      POW_MONTHS
,      SEPARATION_HDC
,      SEP_INVOL_HDC
,      SEP_VOL_HDC
FROM APPS.HRI_MDS_SUP_WCNT_TERM_CTR_MV;

Dependencies

[top of page]

APPS.HRI_MDS_SUP_WCNT_TERM_CTR_MV does not reference any database object

APPS.HRI_MDS_SUP_WCNT_TERM_CTR_MV is referenced by following:

SchemaAPPS
Materialized ViewHRI_MDS_SUP_WCNT_TERM_CTR_MV