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

MATERIALIZED VIEW: APPS.ISC_DBI_SCR_001_MV

Object Details
Object Name: ISC_DBI_SCR_001_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_DBI_SCR_001_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: TEXTMATCH
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

FII_TIME_DAY
ISC_DBI_SCR_000_MV
     ENI_OLTP_ITEM_STAR
     FII_AR_REVENUE_B
     FII_AR_SALES_CREDITS
     FII_GLOBAL_START_DATES
     FII_PARTY_MKT_CLASS
     FII_TIME_DAY
     ISC_BOOK_SUM2_F
     ISC_SALES_CREDITS_F
     JTF_RS_SRP_GROUPS
OKI_RS_GROUP_MV
     JTF_RS_GROUPS_DENORM
     JTF_RS_GROUP_USAGES
     OKI_BI_GRP_CNT_MV
          JTF_RS_GROUPS_DENORM
          JTF_RS_GROUP_USAGES

[View Source Query]

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 references the following:

SchemaAPPS
Materialized ViewISC_DBI_SCR_000_MV
TableISC_DBI_SCR_000_MV
TableISC_DBI_SCR_001_MV
TableOKI_RS_GROUP_MV
Materialized ViewOKI_RS_GROUP_MV
SchemaFII
TableFII_TIME_DAY
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_002_MV