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

MATERIALIZED VIEW: APPS.ISC_MAINT_002_MV

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

ISC_MAINT_LAB_BLG_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Inventory Organization identifier
USER_DEFINED_STATUS_ID NUMBER

User Defined Work Order Status
RESOURCE_ID NUMBER

Resource Identifier
DEPARTMENT_ID NUMBER

Owning Department Identifier
HOURS_REQUIRED NUMBER

Aggregate of the Hours Required by the Resource
HOURS_CHARGED NUMBER

Aggregate of the Hours Required on the Resource
GRP_ID NUMBER

Rollup group identifier. Used to identify the rollup group attributed to the row
Query Text

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


SELECT ORGANIZATION_ID
,      USER_DEFINED_STATUS_ID
,      RESOURCE_ID
,      DEPARTMENT_ID
,      HOURS_REQUIRED
,      HOURS_CHARGED
,      GRP_ID
FROM APPS.ISC_MAINT_002_MV;

Dependencies

[top of page]

APPS.ISC_MAINT_002_MV references the following:

SchemaAPPS
TableISC_MAINT_002_MV
SchemaISC
TableISC_MAINT_LAB_BLG_F

APPS.ISC_MAINT_002_MV is not referenced by any database object