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

TABLE: APPS.ISC_DBI_SCR_000_MV

Object Details
Object Name: ISC_DBI_SCR_000_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.ISC_DBI_SCR_000_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_000_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("INVENTORY_ITEM_ID")
ColumnSYS_OP_MAP_NONNULL("TIME_ID")
ColumnSYS_OP_MAP_NONNULL("SALES_GRP_ID")
ColumnSYS_OP_MAP_NONNULL("RESOURCE_ID")
ColumnSYS_OP_MAP_NONNULL("MASTER_ORAGNIZATION_ID")
ColumnSYS_OP_MAP_NONNULL("CUSTOMER_ID")
ColumnSYS_OP_MAP_NONNULL("CLASS_CODE")
ColumnSYS_OP_MAP_NONNULL("ITEM_CATEGORY_ID")
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 does not reference any database object

APPS.ISC_DBI_SCR_000_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_SCR_000_MV
Materialized ViewISC_DBI_SCR_001_MV