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

MATERIALIZED VIEW: APPS.ISC_SAM_001_MV

Object Details
Object Name: ISC_SAM_001_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_SAM_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_PARTY_MKT_CLASS
FII_TIME_DAY
ISC_DBI_BSA_ORDER_LINES_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
AGREEMENT_TYPE_ID NUMBER

Agreement Type Identifier
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
COMMIT_AMT_G NUMBER

Amounts For New Agreements, Total Active Agreements in primary global currency
COMMIT_AMT_G1 NUMBER

Amounts For New Agreements, Total Active Agreements in secondary global currency
COMMIT_EWK_AMT_G NUMBER

Amounts For Expiring Agreements in primary global currency
COMMIT_EWK_AMT_G1 NUMBER

Amounts For Expiring Agreements in secondary global currency
COMMIT_EPD_AMT_G NUMBER

Amounts For Expiring Agreements in primary global currency
COMMIT_EPD_AMT_G1 NUMBER

Amounts For Expiring Agreements in secondary global currency
COMMIT_EQR_AMT_G NUMBER

Amounts For Expiring Agreements in primary global currency
COMMIT_EQR_AMT_G1 NUMBER

Amounts For Expiring Agreements in secondary global currency
COMMIT_EYR_AMT_G NUMBER

Amounts For Expiring Agreements in primary global currency
COMMIT_EYR_AMT_G1 NUMBER

Amounts For Expiring Agreements in secondary global currency
NEW_AGR_CNT NUMBER

New Agreement Count
C_COMMIT_AMT_G NUMBER

Count Column
C_COMMIT_AMT_G1 NUMBER

Count Column
C_COMMIT_EWK_AMT_G NUMBER

Count Column
C_COMMIT_EWK_AMT_G1 NUMBER

Count Column
C_COMMIT_EPD_AMT_G NUMBER

Count Column
C_COMMIT_EPD_AMT_G1 NUMBER

Count Column
C_COMMIT_EQR_AMT_G NUMBER

Count Column
C_COMMIT_EQR_AMT_G1 NUMBER

Count Column
C_COMMIT_EYR_AMT_G NUMBER

Count Column
C_COMMIT_EYR_AMT_G1 NUMBER

Count Column
C_NEW_AGR_CNT 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
,      AGREEMENT_TYPE_ID
,      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
,      COMMIT_AMT_G
,      COMMIT_AMT_G1
,      COMMIT_EWK_AMT_G
,      COMMIT_EWK_AMT_G1
,      COMMIT_EPD_AMT_G
,      COMMIT_EPD_AMT_G1
,      COMMIT_EQR_AMT_G
,      COMMIT_EQR_AMT_G1
,      COMMIT_EYR_AMT_G
,      COMMIT_EYR_AMT_G1
,      NEW_AGR_CNT
,      C_COMMIT_AMT_G
,      C_COMMIT_AMT_G1
,      C_COMMIT_EWK_AMT_G
,      C_COMMIT_EWK_AMT_G1
,      C_COMMIT_EPD_AMT_G
,      C_COMMIT_EPD_AMT_G1
,      C_COMMIT_EQR_AMT_G
,      C_COMMIT_EQR_AMT_G1
,      C_COMMIT_EYR_AMT_G
,      C_COMMIT_EYR_AMT_G1
,      C_NEW_AGR_CNT
,      C_TOTAL
FROM APPS.ISC_SAM_001_MV;

Dependencies

[top of page]

APPS.ISC_SAM_001_MV references the following:

SchemaAPPS
TableISC_SAM_001_MV
TableOKI_RS_GROUP_MV
Materialized ViewOKI_RS_GROUP_MV
SchemaFII
TableFII_PARTY_MKT_CLASS
TableFII_TIME_DAY
SchemaISC
TableISC_DBI_BSA_ORDER_LINES_F

APPS.ISC_SAM_001_MV is not referenced by any database object