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

TABLE: APPS.ISC_DBI_PM_0001_MV

Object Details
Object Name: ISC_DBI_PM_0001_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableISC.ISC_DBI_PM_0001_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_ISC_DBI_PM_0001_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("SNAPSHOT_ID")
ColumnSYS_OP_MAP_NONNULL("ORGANIZATION_ID")
ColumnSYS_OP_MAP_NONNULL("VBH_CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("INV_CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("UOM_CODE")
ColumnSYS_OP_MAP_NONNULL("START_DATE")
ColumnSYS_OP_MAP_NONNULL("PERIOD_TYPE_ID")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
ISC_DBI_PM_0001_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSTART_DATE
ColumnSNAPSHOT_ID
ColumnPERIOD_TYPE_ID
ColumnITEM_CAT_FLAG
ColumnITEM_ID
ISC_DBI_PM_0001_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSTART_DATE
ColumnSNAPSHOT_ID
ColumnPERIOD_TYPE_ID
ColumnITEM_CAT_FLAG
ColumnINV_CATEGORY_ID
ColumnORGANIZATION_ID
ISC_DBI_PM_0001_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSTART_DATE
ColumnSNAPSHOT_ID
ColumnPERIOD_TYPE_ID
ColumnITEM_CAT_FLAG
ColumnVBH_CATEGORY_ID
ColumnORGANIZATION_ID
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 does not reference any database object

APPS.ISC_DBI_PM_0001_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_PM_0001_MV
Materialized ViewISC_DBI_PM_0003_MV