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

MATERIALIZED VIEW: APPS.OPI_PTP_ITEM_F_MV

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

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

Transaction Date
UOM_CODE VARCHAR2 (3)
Primary UOM Code
PLANNED_ITEM VARCHAR2 (1)
Planed Item Flag
ACTUAL_QUANTITY NUMBER

Actual Quantity in Primary UOM
ACTUAL_STANDARD_VALUE_B NUMBER

Actual Standard Value in Functional Currency
ACTUAL_STANDARD_VALUE_G NUMBER

Actual Standard Value in Primary Global Currency
PLANNED_QUANTITY NUMBER

Planned Quantity in Primary UOM
PLANNED_STANDARD_VALUE_B NUMBER

Planned Standard Value in Functional Currency
PLANNED_STANDARD_VALUE_G NUMBER

Planned Standard Value in Primary Global Currency
ACT_QTY_CNT NUMBER

Count Column
ACT_STD_VAL_B_CNT NUMBER

Count Column
ACT_STD_VAL_G_CNT NUMBER

Count Column
PLN_QTY_CNT NUMBER

Count Column
PLN_STD_VAL_B_CNT NUMBER

Count Column
PLN_STD_VAL_G_CNT NUMBER

Count Column
ACTUAL_STANDARD_VALUE_SG NUMBER

Actual Standard Value in Secondary Global Currency
ACT_STD_VAL_SG_CNT NUMBER

Count Column
PLANNED_STANDARD_VALUE_SG NUMBER

Planned Standard Value in Secondary Global Currency
PLN_STD_VAL_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
,      TRANSACTION_DATE
,      UOM_CODE
,      PLANNED_ITEM
,      ACTUAL_QUANTITY
,      ACTUAL_STANDARD_VALUE_B
,      ACTUAL_STANDARD_VALUE_G
,      PLANNED_QUANTITY
,      PLANNED_STANDARD_VALUE_B
,      PLANNED_STANDARD_VALUE_G
,      ACT_QTY_CNT
,      ACT_STD_VAL_B_CNT
,      ACT_STD_VAL_G_CNT
,      PLN_QTY_CNT
,      PLN_STD_VAL_B_CNT
,      PLN_STD_VAL_G_CNT
,      ACTUAL_STANDARD_VALUE_SG
,      ACT_STD_VAL_SG_CNT
,      PLANNED_STANDARD_VALUE_SG
,      PLN_STD_VAL_SG_CNT
,      CNT
FROM APPS.OPI_PTP_ITEM_F_MV;

Dependencies

[top of page]

APPS.OPI_PTP_ITEM_F_MV references the following:

SchemaAPPS
TableOPI_PTP_CBN_MV
Materialized ViewOPI_PTP_CBN_MV
TableOPI_PTP_ITEM_F_MV
APPS.OPI_PTP_ITEM_F_MV is referenced by following:

SchemaAPPS
Materialized ViewOPI_PTP_SUM_F_MV