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

MATERIALIZED VIEW: APPS.ISC_DBI_SCR_002_MV

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

ENI_DENORM_HIERARCHIES
ISC_DBI_SCR_001_MV
     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
MTL_DEFAULT_CATEGORY_SETS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
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
CAT_TOP_NODE_FLAG VARCHAR2 (1)
Flag to Indicate the Top Node Product Categor
ITEM_CATEGORY_ID NUMBER

Product Category Identifier
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
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 GRP_MARKER
,      PARENT_GRP_ID
,      SALES_GRP_ID
,      RESOURCE_ID
,      CAT_TOP_NODE_FLAG
,      ITEM_CATEGORY_ID
,      TIME_ID
,      PERIOD_TYPE_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_002_MV;

Dependencies

[top of page]

APPS.ISC_DBI_SCR_002_MV references the following:

SchemaAPPS
TableISC_DBI_SCR_001_MV
Materialized ViewISC_DBI_SCR_001_MV
TableISC_DBI_SCR_002_MV
SchemaENI
TableENI_DENORM_HIERARCHIES
SchemaINV
TableMTL_DEFAULT_CATEGORY_SETS

APPS.ISC_DBI_SCR_002_MV is not referenced by any database object