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

MATERIALIZED VIEW: APPS.OPI_PROD_SCR_MV

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

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.
TRANSACTION_DATE DATE

Transaction date.
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.
UOM_CODE VARCHAR2 (3)
Primary Unit of measure.
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.
JOB_ID NUMBER

Job Identifier.
JOB_TYPE NUMBER

Job Type.
CNT NUMBER

Row count.
Query Text

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


SELECT ORGANIZATION_ID
,      SOURCE
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      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
,      UOM_CODE
,      PRODUCTION_VAL_SG
,      PRODUCTION_VAL_SG_CNT
,      SCRAP_VAL_SG
,      SCRAP_VAL_SG_CNT
,      JOB_ID
,      JOB_TYPE
,      CNT
FROM APPS.OPI_PROD_SCR_MV;

Dependencies

[top of page]

APPS.OPI_PROD_SCR_MV references the following:

SchemaAPPS
TableOPI_COMP_SCR_MV
Materialized ViewOPI_COMP_SCR_MV
TableOPI_PROD_SCR_MV
APPS.OPI_PROD_SCR_MV is referenced by following:

SchemaAPPS
Materialized ViewOPI_SCRAP_SUM_MV