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

MATERIALIZED VIEW: APPS.OPI_DBI_RES_VAR_MV

Object Details
Object Name: OPI_DBI_RES_VAR_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OPI_DBI_RES_VAR_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_JOBS_F
OPI_DBI_RES_ACTUAL_F
OPI_DBI_RES_STD_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 Flag
ORGANIZATION_ID NUMBER

Inventory Organization ID
RESOURCE_ID NUMBER

Resource ID
RESOURCE_ORG_ID VARCHAR2 (122)
Organization 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
STD_USAGE_VAL_B NUMBER

Standard Usage of Resources in Functional Currency
STD_USAGE_VAL_G NUMBER

Standard Usage of Resources in Primary Global Currency
STD_USAGE_QTY NUMBER

Standard Usage of Resource
ACTUAL_VAL_B NUMBER

Actual Units of Resource at Actual Cost in Functional Currency
ACTUAL_VAL_G NUMBER

Actual Units of Resource at Actual Cost in Primary Global Currency
ACTUAL_QTY NUMBER

Actual Quantity of WIP Completions
STD_USAGE_VAL_B_CNT NUMBER

Count Columns
STD_USAGE_VAL_G_CNT NUMBER

Count Columns
STD_USAGE_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
STD_USAGE_VAL_SG NUMBER

Standard Usage of Resources in Secondary Global Currency
STD_USAGE_VAL_SG_CNT NUMBER

Count Columns
ACTUAL_VAL_SG NUMBER

Actual Units of Resource at Actual Cost in Secondary Global Currency
ACTUAL_VAL_SG_CNT NUMBER

Count Columns
CNT NUMBER

Row Count
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
,      STD_USAGE_VAL_B
,      STD_USAGE_VAL_G
,      STD_USAGE_QTY
,      ACTUAL_VAL_B
,      ACTUAL_VAL_G
,      ACTUAL_QTY
,      STD_USAGE_VAL_B_CNT
,      STD_USAGE_VAL_G_CNT
,      STD_USAGE_QTY_CNT
,      ACTUAL_VAL_B_CNT
,      ACTUAL_VAL_G_CNT
,      ACTUAL_QTY_CNT
,      STD_USAGE_VAL_SG
,      STD_USAGE_VAL_SG_CNT
,      ACTUAL_VAL_SG
,      ACTUAL_VAL_SG_CNT
,      CNT
FROM APPS.OPI_DBI_RES_VAR_MV;

Dependencies

[top of page]

APPS.OPI_DBI_RES_VAR_MV references the following:

SchemaAPPS
TableENI_RES_5_MV
Materialized ViewENI_RES_5_MV
TableOPI_DBI_RES_VAR_MV
SchemaFII
TableFII_TIME_DAY
SchemaOPI
TableOPI_DBI_JOBS_F
TableOPI_DBI_RES_ACTUAL_F
TableOPI_DBI_RES_STD_F

APPS.OPI_DBI_RES_VAR_MV is not referenced by any database object