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

MATERIALIZED VIEW: APPS.OPI_PTP_CBN_MV

Object Details
Object Name: OPI_PTP_CBN_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OPI_PTP_CBN_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: TEXTMATCH
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

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
F_ROWID ROWID (10)
Row Identifier column.
COST_ROWID ROWID (10)
Row Identifier column.
CONV_ROWID ROWID (10)
Row Identifier column.
ORGANIZATION_ID NUMBER

Inventory Organization Identifier.
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier.
TRANSACTION_DATE DATE

Transaction Date.
ACTUAL_QUANTITY NUMBER

Actual Quantity in Primary UOM.
ACTUAL_QUANTITY_CNT NUMBER

Count column.
PLANNED_QUANTITY NUMBER

Planned Quantity in Primary UOM.
PLANNED_ITEM VARCHAR2 (1)
Planned Item Flag.
UOM_CODE VARCHAR2 (3)
Primary UOM Code.
UNIT_COST NUMBER

Inventory Item Unit Cost.
CONVERSION_RATE NUMBER

Currency Conversion Rate.
MARKER NUMBER

Materialized view marker.
SEC_CONVERSION_RATE NUMBER

Secondary Global Currency Conversion Rate.
CNT NUMBER

Row count.
Query Text

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


SELECT F_ROWID
,      COST_ROWID
,      CONV_ROWID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      ACTUAL_QUANTITY
,      ACTUAL_QUANTITY_CNT
,      PLANNED_QUANTITY
,      PLANNED_ITEM
,      UOM_CODE
,      UNIT_COST
,      CONVERSION_RATE
,      MARKER
,      SEC_CONVERSION_RATE
,      CNT
FROM APPS.OPI_PTP_CBN_MV;

Dependencies

[top of page]

APPS.OPI_PTP_CBN_MV references the following:

SchemaAPPS
TableOPI_PTP_CBN_MV
SchemaOKI
TableOKI_DBI_MULTIPLEXER_B
SchemaOPI
TableOPI_DBI_PTP_CONV
TableOPI_DBI_PTP_COST
TableOPI_DBI_PTP_PLAN_F
TableOPI_DBI_WIP_COMP_F
APPS.OPI_PTP_CBN_MV is referenced by following:

SchemaAPPS
Materialized ViewOPI_PTP_ITEM_F_MV