eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

MATERIALIZED VIEW: APPS.ISC_SAM_003_MV

Object Details

Object Name:	ISC_SAM_003_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	ISC_SAM_003_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
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
OKI_TIME_ENT_YEAR_MV
     FII_TIME_DAY

[View Source Query]

Columns

Name	Datatype	Length	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
COMMIT_AMT_G	NUMBER		Amounts For Total Active Agreements in primary global currency
COMMIT_AMT_G1	NUMBER		Amounts For Total Active Agreements in secondary global currency
C_COMMIT_AMT_G	NUMBER		Count Column
C_COMMIT_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
,      AGREEMENT_TYPE_ID
,      CUSTOMER_ID
,      CLASS_CODE
,      RESOURCE_ID
,      SALES_GRP_ID
,      PARENT_GRP_ID
,      AGG_LEVEL
,      GRP_ID
,      ENT_YEAR_ID
,      COMMIT_AMT_G
,      COMMIT_AMT_G1
,      C_COMMIT_AMT_G
,      C_COMMIT_AMT_G1
,      C_TOTAL
FROM APPS.ISC_SAM_003_MV;

Dependencies

[top of page]

APPS.ISC_SAM_003_MV references the following:

APPS: ISC_SAM_003_MV; OKI_RS_GROUP_MV; OKI_RS_GROUP_MV; OKI_TIME_ENT_YEAR_MV; OKI_TIME_ENT_YEAR_MV
FII: FII_PARTY_MKT_CLASS
ISC: ISC_DBI_BSA_ORDER_LINES_F

APPS.ISC_SAM_003_MV is not referenced by any database object