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

TABLE: APPS.ISC_DBI_FM_0006_MV

Object Details
Object Name: ISC_DBI_FM_0006_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableISC.ISC_DBI_FM_0006_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_FM_0006_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("INV_ORG_ID")
ColumnSYS_OP_MAP_NONNULL("CUSTOMER_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("UOM")
ColumnSYS_OP_MAP_NONNULL("TIME_SNAPSHOT_DATE_ID")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_CAT_FLAG")
ColumnSYS_OP_MAP_NONNULL("CUSTOMER_FLAG")
ISC_DBI_FM_0006_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_SNAPSHOT_DATE_ID
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnCUSTOMER_ID
ColumnITEM_CATEGORY_ID
ISC_DBI_FM_0006_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_SNAPSHOT_DATE_ID
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnITEM_ID
ColumnCUSTOMER_ID
ISC_DBI_FM_0006_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_SNAPSHOT_DATE_ID
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnITEM_CATEGORY_ID
ColumnINV_ORG_ID
Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

Inventory Organization Identifier
CUSTOMER_ID NUMBER

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

Inventory Category Identifier
TIME_SNAPSHOT_DATE_ID DATE

Date on which the snapshot was taken
UOM VARCHAR2 (30)
Unit Of Measure Code
GRP_ID NUMBER

Grouping ID Column
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
DAYS_LATE NUMBER

Count of Days Late (to Schedule)
DAYS_LATE_CNT NUMBER

Count Column
PDUE_LINE_CNT NUMBER

Count of Past Due Schedule Order Lines
PDUE_LINE_CNT_C NUMBER

Count Column
PDUE_QTY NUMBER

Past Due Quantity
PDUE_QTY_CNT NUMBER

Count Column
BUCKET1_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket1
BUCKET2_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket2
BUCKET3_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket3
BUCKET4_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket4
BUCKET5_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket5
BUCKET6_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket6
BUCKET7_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket7
BUCKET8_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket8
BUCKET9_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket9
BUCKET10_LINE_CNT NUMBER

Count of Past Due Schedule Lines for Bucket10
BUCKET1_LINE_CNT_C NUMBER

Count Column
BUCKET2_LINE_CNT_C NUMBER

Count Column
BUCKET3_LINE_CNT_C NUMBER

Count Column
BUCKET4_LINE_CNT_C NUMBER

Count Column
BUCKET5_LINE_CNT_C NUMBER

Count Column
BUCKET6_LINE_CNT_C NUMBER

Count Column
BUCKET7_LINE_CNT_C NUMBER

Count Column
BUCKET8_LINE_CNT_C NUMBER

Count Column
BUCKET9_LINE_CNT_C NUMBER

Count Column
BUCKET10_LINE_CNT_C NUMBER

Count Column
BUCKET1_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket1
BUCKET2_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket2
BUCKET3_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucke3
BUCKET4_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket4
BUCKET5_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket5
BUCKET6_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket6
BUCKET7_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket7
BUCKET8_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket8
BUCKET9_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket9
BUCKET10_DAYS_LATE NUMBER

Count of Days Late (to schedule) for Bucket10
BUCKET1_DAYS_LATE_C NUMBER

Count Column
BUCKET2_DAYS_LATE_C NUMBER

Count Column
BUCKET3_DAYS_LATE_C NUMBER

Count Column
BUCKET4_DAYS_LATE_C NUMBER

Count Column
BUCKET5_DAYS_LATE_C NUMBER

Count Column
BUCKET6_DAYS_LATE_C NUMBER

Count Column
BUCKET7_DAYS_LATE_C NUMBER

Count Column
BUCKET8_DAYS_LATE_C NUMBER

Count Column
BUCKET9_DAYS_LATE_C NUMBER

Count Column
BUCKET10_DAYS_LATE_C NUMBER

Count Column
BUCKET1_QTY NUMBER

Past Due Schedule Quantity for Bucket1
BUCKET2_QTY NUMBER

Past Due Schedule Quantity for Bucket2
BUCKET3_QTY NUMBER

Past Due Schedule Quantity for Bucket3
BUCKET4_QTY NUMBER

Past Due Schedule Quantity for Bucket4
BUCKET5_QTY NUMBER

Past Due Schedule Quantity for Bucket5
BUCKET6_QTY NUMBER

Past Due Schedule Quantity for Bucket6
BUCKET7_QTY NUMBER

Past Due Schedule Quantity for Bucket7
BUCKET8_QTY NUMBER

Past Due Schedule Quantity for Bucket8
BUCKET9_QTY NUMBER

Past Due Schedule Quantity for Bucket9
BUCKET10_QTY NUMBER

Past Due Schedule Quantity for Bucket10
BUCKET1_QTY_C NUMBER

Count Column
BUCKET2_QTY_C NUMBER

Count Column
BUCKET3_QTY_C NUMBER

Count Column
BUCKET4_QTY_C NUMBER

Count Column
BUCKET5_QTY_C NUMBER

Count Column
BUCKET6_QTY_C NUMBER

Count Column
BUCKET7_QTY_C NUMBER

Count Column
BUCKET8_QTY_C NUMBER

Count Column
BUCKET9_QTY_C NUMBER

Count Column
BUCKET10_QTY_C NUMBER

Count Column
LINES_CNT NUMBER

Row Count
Query Text

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


SELECT INV_ORG_ID
,      CUSTOMER_ID
,      ITEM_ID
,      ITEM_CATEGORY_ID
,      TIME_SNAPSHOT_DATE_ID
,      UOM
,      GRP_ID
,      ITEM_CAT_FLAG
,      CUSTOMER_FLAG
,      DAYS_LATE
,      DAYS_LATE_CNT
,      PDUE_LINE_CNT
,      PDUE_LINE_CNT_C
,      PDUE_QTY
,      PDUE_QTY_CNT
,      BUCKET1_LINE_CNT
,      BUCKET2_LINE_CNT
,      BUCKET3_LINE_CNT
,      BUCKET4_LINE_CNT
,      BUCKET5_LINE_CNT
,      BUCKET6_LINE_CNT
,      BUCKET7_LINE_CNT
,      BUCKET8_LINE_CNT
,      BUCKET9_LINE_CNT
,      BUCKET10_LINE_CNT
,      BUCKET1_LINE_CNT_C
,      BUCKET2_LINE_CNT_C
,      BUCKET3_LINE_CNT_C
,      BUCKET4_LINE_CNT_C
,      BUCKET5_LINE_CNT_C
,      BUCKET6_LINE_CNT_C
,      BUCKET7_LINE_CNT_C
,      BUCKET8_LINE_CNT_C
,      BUCKET9_LINE_CNT_C
,      BUCKET10_LINE_CNT_C
,      BUCKET1_DAYS_LATE
,      BUCKET2_DAYS_LATE
,      BUCKET3_DAYS_LATE
,      BUCKET4_DAYS_LATE
,      BUCKET5_DAYS_LATE
,      BUCKET6_DAYS_LATE
,      BUCKET7_DAYS_LATE
,      BUCKET8_DAYS_LATE
,      BUCKET9_DAYS_LATE
,      BUCKET10_DAYS_LATE
,      BUCKET1_DAYS_LATE_C
,      BUCKET2_DAYS_LATE_C
,      BUCKET3_DAYS_LATE_C
,      BUCKET4_DAYS_LATE_C
,      BUCKET5_DAYS_LATE_C
,      BUCKET6_DAYS_LATE_C
,      BUCKET7_DAYS_LATE_C
,      BUCKET8_DAYS_LATE_C
,      BUCKET9_DAYS_LATE_C
,      BUCKET10_DAYS_LATE_C
,      BUCKET1_QTY
,      BUCKET2_QTY
,      BUCKET3_QTY
,      BUCKET4_QTY
,      BUCKET5_QTY
,      BUCKET6_QTY
,      BUCKET7_QTY
,      BUCKET8_QTY
,      BUCKET9_QTY
,      BUCKET10_QTY
,      BUCKET1_QTY_C
,      BUCKET2_QTY_C
,      BUCKET3_QTY_C
,      BUCKET4_QTY_C
,      BUCKET5_QTY_C
,      BUCKET6_QTY_C
,      BUCKET7_QTY_C
,      BUCKET8_QTY_C
,      BUCKET9_QTY_C
,      BUCKET10_QTY_C
,      LINES_CNT
FROM APPS.ISC_DBI_FM_0006_MV;

Dependencies

[top of page]

APPS.ISC_DBI_FM_0006_MV does not reference any database object

APPS.ISC_DBI_FM_0006_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_FM_0006_MV