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

MATERIALIZED VIEW: APPS.OPI_DBI_RES_UTL_MV

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

ENI_RES_5_MV
     ENI_RES_3_MV
          ENI_RES_1_MV
               BOM_DEPARTMENTS
               BOM_DEPARTMENT_RESOURCES
               BOM_RESOURCES
          ENI_RES_2_MV
               ENI_RES_1_MV
                    BOM_DEPARTMENTS
                    BOM_DEPARTMENT_RESOURCES
                    BOM_RESOURCES
     ENI_RES_4_MV
          CR_RSRC_DTL
          CR_RSRC_MST_B
FII_TIME_DAY
OPI_DBI_RES_AVAIL_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
GRP_ID NUMBER

Grouping ID Column
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Period Type ID Column for Time
RESOURCE_LEVEL_FLAG NUMBER

Resource Level Aggregation Flag
ORGANIZATION_ID NUMBER

Inventory Organization ID
RESOURCE_ID VARCHAR2 (30)
Resource Identifier
RESOURCE_ORG_ID VARCHAR2 (122)
Organizaiton of the Resource
RESOURCE_GROUP VARCHAR2 (30)
Resource Group
RESOURCE_GROUP_ID VARCHAR2 (32)
Resource Group Identifier
DEPARTMENT_ID VARCHAR2 (40)
Department Identifier
RESOURCE_DEPARTMENT_ID VARCHAR2 (42)
Department of the Resource
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

FII Week Identifier
REPORT_DATE_JULIAN NUMBER

FII Date
AVAIL_VAL_B NUMBER

Available Resource Value in Funcational Currency
AVAIL_VAL_G NUMBER

Available Resource Value in Primary Global Currency
AVAIL_QTY NUMBER

Available Quantity
ACTUAL_VAL_B NUMBER

Actual Value in Functional Currency
ACTUAL_VAL_G NUMBER

Actual Value in Primary Global Currency
ACTUAL_QTY NUMBER

Actual Quantity of Completions
AVAIL_VAL_B_CNT NUMBER

Count Columns
AVAIL_VAL_G_CNT NUMBER

Count Columns
AVAIL_QTY_CNT NUMBER

Count Columns
ACTUAL_VAL_B_CNT NUMBER

Count Columns
ACTUAL_VAL_G_CNT NUMBER

Count Columns
ACTUAL_QTY_CNT NUMBER

Count Columns
AVAIL_VAL_SG NUMBER

Available Resource Value in Secondary Global Currency
AVAIL_VAL_SG_CNT NUMBER

Count Columns
ACTUAL_VAL_SG NUMBER

Actual Value in Secondary Global Currency
ACTUAL_VAL_SG_CNT NUMBER

Count Columns
CNT NUMBER

Count Columns
Query Text

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


SELECT GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      RESOURCE_LEVEL_FLAG
,      ORGANIZATION_ID
,      RESOURCE_ID
,      RESOURCE_ORG_ID
,      RESOURCE_GROUP
,      RESOURCE_GROUP_ID
,      DEPARTMENT_ID
,      RESOURCE_DEPARTMENT_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      REPORT_DATE_JULIAN
,      AVAIL_VAL_B
,      AVAIL_VAL_G
,      AVAIL_QTY
,      ACTUAL_VAL_B
,      ACTUAL_VAL_G
,      ACTUAL_QTY
,      AVAIL_VAL_B_CNT
,      AVAIL_VAL_G_CNT
,      AVAIL_QTY_CNT
,      ACTUAL_VAL_B_CNT
,      ACTUAL_VAL_G_CNT
,      ACTUAL_QTY_CNT
,      AVAIL_VAL_SG
,      AVAIL_VAL_SG_CNT
,      ACTUAL_VAL_SG
,      ACTUAL_VAL_SG_CNT
,      CNT
FROM APPS.OPI_DBI_RES_UTL_MV;

Dependencies

[top of page]

APPS.OPI_DBI_RES_UTL_MV references the following:

SchemaAPPS
TableENI_RES_5_MV
Materialized ViewENI_RES_5_MV
TableOPI_DBI_RES_UTL_MV
SchemaFII
TableFII_TIME_DAY
SchemaOPI
TableOPI_DBI_RES_AVAIL_F

APPS.OPI_DBI_RES_UTL_MV is not referenced by any database object