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

MATERIALIZED VIEW: APPS.ISC_MAINT_004_MV

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

FII_TIME_DAY
ISC_MAINT_WORK_ORDERS_F
OKI_DBI_MULTIPLEXER_B

[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 teh Instance ID
ACTIVITY_ID NUMBER

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

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

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Period type identifier based on XTD nested model
NUM_COMPLETION NUMBER

Count of completed work orders. N/A if mx_id = 2,3
NUM_PAST_DUE_CMPL NUMBER

Count of late completed work orders. N/A if mx_id = 2,3
NUM_LATE_COMPLETION NUMBER

Count of late completed work orders. N/A if mx_id = 2,3
DAYS_LATE NUMBER

Number of days late for the dimension value combination. N/A if mx_id = 2,3
NUM_PAST_DUE NUMBER

Count of work orders which have a scheduled completion date + 1 and completion date is > scheduled completion date + 1. If no completion date, it is counted. N/A if mx_id = 1,2
NUM_CREATED NUMBER

Count of work orders created. N/A if mx_id = 1,3
MV_GROUPING_ID NUMBER

Grouping ID Column
MV_YEAR_ID NUMBER

Enterprise Year Identifier
MV_QTR_ID NUMBER

Enterprise Quarter Identifier
MV_PERIOD_ID NUMBER

Enterprise Period Identifier
MV_WEEK_ID NUMBER

FII Week Identifier
MV_DAY_ID NUMBER

FII Day Identifier
MV_NUM_PAST_DUE_CMPL NUMBER

Count Column
MV_NUM_COMPLETION NUMBER

Count Column
MV_NUM_CREATED NUMBER

Count Column
MV_NUM_LATE_COMPLETION NUMBER

Count Column
MV_DAYS_LATE NUMBER

Count Column
MV_NUM_PAST_DUE NUMBER

Count Column
MV_CNT NUMBER

Row Count
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
,      GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      NUM_COMPLETION
,      NUM_PAST_DUE_CMPL
,      NUM_LATE_COMPLETION
,      DAYS_LATE
,      NUM_PAST_DUE
,      NUM_CREATED
,      MV_GROUPING_ID
,      MV_YEAR_ID
,      MV_QTR_ID
,      MV_PERIOD_ID
,      MV_WEEK_ID
,      MV_DAY_ID
,      MV_NUM_PAST_DUE_CMPL
,      MV_NUM_COMPLETION
,      MV_NUM_CREATED
,      MV_NUM_LATE_COMPLETION
,      MV_DAYS_LATE
,      MV_NUM_PAST_DUE
,      MV_CNT
FROM APPS.ISC_MAINT_004_MV;

Dependencies

[top of page]

APPS.ISC_MAINT_004_MV references the following:

SchemaAPPS
TableISC_MAINT_004_MV
SchemaFII
TableFII_TIME_DAY
SchemaISC
TableISC_MAINT_WORK_ORDERS_F
SchemaOKI
TableOKI_DBI_MULTIPLEXER_B

APPS.ISC_MAINT_004_MV is not referenced by any database object