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

MATERIALIZED VIEW: APPS.ISC_SAM_006_MV

Object Details
Object Name: ISC_SAM_006_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_SAM_006_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_PARTY_MKT_CLASS
FII_TIME_DAY
ISC_BOOK_SUM2_F
ISC_SALES_CREDITS_F
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

MV Union Identifier
GRP_MARKER VARCHAR2 (9)
Flag to Identify resource, group or top_group
CUSTOMER_ID NUMBER

Customer Identifier
CLASS_CODE VARCHAR2 (30)
Customer Classification Identifier
RESOURCE_ID NUMBER

JTF Resource Identifier
SALES_GRP_ID NUMBER

JTF Sales Group Identifier
PARENT_GRP_ID NUMBER

JTF Parent Group Identifier
AGG_LEVEL NUMBER

MV Aggregation Level Flag
GRP_ID NUMBER

Grouping ID Column
ENT_YEAR_ID NUMBER

Enterprise Year Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
WEEK_ID NUMBER

Week Identifier
REPORT_DATE_JULIAN NUMBER

Julian Date Identifier
TIME_ID NUMBER

Nested Grouping ID Column for Time
FULFILL_AMT_G NUMBER

Non-Agreement Orders Fulfilled Amount in primary global currency
FULFILL_AMT_G1 NUMBER

Non-Agreement Orders Fulfilled Amount in secondary global currency
C_FULFILL_AMT_G NUMBER

Count Column
C_FULFILL_AMT_G1 NUMBER

Count Column
C_TOTAL NUMBER

Count Column
Query Text

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


SELECT UMARKER
,      GRP_MARKER
,      CUSTOMER_ID
,      CLASS_CODE
,      RESOURCE_ID
,      SALES_GRP_ID
,      PARENT_GRP_ID
,      AGG_LEVEL
,      GRP_ID
,      ENT_YEAR_ID
,      ENT_QTR_ID
,      ENT_PERIOD_ID
,      WEEK_ID
,      REPORT_DATE_JULIAN
,      TIME_ID
,      FULFILL_AMT_G
,      FULFILL_AMT_G1
,      C_FULFILL_AMT_G
,      C_FULFILL_AMT_G1
,      C_TOTAL
FROM APPS.ISC_SAM_006_MV;

Dependencies

[top of page]

APPS.ISC_SAM_006_MV references the following:

SchemaAPPS
TableISC_SAM_006_MV
Materialized ViewOKI_RS_GROUP_MV
TableOKI_RS_GROUP_MV
SchemaFII
TableFII_PARTY_MKT_CLASS
TableFII_TIME_DAY
SchemaISC
TableISC_BOOK_SUM2_F
TableISC_SALES_CREDITS_F

APPS.ISC_SAM_006_MV is not referenced by any database object