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

MATERIALIZED VIEW: APPS.ISC_DBI_PM_0001_MV

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

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

Plan Snapshot Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
ITEM_ID VARCHAR2 (81)
Item Organization Identifier
INV_CATEGORY_ID NUMBER

Inventory Category Identifier
VBH_CATEGORY_ID NUMBER

Product Category Identifier
GRP_ID NUMBER

Grouping ID Column
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item
UOM_CODE VARCHAR2 (3)
Unit of Measure Code
START_DATE DATE

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
CARRYING_COST NUMBER

Carrying Cost in Functional Currency
CARRYING_COST_CNT NUMBER

Count Column
CARRYING_COST_G NUMBER

Carrying Cost in Global Currency
CARRYING_COST_G_CNT NUMBER

Count Column
CARRYING_COST_G1 NUMBER

Carrying Cost in Secondary Global Currency
CARRYING_COST_G1_CNT NUMBER

Count Column
COST_SHORTFALL NUMBER

Potential Cost Shortfall in Functional Currency
COST_SH_CNT NUMBER

Count Column
COST_SHORTFALL_G NUMBER

Potential Cost Shortfall in Global Currency
COST_SH_G_CNT NUMBER

Count Column
COST_SHORTFALL_G1 NUMBER

Potential Cost Shortfall in Secondary Global Currency
COST_SH_G1_CNT NUMBER

Count Column
INVENTORY_COST NUMBER

Inventory Cost in Functional Currency
INVENTORY_COST_CNT NUMBER

Count Column
INVENTORY_COST_G NUMBER

Inventory Cost in Global Currency
INVENTORY_COST_G_CNT NUMBER

Count Column
INVENTORY_COST_G1 NUMBER

Inventory Cost in Secondary Global Currency
INVENTORY_COST_G1_CNT NUMBER

Count Column
MDS_COST NUMBER

MDS Cost in Functional Currency
MDS_COST_CNT NUMBER

Count Column
MDS_COST_G NUMBER

MDS Cost in Global Currency
MDS_COST_G_CNT NUMBER

Count Column
MDS_COST_G1 NUMBER

MDS Cost in Secondary Global Currency
MDS_COST_G1_CNT NUMBER

Count Column
MDS_PRICE NUMBER

MDS Price in Functional Currency
MDS_PRICE_CNT NUMBER

Count Column
MDS_PRICE_G NUMBER

MDS Price in Global Currency
MDS_PRICE_G_CNT NUMBER

Count Column
MDS_PRICE_G1 NUMBER

MDS Price in Secondary Global Currency
MDS_PRICE_G1_CNT NUMBER

Count Column
MDS_QUANTITY NUMBER

MDS Quantity
MDS_QUANTITY_CNT NUMBER

Count Column
PRODUCTION_COST NUMBER

Production Cost in Functional Currency
PRODUCTION_COST_CNT NUMBER

Count Column
PRO_COST_G NUMBER

Production Cost in Global Currency
PRO_COST_G_CNT NUMBER

Count Column
PRO_COST_G1 NUMBER

Production Cost in Secondary Global Currency
PRO_COST_G1_CNT NUMBER

Count Column
PURCHASING_COST NUMBER

Purchasing Cost in Functional Currency
PURCHASING_COST_CNT NUMBER

Count Column
PUR_COST_G NUMBER

Purchasing Cost in Global Currency
PUR_COST_G_CNT NUMBER

Count Column
PUR_COST_G1 NUMBER

Purchasing Cost in Secondary Global Currency
PUR_COST_G1_CNT NUMBER

Count Column
LATE_LINES NUMBER

Number of Late Lines
LATE_LINES_CNT NUMBER

Count Column
REV_SHORTFALL NUMBER

Potential Revenue Shortfall in Functional Currency
REV_SH_CNT NUMBER

Count Column
REV_SHORTFALL_G NUMBER

Potential Revenue Shortfall in Global Currency
REV_SH_G_CNT NUMBER

Count Column
REV_SHORTFALL_G1 NUMBER

Potential Revenue Shortfall in Secondary Global Currency
REV_SH_G1_CNT NUMBER

Count Column
TOTAL_LINES NUMBER

Total Number of lines
TOTAL_LINES_CNT NUMBER

Count Column
UNION1_FLAG NUMBER

Union Marker Column
UNION1_FLAG_CNT NUMBER

Count Column
UNION2_FLAG NUMBER

Union Marker Column
UNION2_FLAG_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
,      ITEM_ID
,      INV_CATEGORY_ID
,      VBH_CATEGORY_ID
,      GRP_ID
,      ITEM_CAT_FLAG
,      UOM_CODE
,      START_DATE
,      PERIOD_TYPE_ID
,      CARRYING_COST
,      CARRYING_COST_CNT
,      CARRYING_COST_G
,      CARRYING_COST_G_CNT
,      CARRYING_COST_G1
,      CARRYING_COST_G1_CNT
,      COST_SHORTFALL
,      COST_SH_CNT
,      COST_SHORTFALL_G
,      COST_SH_G_CNT
,      COST_SHORTFALL_G1
,      COST_SH_G1_CNT
,      INVENTORY_COST
,      INVENTORY_COST_CNT
,      INVENTORY_COST_G
,      INVENTORY_COST_G_CNT
,      INVENTORY_COST_G1
,      INVENTORY_COST_G1_CNT
,      MDS_COST
,      MDS_COST_CNT
,      MDS_COST_G
,      MDS_COST_G_CNT
,      MDS_COST_G1
,      MDS_COST_G1_CNT
,      MDS_PRICE
,      MDS_PRICE_CNT
,      MDS_PRICE_G
,      MDS_PRICE_G_CNT
,      MDS_PRICE_G1
,      MDS_PRICE_G1_CNT
,      MDS_QUANTITY
,      MDS_QUANTITY_CNT
,      PRODUCTION_COST
,      PRODUCTION_COST_CNT
,      PRO_COST_G
,      PRO_COST_G_CNT
,      PRO_COST_G1
,      PRO_COST_G1_CNT
,      PURCHASING_COST
,      PURCHASING_COST_CNT
,      PUR_COST_G
,      PUR_COST_G_CNT
,      PUR_COST_G1
,      PUR_COST_G1_CNT
,      LATE_LINES
,      LATE_LINES_CNT
,      REV_SHORTFALL
,      REV_SH_CNT
,      REV_SHORTFALL_G
,      REV_SH_G_CNT
,      REV_SHORTFALL_G1
,      REV_SH_G1_CNT
,      TOTAL_LINES
,      TOTAL_LINES_CNT
,      UNION1_FLAG
,      UNION1_FLAG_CNT
,      UNION2_FLAG
,      UNION2_FLAG_CNT
,      CNT
FROM APPS.ISC_DBI_PM_0001_MV;

Dependencies

[top of page]

APPS.ISC_DBI_PM_0001_MV references the following:

SchemaAPPS
TableISC_DBI_PM_0001_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaISC
TableISC_DBI_INV_DETAIL_SNAPSHOTS
APPS.ISC_DBI_PM_0001_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_PM_0003_MV