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


TABLE: APPS.ISC_DBI_CFM_002_MV

Object Details
Object Name: ISC_DBI_CFM_002_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.ISC_DBI_CFM_002_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_CFM_002_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("RETURN_FLAG")
ColumnSYS_OP_MAP_NONNULL("CUSTOMER_ID")
ColumnSYS_OP_MAP_NONNULL("INV_ORG_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("MASTER_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("UOM")
ColumnSYS_OP_MAP_NONNULL("ENT_QTR_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_PERIOD_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("DAY_ID")
ColumnSYS_OP_MAP_NONNULL("CUSTOMER_FLAG")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
ISC_DBI_CFM_002_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnRETURN_FLAG
ColumnCUSTOMER_ID
ColumnITEM_CATEGORY_ID
ISC_DBI_CFM_002_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnRETURN_FLAG
ColumnITEM_ID
ColumnCUSTOMER_ID
ISC_DBI_CFM_002_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnRETURN_FLAG
ColumnMASTER_ITEM_ID
ColumnCUSTOMER_ID
ISC_DBI_CFM_002_MV_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnRETURN_FLAG
ColumnITEM_CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

Inventory Organization Identifier
ITEM_ID VARCHAR2 (25)
Item Organization Identifier
MASTER_ITEM_ID VARCHAR2 (25)
Item Identifier
ITEM_CATEGORY_ID NUMBER

Product Category Identifier
CUSTOMER_ID NUMBER

Customer Identifier
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
RETURN_FLAG NUMBER

Grouping ID Column for Return Order Lines
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
DAY_ID NUMBER

FII Day Identifier
WEEK_ID NUMBER

FII Week Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
GRP_ID NUMBER

Grouping ID Column
FULFILLED_AMT_G NUMBER

Fulfilled amount in Global currency
FULFILLED_AMT_G_CNT NUMBER

Count Column
FULFILLED_AMT_G1 NUMBER

Fulfilled amount in Secondary Global currency
FULFILLED_AMT_G1_CNT NUMBER

Count Column
FULFILLED_AMT_F NUMBER

Fulfilled amount in Functional currency
FULFILLED_AMT_F_CNT NUMBER

Count Column
BOOKED_AMT_G NUMBER

Booked amount in Global currency
BOOKED_AMT_G_CNT NUMBER

Count Column
BOOKED_AMT_G1 NUMBER

Booked amount in Secondary Global currency
BOOKED_AMT_G1_CNT NUMBER

Count Column
BOOKED_AMT_F NUMBER

Booked amount in Functional currency
BOOKED_AMT_F_CNT NUMBER

Count Column
BOOKED_QTY NUMBER

Booked Quantity
BOOKED_QTY_CNT NUMBER

Count Column
FULFILLED_AMT2_G NUMBER

Fulfilled amount (for backlog calculation) in Global currency
FULFILLED_AMT2_G_CNT NUMBER

Count Column
FULFILLED_AMT2_G1 NUMBER

Fulfilled amount (for backlog calculation) in Secondary Global currency
FULFILLED_AMT2_G1_CNT NUMBER

Count Column
FULFILLED_AMT2_F NUMBER

Fulfilled amount (for backlog calculation) in Functional currency
FULFILLED_AMT2_F_CNT NUMBER

Count Column
RETURNED_AMT_G NUMBER

Returned amount in Global currency
RETURNED_AMT_G_CNT NUMBER

Count Column
RETURNED_AMT_G1 NUMBER

Returned amount in Secondary Global currency
RETURNED_AMT_G1_CNT NUMBER

Count Column
RETURNED_AMT_F NUMBER

Returned amount in Functional currency
RETURNED_AMT_F_CNT NUMBER

Count Column
UOM VARCHAR2 (30)
Unit Of Measure Code
FULFILLED_QTY NUMBER

Fulfilled Quantity
FULFILLED_QTY_CNT NUMBER

Count Column
RETURNED_QTY NUMBER

Returned Quantity
RETURNED_QTY_CNT NUMBER

Count Column
BOOK_TO_FULFILL_DAYS NUMBER

Count of Days between booked date and fulfilled date
BOOK_TO_FULFILL_DAYS_C NUMBER

Count Column
BOOK_TO_FULFILL_CNT NUMBER

Count of booked lines (used for book to fulfill ratio calculation)
BOOK_TO_FULFILL_CNT_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
,      ITEM_ID
,      MASTER_ITEM_ID
,      ITEM_CATEGORY_ID
,      CUSTOMER_ID
,      ITEM_CAT_FLAG
,      CUSTOMER_FLAG
,      RETURN_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      DAY_ID
,      WEEK_ID
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      GRP_ID
,      FULFILLED_AMT_G
,      FULFILLED_AMT_G_CNT
,      FULFILLED_AMT_G1
,      FULFILLED_AMT_G1_CNT
,      FULFILLED_AMT_F
,      FULFILLED_AMT_F_CNT
,      BOOKED_AMT_G
,      BOOKED_AMT_G_CNT
,      BOOKED_AMT_G1
,      BOOKED_AMT_G1_CNT
,      BOOKED_AMT_F
,      BOOKED_AMT_F_CNT
,      BOOKED_QTY
,      BOOKED_QTY_CNT
,      FULFILLED_AMT2_G
,      FULFILLED_AMT2_G_CNT
,      FULFILLED_AMT2_G1
,      FULFILLED_AMT2_G1_CNT
,      FULFILLED_AMT2_F
,      FULFILLED_AMT2_F_CNT
,      RETURNED_AMT_G
,      RETURNED_AMT_G_CNT
,      RETURNED_AMT_G1
,      RETURNED_AMT_G1_CNT
,      RETURNED_AMT_F
,      RETURNED_AMT_F_CNT
,      UOM
,      FULFILLED_QTY
,      FULFILLED_QTY_CNT
,      RETURNED_QTY
,      RETURNED_QTY_CNT
,      BOOK_TO_FULFILL_DAYS
,      BOOK_TO_FULFILL_DAYS_C
,      BOOK_TO_FULFILL_CNT
,      BOOK_TO_FULFILL_CNT_C
,      LINES_CNT
FROM APPS.ISC_DBI_CFM_002_MV;

Dependencies

[top of page]

APPS.ISC_DBI_CFM_002_MV does not reference any database object

APPS.ISC_DBI_CFM_002_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_CFM_002_MV
Materialized ViewISC_DBI_CFM_011_MV
Materialized ViewISC_DBI_CFM_015_MV