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

MATERIALIZED VIEW: APPS.OPI_PTP_SUM_F_MV

Object Details
Object Name: OPI_PTP_SUM_F_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OPI_PTP_SUM_F_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_PTP_ITEM_F_MV
     OPI_PTP_CBN_MV
          OKI_DBI_MULTIPLEXER_B
          OPI_DBI_PTP_CONV
          OPI_DBI_PTP_COST
          OPI_DBI_PTP_PLAN_F
          OPI_DBI_WIP_COMP_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier
INV_CATEGORY_ID NUMBER

Inventory Category Identifier
ITEM_ORG_ID VARCHAR2 (81)
Inventory Item Organization Identifier
UOM_CODE VARCHAR2 (3)
Primary UOM Code
GROUPING_ID NUMBER

Grouping ID Column
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Period Type Identifier
QTR_ID NUMBER

Enterprise Quarter Identifier
MONTH_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

FII Week Identifier
DAY_ID NUMBER

FII Day Identifier
ACTUAL_QUANTITY NUMBER

Actual Quantity in Primary UOM
ACTUAL_QUANTITY_CNT NUMBER

Count Column
ACTUAL_STANDARD_VALUE_B NUMBER

Actual Standard Value in Functional Currency
ACTUAL_STANDARD_VALUE_B_CNT NUMBER

Count Column
ACTUAL_STANDARD_VALUE_G NUMBER

Actual Standard Value in Primary Global Currency
ACTUAL_STANDARD_VALUE_G_CNT NUMBER

Count Column
PLANNED_QUANTITY NUMBER

Planned Quantity in Primary UOM
PLANNED_QUANTITY_CNT NUMBER

Count Column
PLANNED_STANDARD_VALUE_B NUMBER

Planned Standard Value in Functional Currency
PLANNED_STANDARD_VALUE_B_CNT NUMBER

Count Column
PLANNED_STANDARD_VALUE_G NUMBER

Planned Standard Value in Primary Global Currency
PLANNED_STANDARD_VALUE_G_CNT NUMBER

Count Column
ACTUAL_STANDARD_VALUE_SG NUMBER

Actual Standard Value in Secondary Global Currency
ACTUAL_STANDARD_VALUE_SG_CNT NUMBER

Count Column
PLANNED_STANDARD_VALUE_SG NUMBER

Planned Standard Value in Secondary Global Currency
PLANNED_STANDARD_VALUE_SG_CNT NUMBER

Count Column
CNT NUMBER

Row Count
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      INV_CATEGORY_ID
,      ITEM_ORG_ID
,      UOM_CODE
,      GROUPING_ID
,      ITEM_CAT_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      QTR_ID
,      MONTH_ID
,      WEEK_ID
,      DAY_ID
,      ACTUAL_QUANTITY
,      ACTUAL_QUANTITY_CNT
,      ACTUAL_STANDARD_VALUE_B
,      ACTUAL_STANDARD_VALUE_B_CNT
,      ACTUAL_STANDARD_VALUE_G
,      ACTUAL_STANDARD_VALUE_G_CNT
,      PLANNED_QUANTITY
,      PLANNED_QUANTITY_CNT
,      PLANNED_STANDARD_VALUE_B
,      PLANNED_STANDARD_VALUE_B_CNT
,      PLANNED_STANDARD_VALUE_G
,      PLANNED_STANDARD_VALUE_G_CNT
,      ACTUAL_STANDARD_VALUE_SG
,      ACTUAL_STANDARD_VALUE_SG_CNT
,      PLANNED_STANDARD_VALUE_SG
,      PLANNED_STANDARD_VALUE_SG_CNT
,      CNT
FROM APPS.OPI_PTP_SUM_F_MV;

Dependencies

[top of page]

APPS.OPI_PTP_SUM_F_MV references the following:

SchemaAPPS
TableOPI_PTP_ITEM_F_MV
Materialized ViewOPI_PTP_ITEM_F_MV
TableOPI_PTP_SUM_F_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaFII
TableFII_TIME_DAY

APPS.OPI_PTP_SUM_F_MV is not referenced by any database object