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

MATERIALIZED VIEW: APPS.HR_MBS_WRKFC_JCX_MV

Object Details
Object Name: HR_MBS_WRKFC_JCX_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: HR_MBS_WRKFC_JCX_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: NONE
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: DEFERRED
Fast Refreshable: NO
MV Log Dependencies:

DUAL

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

JOB_ID NUMBER (15)
COUNTRY VARCHAR2 (60)
PAY_BASIS_ID NUMBER (9)
TOTAL_HEADCOUNT NUMBER

MED_ANL_SLRY NUMBER

ANL_SLRY_CURRENCY VARCHAR2 (15)
COMPARATIO NUMBER

RANGE_POSITION NUMBER

QUARTILE NUMBER

Query Text

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


SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      JOB_ID
,      COUNTRY
,      PAY_BASIS_ID
,      TOTAL_HEADCOUNT
,      MED_ANL_SLRY
,      ANL_SLRY_CURRENCY
,      COMPARATIO
,      RANGE_POSITION
,      QUARTILE
FROM APPS.HR_MBS_WRKFC_JCX_MV;

Dependencies

[top of page]

APPS.HR_MBS_WRKFC_JCX_MV references the following:

SchemaAPPS
PL/SQL PackageHRI_BPL_ABV - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
TableHR_MBS_WRKFC_JCX_MV
SynonymPAY_ELEMENT_TYPES_F
SynonymPAY_GRADE_RULES_F
SynonymPAY_INPUT_VALUES_F
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_PAY_BASES
SynonymPER_PAY_PROPOSALS
PL/SQL PackagePER_SALADMIN_UTILITY - show dependent code
SchemaHR
TableHR_LOCATIONS_ALL
TablePAY_ELEMENT_TYPES_F
TablePAY_GRADE_RULES_F
TablePAY_INPUT_VALUES_F
TablePER_ALL_ASSIGNMENTS_F
TablePER_PAY_BASES
TablePER_PAY_PROPOSALS
SchemaPUBLIC
SynonymDUAL
SchemaSYS
TableDUAL

APPS.HR_MBS_WRKFC_JCX_MV is not referenced by any database object