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

MATERIALIZED VIEW: APPS.ISC_DBI_PM_0000_MV

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

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

Plan Snapshot Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
SR_SUPPLIER_ID NUMBER

Supplier Identifier
ITEM_ID VARCHAR2 (81)
Item Organization Identifier
ITEM_CATEGORY_ID NUMBER

Inventory Category Identifier
GRP_ID NUMBER

Grouping ID Column
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item
START_DATE DATE

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
PURCHASING_COST NUMBER

Purchasing Cost in Functional Currency
PURCHASING_COST_CNT NUMBER

Count Column
PURCHASING_COST_G NUMBER

Purchasing Cost in Global Currency
PUR_COST_G_CNT NUMBER

Count Column
PURCHASING_COST_G1 NUMBER

Purchasing Cost in Secondary Global Currency
PUR_COST_G1_CNT NUMBER

Count Column
CNT NUMBER

Row Count
Query Text

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


SELECT SNAPSHOT_ID
,      ORGANIZATION_ID
,      SR_SUPPLIER_ID
,      ITEM_ID
,      ITEM_CATEGORY_ID
,      GRP_ID
,      ITEM_CAT_FLAG
,      START_DATE
,      PERIOD_TYPE_ID
,      PURCHASING_COST
,      PURCHASING_COST_CNT
,      PURCHASING_COST_G
,      PUR_COST_G_CNT
,      PURCHASING_COST_G1
,      PUR_COST_G1_CNT
,      CNT
FROM APPS.ISC_DBI_PM_0000_MV;

Dependencies

[top of page]

APPS.ISC_DBI_PM_0000_MV references the following:

SchemaAPPS
TableISC_DBI_PM_0000_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaISC
TableISC_DBI_SUPPLIES_SNAPSHOTS

APPS.ISC_DBI_PM_0000_MV is not referenced by any database object