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

MATERIALIZED VIEW: APPS.OPI_SCRAP_SUM_MV

Object Details
Object Name: OPI_SCRAP_SUM_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OPI_SCRAP_SUM_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:

ENI_OLTP_ITEM_STAR
FII_TIME_DAY
OPI_PROD_SCR_MV
     OPI_COMP_SCR_MV
          OKI_DBI_MULTIPLEXER_B
          OPI_DBI_WIP_COMP_F
          OPI_DBI_WIP_SCRAP_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
SOURCE NUMBER

Data source. 1 = OPI, 2 = OPM
INVENTORY_ITEM_ID NUMBER

Item Identifier
UOM_CODE VARCHAR2 (3)
Primary unit of measure
ITEM_ORG_ID VARCHAR2 (81)
Item Organization Identifier
INV_CATEGORY_ID NUMBER

Inventory Category Identifier
GROUPING_ID NUMBER

Grouping ID column
ITEM_CAT_FLAG NUMBER

Aggregation level granularity flag
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Period Type ID Column for Time
ENT_QTR_ID NUMBER

FII Quarter identifier
ENT_PERIOD_ID NUMBER

FII Month identifier
WEEK_ID NUMBER

FII Week Identifier
REPORT_DATE_JULIAN NUMBER

FII Day Identifier
PRODUCTION_QTY NUMBER

Net quantity of production (WIP completions and scrap) in primary unit of measure
PRODUCTION_QTY_CNT NUMBER

Count Column
PRODUCTION_VAL_B NUMBER

Value of production (WIP completions and scrap) in Functional Currency
PRODUCTION_VAL_B_CNT NUMBER

Count Column
PRODUCTION_VAL_G NUMBER

Value of production (WIP completions and scrap) in Primary Global Currency
PRODUCTION_VAL_G_CNT NUMBER

Count Column
SCRAP_QTY NUMBER

Net quantity of scrap
SCRAP_QTY_CNT NUMBER

Count Column
SCRAP_VAL_B NUMBER

Value of scrap in Functional Currency
SCRAP_VAL_B_CNT NUMBER

Count Column
SCRAP_VAL_G NUMBER

Value of scrap in Primary Global Currency
SCRAP_VAL_G_CNT NUMBER

Count Column
PRODUCTION_VAL_SG NUMBER

Value of production (WIP completions and scrap) in Secondary Global Currency
PRODUCTION_VAL_SG_CNT NUMBER

Count Column
SCRAP_VAL_SG NUMBER

Value of scrap in Secondary Global Currency
SCRAP_VAL_SG_CNT NUMBER

Count Column
LINES_CNT NUMBER

Row Count
Query Text

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


SELECT ORGANIZATION_ID
,      SOURCE
,      INVENTORY_ITEM_ID
,      UOM_CODE
,      ITEM_ORG_ID
,      INV_CATEGORY_ID
,      GROUPING_ID
,      ITEM_CAT_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      REPORT_DATE_JULIAN
,      PRODUCTION_QTY
,      PRODUCTION_QTY_CNT
,      PRODUCTION_VAL_B
,      PRODUCTION_VAL_B_CNT
,      PRODUCTION_VAL_G
,      PRODUCTION_VAL_G_CNT
,      SCRAP_QTY
,      SCRAP_QTY_CNT
,      SCRAP_VAL_B
,      SCRAP_VAL_B_CNT
,      SCRAP_VAL_G
,      SCRAP_VAL_G_CNT
,      PRODUCTION_VAL_SG
,      PRODUCTION_VAL_SG_CNT
,      SCRAP_VAL_SG
,      SCRAP_VAL_SG_CNT
,      LINES_CNT
FROM APPS.OPI_SCRAP_SUM_MV;

Dependencies

[top of page]

APPS.OPI_SCRAP_SUM_MV references the following:

SchemaAPPS
TableOPI_PROD_SCR_MV
Materialized ViewOPI_PROD_SCR_MV
TableOPI_SCRAP_SUM_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaFII
TableFII_TIME_DAY

APPS.OPI_SCRAP_SUM_MV is not referenced by any database object