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

MATERIALIZED VIEW: APPS.OPI_PTP_RPT_BND_MV

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

OPI_DBI_RUN_LOG_CURR

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
DATA_CLEAN_DATE DATE

Data Clean Date
Query Text

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


SELECT ORGANIZATION_ID
,      DATA_CLEAN_DATE
FROM APPS.OPI_PTP_RPT_BND_MV;

Dependencies

[top of page]

APPS.OPI_PTP_RPT_BND_MV references the following:

SchemaAPPS
TableOPI_PTP_RPT_BND_MV
SchemaINV
TableMTL_PARAMETERS
SchemaOPI
TableOPI_DBI_RUN_LOG_CURR

APPS.OPI_PTP_RPT_BND_MV is not referenced by any database object