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

MATERIALIZED VIEW: APPS.MSC_PHUB_RESOURCES_MV

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

MSC_INSTANCE_ORGS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SR_INSTANCE_ID NUMBER

ORGANIZATION_ID NUMBER

DEPARTMENT_ID NUMBER

DEPARTMENT_CODE VARCHAR2 (10)
DEPARTMENT_DESCRIPTION VARCHAR2 (240)
DEPARTMENT_CLASS VARCHAR2 (10)
RESOURCE_ID NUMBER

RESOURCE_GROUP_ID VARCHAR2 (30)
RESOURCE_GROUP_CODE VARCHAR2 (30)
RESOURCE_GROUP_DESCRIPTION VARCHAR2 (250)
RESOURCE_NAME VARCHAR2 (16)
RESOURCE_DESCRIPTION VARCHAR2 (240)
EFFICIENCY NUMBER

UTILIZATION NUMBER

MIN_CAPACITY NUMBER

MAX_CAPACITY NUMBER

LINE_FLAG NUMBER

MAX_RATE NUMBER

BATCHABLE_FLAG NUMBER

BOTTLENECK_FLAG NUMBER

RESOURCE_TYPE NUMBER

Query Text

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


SELECT SR_INSTANCE_ID
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      DEPARTMENT_DESCRIPTION
,      DEPARTMENT_CLASS
,      RESOURCE_ID
,      RESOURCE_GROUP_ID
,      RESOURCE_GROUP_CODE
,      RESOURCE_GROUP_DESCRIPTION
,      RESOURCE_NAME
,      RESOURCE_DESCRIPTION
,      EFFICIENCY
,      UTILIZATION
,      MIN_CAPACITY
,      MAX_CAPACITY
,      LINE_FLAG
,      MAX_RATE
,      BATCHABLE_FLAG
,      BOTTLENECK_FLAG
,      RESOURCE_TYPE
FROM APPS.MSC_PHUB_RESOURCES_MV;

Dependencies

[top of page]

APPS.MSC_PHUB_RESOURCES_MV references the following:

SchemaAPPS
TableMSC_PHUB_RESOURCES_MV
SchemaMSC
TableMSC_DEPARTMENT_RESOURCES
TableMSC_INSTANCE_ORGS
TableMSC_RESOURCE_GROUPS

APPS.MSC_PHUB_RESOURCES_MV is not referenced by any database object