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

MATERIALIZED VIEW: APPS.ISC_DBI_SCR_000_MV

Object Details
Object Name: ISC_DBI_SCR_000_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_DBI_SCR_000_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:

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

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
DATA_MARKER NUMBER

Union Marker Column
SALES_GRP_ID NUMBER

JTF Resource Group Identifier
RESOURCE_ID NUMBER

JTF Resource Identifier
CUSTOMER_ID NUMBER

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

Product Category Identifier
INVENTORY_ITEM_ID NUMBER

Item Organization Identifier
MASTER_ORAGNIZATION_ID VARCHAR2 (25)
Master Inventory Organization Identifier
TIME_ID NUMBER

Nested Grouping ID Column for Time
BOOKED_AMT_G NUMBER

Booked amount in Global currency
BOOKED_AMT_G_CNT NUMBER

Count Column
RETURNED_AMT_G NUMBER

Returned amount in Global currency
RETURNED_AMT_G_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_AMT2_G NUMBER

Net Booked amount in Global currency
NET_BOOKED_AMT2_G_CNT NUMBER

Count Column
NET_FULFILLED_AMT_G NUMBER

Net Fulfilled amount in Global currency
NET_FULFILLED_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_G1 NUMBER

Returned amount in Secondary Global currency
RETURNED_AMT_G1_CNT NUMBER

Count Column
NET_BOOKED_AMT_G1 NUMBER

Net Booked amount in Secondary Global currency
NET_BOOKED_AMT_G1_CNT NUMBER

Count Column
NET_BOOKED_AMT2_G1 NUMBER

Net Booked amount in Secondary Global currency
NET_BOOKED_AMT2_G1_CNT NUMBER

Count Column
NET_FULFILLED_AMT_G1 NUMBER

Net Fulfilled amount in Secondary Global currency
NET_FULFILLED_AMT_G1_CNT NUMBER

Count Column
AMOUNT_B NUMBER

Revenue Amount in Functional Currency
PRIM_RECOGNIZED_AMT_G NUMBER

Recognized Revenue amount in Global currency
PRIM_DEFERRED_AMT_G NUMBER

Deferred Revenue amount in Global currency
SEC_RECOGNIZED_AMT_G NUMBER

Recognized Revenue amount in Secondary Global currency
SEC_DEFERRED_AMT_G NUMBER

Deferred Revenue amount in Secondary Global currency
BOOKED_REV_PRIM_YR NUMBER

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

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

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

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

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

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

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

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

Count Column
BOOKED_REV_PRIM_QRCT NUMBER

Count Column
BOOKED_REV_PRIM_PECT NUMBER

Count Column
BOOKED_REV_PRIM_WKCT NUMBER

Count Column
BOOKED_REV_SEC_YRCT NUMBER

Count Column
BOOKED_REV_SEC_QRCT NUMBER

Count Column
BOOKED_REV_SEC_PECT NUMBER

Count Column
BOOKED_REV_SEC_WKCT NUMBER

Count Column
AMOUNT_BCT NUMBER

Count Column
PRIM_RECOGNIZED_AMT_GCT NUMBER

Count Column
PRIM_DEFERRED_AMT_GCT NUMBER

Count Column
SEC_RECOGNIZED_AMT_GCT NUMBER

Count Column
SEC_DEFERRED_AMT_GCT NUMBER

Count Column
CT NUMBER

Row Count
Query Text

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


SELECT DATA_MARKER
,      SALES_GRP_ID
,      RESOURCE_ID
,      CUSTOMER_ID
,      CLASS_CODE
,      ITEM_CATEGORY_ID
,      INVENTORY_ITEM_ID
,      MASTER_ORAGNIZATION_ID
,      TIME_ID
,      BOOKED_AMT_G
,      BOOKED_AMT_G_CNT
,      RETURNED_AMT_G
,      RETURNED_AMT_G_CNT
,      NET_BOOKED_AMT_G
,      NET_BOOKED_AMT_G_CNT
,      NET_BOOKED_AMT2_G
,      NET_BOOKED_AMT2_G_CNT
,      NET_FULFILLED_AMT_G
,      NET_FULFILLED_AMT_G_CNT
,      BOOKED_AMT_G1
,      BOOKED_AMT_G1_CNT
,      RETURNED_AMT_G1
,      RETURNED_AMT_G1_CNT
,      NET_BOOKED_AMT_G1
,      NET_BOOKED_AMT_G1_CNT
,      NET_BOOKED_AMT2_G1
,      NET_BOOKED_AMT2_G1_CNT
,      NET_FULFILLED_AMT_G1
,      NET_FULFILLED_AMT_G1_CNT
,      AMOUNT_B
,      PRIM_RECOGNIZED_AMT_G
,      PRIM_DEFERRED_AMT_G
,      SEC_RECOGNIZED_AMT_G
,      SEC_DEFERRED_AMT_G
,      BOOKED_REV_PRIM_YR
,      BOOKED_REV_PRIM_QR
,      BOOKED_REV_PRIM_PE
,      BOOKED_REV_PRIM_WK
,      BOOKED_REV_SEC_YR
,      BOOKED_REV_SEC_QR
,      BOOKED_REV_SEC_PE
,      BOOKED_REV_SEC_WK
,      BOOKED_REV_PRIM_YRCT
,      BOOKED_REV_PRIM_QRCT
,      BOOKED_REV_PRIM_PECT
,      BOOKED_REV_PRIM_WKCT
,      BOOKED_REV_SEC_YRCT
,      BOOKED_REV_SEC_QRCT
,      BOOKED_REV_SEC_PECT
,      BOOKED_REV_SEC_WKCT
,      AMOUNT_BCT
,      PRIM_RECOGNIZED_AMT_GCT
,      PRIM_DEFERRED_AMT_GCT
,      SEC_RECOGNIZED_AMT_GCT
,      SEC_DEFERRED_AMT_GCT
,      CT
FROM APPS.ISC_DBI_SCR_000_MV;

Dependencies

[top of page]

APPS.ISC_DBI_SCR_000_MV references the following:

SchemaAPPS
TableISC_DBI_SCR_000_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaFII
TableFII_AR_REVENUE_B
TableFII_AR_SALES_CREDITS
TableFII_GLOBAL_START_DATES
TableFII_PARTY_MKT_CLASS
TableFII_TIME_DAY
SchemaISC
TableISC_BOOK_SUM2_F
TableISC_SALES_CREDITS_F
SchemaJTF
TableJTF_RS_SRP_GROUPS
APPS.ISC_DBI_SCR_000_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_SCR_001_MV