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

MATERIALIZED VIEW: APPS.OPI_MTL_VAR_ACT_MV_F

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

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Manufacturing Organization Identifier
JOB_TYPE NUMBER
Yes Manufacturing Job Type
JOB_ID NUMBER
Yes Manufacturing Job Id
ASSEMBLY_ITEM_ID NUMBER

Assembly Inventory Item Identifier
COMPONENT_ITEM_ID NUMBER

Component Item Identifier
SOURCE NUMBER
Yes Data source. 1 = OPI, 2 = OPM
ACTUAL_QUANTITY NUMBER

ACTUAL_QUANTITY_CNT NUMBER

ACTUAL_VALUE_B NUMBER

Actual Material Cost in Functional Currency
ACTUAL_VALUE_B_CNT NUMBER

Count Columns
ACTUAL_VALUE_G NUMBER

Actual Material Cost in Primary Global Currency
ACTUAL_VALUE_G_CNT NUMBER

Count Columns
ACTUAL_VALUE_SG NUMBER

Actual Material Cost in Secondary Global Currency
ACTUAL_VALUE_SG_CNT NUMBER

Count Columns
CNT NUMBER

Row Count
Query Text

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


SELECT ORGANIZATION_ID
,      JOB_TYPE
,      JOB_ID
,      ASSEMBLY_ITEM_ID
,      COMPONENT_ITEM_ID
,      SOURCE
,      ACTUAL_QUANTITY
,      ACTUAL_QUANTITY_CNT
,      ACTUAL_VALUE_B
,      ACTUAL_VALUE_B_CNT
,      ACTUAL_VALUE_G
,      ACTUAL_VALUE_G_CNT
,      ACTUAL_VALUE_SG
,      ACTUAL_VALUE_SG_CNT
,      CNT
FROM APPS.OPI_MTL_VAR_ACT_MV_F;

Dependencies

[top of page]

APPS.OPI_MTL_VAR_ACT_MV_F references the following:

SchemaAPPS
TableOPI_MTL_VAR_ACT_MV_F
SchemaOPI
TableOPI_DBI_JOB_MTL_DETAILS_F
APPS.OPI_MTL_VAR_ACT_MV_F is referenced by following:

SchemaAPPS
Materialized ViewOPI_MTL_VAR_MV_F