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


TABLE: APPS.HRI_MDP_SUP_WCNT_TERM_ASG_MV

Object Details
Object Name: HRI_MDP_SUP_WCNT_TERM_ASG_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.HRI_MDP_SUP_WCNT_TERM_ASG_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_MDP_SUP_WCNT_T FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("SUPERVISOR_PERSON_ID")
ColumnSYS_OP_MAP_NONNULL("DIRECT_SUPERVISOR_PERSON_ID")
ColumnSYS_OP_MAP_NONNULL("EFFECTIVE_DATE")
ColumnSYS_OP_MAP_NONNULL("WKTH_WKTYP_SK_FK")
ColumnSYS_OP_MAP_NONNULL("POW_START_DATE")
ColumnSYS_OP_MAP_NONNULL("ASSIGNMENT_ID")
ColumnSYS_OP_MAP_NONNULL("PERSON_ID")
ColumnSYS_OP_MAP_NONNULL("GEO_AREA_CODE")
ColumnSYS_OP_MAP_NONNULL("GEO_COUNTRY_CODE")
ColumnSYS_OP_MAP_NONNULL("JOB_FMLY_CODE")
ColumnSYS_OP_MAP_NONNULL("JOB_FNCTN_CODE")
ColumnSYS_OP_MAP_NONNULL("JOB_ID")
ColumnSYS_OP_MAP_NONNULL("LEAVING_REASON_CODE")
ColumnSYS_OP_MAP_NONNULL("SEPARATION_CATEGORY")
ColumnSYS_OP_MAP_NONNULL("ORGANIZATION_ID")
ColumnSYS_OP_MAP_NONNULL("LOCATION_ID")
ColumnSYS_OP_MAP_NONNULL("POW_BAND_SK_FK")
ColumnSYS_OP_MAP_NONNULL("PERF_BAND")
ColumnSYS_OP_MAP_NONNULL("DIRECT_IND")
HRI_MDP_SUP_WCNT_TERMASG_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSUPERVISOR_PERSON_ID
ColumnEFFECTIVE_DATE
ColumnDIRECT_IND
HRI_MDP_SUP_WCNT_TERMASG_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSUPERVISOR_PERSON_ID
ColumnEFFECTIVE_DATE
ColumnLEAVING_REASON_CODE
ColumnSEPARATION_CATEGORY
HRI_MDP_SUP_WCNT_TERMASG_MV_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSUPERVISOR_PERSON_ID
ColumnEFFECTIVE_DATE
ColumnPOW_BAND_SK_FK
ColumnPERF_BAND
HRI_MDP_SUP_WCNT_TERMASG_MV_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSUPERVISOR_PERSON_ID
ColumnEFFECTIVE_DATE
ColumnJOB_FMLY_CODE
ColumnJOB_FNCTN_CODE
ColumnGEO_COUNTRY_CODE
HRI_MDP_SUP_WCNT_TERMASG_MV_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSUPERVISOR_PERSON_ID
ColumnEFFECTIVE_DATE
ColumnGEO_COUNTRY_CODE
ColumnJOB_FMLY_CODE
ColumnJOB_FNCTN_CODE
Columns
Name Datatype Length Mandatory Comments
SUPERVISOR_PERSON_ID NUMBER

DIRECT_SUPERVISOR_PERSON_ID NUMBER

EFFECTIVE_DATE DATE

WKTH_WKTYP_SK_FK VARCHAR2 (40)
POW_START_DATE DATE

POW_MONTHS NUMBER

ASSIGNMENT_ID NUMBER

PERSON_ID NUMBER

GEO_AREA_CODE VARCHAR2 (40)
GEO_COUNTRY_CODE VARCHAR2 (70)
JOB_FMLY_CODE VARCHAR2 (240)
JOB_FNCTN_CODE VARCHAR2 (240)
JOB_ID NUMBER

LEAVING_REASON_CODE VARCHAR2 (30)
SEPARATION_CATEGORY VARCHAR2 (30)
ORGANIZATION_ID NUMBER

LOCATION_ID NUMBER

POW_BAND_SK_FK NUMBER

PERF_BAND NUMBER

DIRECT_IND NUMBER

SEPARATION_HDC NUMBER

ADMIN_SPRTN_HDC_COUNT NUMBER

ADMIN_ROW_COUNT NUMBER

Query Text

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


SELECT SUPERVISOR_PERSON_ID
,      DIRECT_SUPERVISOR_PERSON_ID
,      EFFECTIVE_DATE
,      WKTH_WKTYP_SK_FK
,      POW_START_DATE
,      POW_MONTHS
,      ASSIGNMENT_ID
,      PERSON_ID
,      GEO_AREA_CODE
,      GEO_COUNTRY_CODE
,      JOB_FMLY_CODE
,      JOB_FNCTN_CODE
,      JOB_ID
,      LEAVING_REASON_CODE
,      SEPARATION_CATEGORY
,      ORGANIZATION_ID
,      LOCATION_ID
,      POW_BAND_SK_FK
,      PERF_BAND
,      DIRECT_IND
,      SEPARATION_HDC
,      ADMIN_SPRTN_HDC_COUNT
,      ADMIN_ROW_COUNT
FROM APPS.HRI_MDP_SUP_WCNT_TERM_ASG_MV;

Dependencies

[top of page]

APPS.HRI_MDP_SUP_WCNT_TERM_ASG_MV does not reference any database object

APPS.HRI_MDP_SUP_WCNT_TERM_ASG_MV is referenced by following:

SchemaAPPS
Materialized ViewHRI_MDP_SUP_WCNT_TERM_ASG_MV
Materialized ViewHRI_MDS_SUP_WCNT_TERM_CTR_MV