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

MATERIALIZED VIEW: APPS.ISC_MAINT_007_MV

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

BIS_BUCKET

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Maintenance Organization Id
DEPARTMENT_ID NUMBER

Department responsible for the scheduling and execution of the Work Order. This Department is required when the work order is released
ASSET_GROUP_ID NUMBER

Work Order Asset Group ID
INSTANCE_ID NUMBER

Work Order created on the instance id
ACTIVITY_ID NUMBER

Work Order Activity Id
WORK_ORDER_TYPE VARCHAR2 (30)
Work Order Type
USER_DEFINED_STATUS_ID NUMBER

user defined Work Order Status
DAY DATE

FII Day Identifier
GRP_ID NUMBER

Rollup group identifier. Used to identify the rollup group attributed to the row
BUCKET_NUM NUMBER

Indicate bucket number corresponding to the range defined in bucket set: BIV_MAINT_PAST_DUE_AGING. The value is 1, 2, 3, until 10
NUM_PASTDUE NUMBER

Count of work orders that are past due in bucket_num
Query Text

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


SELECT ORGANIZATION_ID
,      DEPARTMENT_ID
,      ASSET_GROUP_ID
,      INSTANCE_ID
,      ACTIVITY_ID
,      WORK_ORDER_TYPE
,      USER_DEFINED_STATUS_ID
,      DAY
,      GRP_ID
,      BUCKET_NUM
,      NUM_PASTDUE
FROM APPS.ISC_MAINT_007_MV;

Dependencies

[top of page]

APPS.ISC_MAINT_007_MV references the following:

SchemaAPPS
TableISC_MAINT_007_MV
SchemaBIS
TableBIS_BUCKET
TableBIS_BUCKET_CUSTOMIZATIONS
SchemaISC
TableISC_MAINT_WORK_ORDERS_F

APPS.ISC_MAINT_007_MV is not referenced by any database object