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

MATERIALIZED VIEW: APPS.AS_FORECAST_MV

Object Details
Object Name: AS_FORECAST_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: AS_FORECAST_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: DEFERRED
Fast Refreshable: NO
MV Log Dependencies:

FND_PROFILE_OPTIONS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
CNT NUMBER

PARENT_SALES_GROUP_ID NUMBER
Yes
CONVERSION_PERIOD_NAME VARCHAR2 (15) Yes
CREDIT_TYPE_ID NUMBER

CONVERSION_PERIOD_SET_NAME VARCHAR2 (15) Yes
FORECAST_CATEGORY_ID NUMBER
Yes
CONVERSION_STATUS_FLAG NUMBER

TOTAL_AMOUNT NUMBER

WEIGHTED_AMOUNT NUMBER

WON_AMOUNT NUMBER

Query Text

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


SELECT CNT
,      PARENT_SALES_GROUP_ID
,      CONVERSION_PERIOD_NAME
,      CREDIT_TYPE_ID
,      CONVERSION_PERIOD_SET_NAME
,      FORECAST_CATEGORY_ID
,      CONVERSION_STATUS_FLAG
,      TOTAL_AMOUNT
,      WEIGHTED_AMOUNT
,      WON_AMOUNT
FROM APPS.AS_FORECAST_MV;

Dependencies

[top of page]

APPS.AS_FORECAST_MV references the following:

SchemaAPPLSYS
TableFND_PROFILE_OPTIONS
TableFND_PROFILE_OPTION_VALUES
SchemaAPPS
TableAS_FORECAST_MV
SynonymAS_FST_SALES_CATEGORIES
SynonymAS_PERIOD_DAYS
SynonymAS_PERIOD_RATES
SynonymAS_SALES_CREDITS_DENORM
SynonymENI_DENORM_HIERARCHIES
ViewENI_PROD_DENORM_HRCHY_V
SynonymFND_PROFILE_OPTIONS
SynonymFND_PROFILE_OPTION_VALUES
SynonymJTF_RS_GROUPS_DENORM
SynonymMTL_DEFAULT_CATEGORY_SETS
SchemaENI
TableENI_DENORM_HIERARCHIES
SchemaINV
TableMTL_DEFAULT_CATEGORY_SETS
SchemaJTF
TableJTF_RS_GROUPS_DENORM
SchemaOSM
TableAS_FST_SALES_CATEGORIES
TableAS_PERIOD_DAYS
TableAS_PERIOD_RATES
TableAS_SALES_CREDITS_DENORM

APPS.AS_FORECAST_MV is not referenced by any database object