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

TABLE: APPS.ISC_DBI_SCR_001_MV

Object Details
Object Name: ISC_DBI_SCR_001_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.ISC_DBI_SCR_001_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
U_SNAP$_ISC_DBI_SCR_001_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("GRP_MARKER")
ColumnSYS_OP_MAP_NONNULL("SALES_GRP_ID")
ColumnSYS_OP_MAP_NONNULL("PARENT_GRP_ID")
ColumnSYS_OP_MAP_NONNULL("CUSTOMER_ID")
ColumnSYS_OP_MAP_NONNULL("CLASS_CODE")
ColumnSYS_OP_MAP_NONNULL("ITEM_CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("ENT_YEAR_ID")
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("GRP_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_CAT_FLAG")
ColumnSYS_OP_MAP_NONNULL("CUSTOMER_FLAG")
ColumnSYS_OP_MAP_NONNULL("RESOURCE_ID")
ISC_DBI_SCR_001_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnSALES_GRP_ID
ColumnRESOURCE_ID
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnCUSTOMER_ID
ColumnITEM_CATEGORY_ID
ColumnCLASS_CODE
ISC_DBI_SCR_001_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnSALES_GRP_ID
ColumnRESOURCE_ID
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnITEM_CATEGORY_ID
ColumnCLASS_CODE
ISC_DBI_SCR_001_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnSALES_GRP_ID
ColumnRESOURCE_ID
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnCLASS_CODE
ColumnCUSTOMER_ID
ISC_DBI_SCR_001_MV_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPARENT_GRP_ID
ColumnGRP_MARKER
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnCUSTOMER_ID
ColumnITEM_CATEGORY_ID
ColumnCLASS_CODE
ISC_DBI_SCR_001_MV_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPARENT_GRP_ID
ColumnGRP_MARKER
ColumnITEM_CAT_FLAG
ColumnCUSTOMER_FLAG
ColumnCLASS_CODE
ColumnITEM_CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
UMARKER NUMBER

Union Marker Column
GRP_MARKER VARCHAR2 (9)
Flag to Identify resource, group or top_group
PARENT_GRP_ID NUMBER

Grand Parent JTF RESOURCE GROUP Identifier
SALES_GRP_ID NUMBER

JTF Resource Identifier
RESOURCE_ID NUMBER

JTF Resource Identifier
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
CUSTOMER_ID NUMBER

Customer Identifier
CLASS_CODE VARCHAR2 (30)
Customer Classification code
ITEM_CATEGORY_ID NUMBER

Product Category Identifier
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
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
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
GRP_ID NUMBER

Grouping ID 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
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
NET_BOOKED_AMT_G NUMBER

Net Booked amount in Global currency
NET_BOOKED_AMT_G_CNT NUMBER

Count Column
NET_BOOKED_AMT_G1 NUMBER

Net Booked amount in Secondary Global currency
NET_BOOKED_AMT_G1_CNT NUMBER

Count Column
BACKLOG_AMT_G NUMBER

Backlogged amount in Global currency
BACKLOG_AMT_G_CNT NUMBER

Count Column
BACKLOG_AMT_G1 NUMBER

Backlogged amount in Secondary Global currency
BACKLOG_AMT_G1_CNT NUMBER

Count Column
RECOGNIZED_AMT_G NUMBER

Recognized Revenue amount in Global currency
RECOGNIZED_AMT_G_CNT NUMBER

Count Column
RECOGNIZED_AMT_G1 NUMBER

Recognized Revenue amount in Secondary Global currency
RECOGNIZED_AMT_G1_CNT NUMBER

Count Column
DEFERRED_AMT_G NUMBER

Deferred Revenue amount in Global currency
DEFERRED_AMT_G_CNT NUMBER

Count Column
DEFERRED_AMT_G1 NUMBER

Deferred Revenue amount in Secondary Global currency
DEFERRED_AMT_G1_CNT NUMBER

Count Column
BOOKED_REV_YR_G NUMBER

Revenue (booked this year) amount in Global currency
BOOKED_REV_QR_G NUMBER

Revenue (booked this qtr) amount in Global currency
BOOKED_REV_PE_G NUMBER

Revenue (booked this period) amount in Global currency
BOOKED_REV_WK_G NUMBER

Revenue (booked this week) amount in Global currency
BOOKED_REV_YR_G1 NUMBER

Revenue (booked this year) amount in Secondary Global currency
BOOKED_REV_QR_G1 NUMBER

Revenue (booked this qtr) amount in Secondary Global currency
BOOKED_REV_PE_G1 NUMBER

Revenue (booked this period) amount in Secondary Global currency
BOOKED_REV_WK_G1 NUMBER

Revenue (booked this week) amount in Secondary Global currency
BOOKED_REV_YR_G_CT NUMBER

Count Column
BOOKED_REV_QR_G_CT NUMBER

Count Column
BOOKED_REV_PE_G_CT NUMBER

Count Column
BOOKED_REV_WK_G_CT NUMBER

Count Column
BOOKED_REV_YR_G1_CT NUMBER

Count Column
BOOKED_REV_QR_G1_CT NUMBER

Count Column
BOOKED_REV_PE_G1_CT NUMBER

Count Column
BOOKED_REV_WK_G1_CT NUMBER

Count Column
CNT NUMBER

Row Count
Query Text

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


SELECT UMARKER
,      GRP_MARKER
,      PARENT_GRP_ID
,      SALES_GRP_ID
,      RESOURCE_ID
,      CUSTOMER_FLAG
,      CUSTOMER_ID
,      CLASS_CODE
,      ITEM_CATEGORY_ID
,      ITEM_CAT_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      DAY_ID
,      WEEK_ID
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      ENT_YEAR_ID
,      GRP_ID
,      BOOKED_AMT_G
,      BOOKED_AMT_G_CNT
,      BOOKED_AMT_G1
,      BOOKED_AMT_G1_CNT
,      RETURNED_AMT_G
,      RETURNED_AMT_G_CNT
,      RETURNED_AMT_G1
,      RETURNED_AMT_G1_CNT
,      NET_BOOKED_AMT_G
,      NET_BOOKED_AMT_G_CNT
,      NET_BOOKED_AMT_G1
,      NET_BOOKED_AMT_G1_CNT
,      BACKLOG_AMT_G
,      BACKLOG_AMT_G_CNT
,      BACKLOG_AMT_G1
,      BACKLOG_AMT_G1_CNT
,      RECOGNIZED_AMT_G
,      RECOGNIZED_AMT_G_CNT
,      RECOGNIZED_AMT_G1
,      RECOGNIZED_AMT_G1_CNT
,      DEFERRED_AMT_G
,      DEFERRED_AMT_G_CNT
,      DEFERRED_AMT_G1
,      DEFERRED_AMT_G1_CNT
,      BOOKED_REV_YR_G
,      BOOKED_REV_QR_G
,      BOOKED_REV_PE_G
,      BOOKED_REV_WK_G
,      BOOKED_REV_YR_G1
,      BOOKED_REV_QR_G1
,      BOOKED_REV_PE_G1
,      BOOKED_REV_WK_G1
,      BOOKED_REV_YR_G_CT
,      BOOKED_REV_QR_G_CT
,      BOOKED_REV_PE_G_CT
,      BOOKED_REV_WK_G_CT
,      BOOKED_REV_YR_G1_CT
,      BOOKED_REV_QR_G1_CT
,      BOOKED_REV_PE_G1_CT
,      BOOKED_REV_WK_G1_CT
,      CNT
FROM APPS.ISC_DBI_SCR_001_MV;

Dependencies

[top of page]

APPS.ISC_DBI_SCR_001_MV does not reference any database object

APPS.ISC_DBI_SCR_001_MV is referenced by following:

SchemaAPPS
Materialized ViewBIL_BI_SLS_PERF1_MV
Materialized ViewBIL_BI_SLS_PERF_MV
Materialized ViewISC_DBI_SCR_001_MV
Materialized ViewISC_DBI_SCR_002_MV