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


VIEW: APPS.MSD_SR_SALES_FCST_V

Object Details
Object Name: MSD_SR_SALES_FCST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_SR_SALES_FCST_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This is the Source View for Sales Forecast. This view would be applied to an Oracle Applications 11i instance from which the Sales Forecast information is to be retrieved.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INTEREST_TYPE_LEVEL_ID NUMBER

Interest Type Level Id
SR_INTEREST_TYPE_ID NUMBER

Source Interest Type Id
GEO_LEVEL_ID NUMBER

Geography Level Id
SR_GEO_LEVEL_PK NUMBER

Sr Geography Level Pk
ORG_LEVEL_ID NUMBER

Organization Level Id
SR_ORG_LEVEL_PK NUMBER

Source Organization Level Pk
CHN_LEVEL_ID NUMBER

Channel Level Id
SR_CHN_LEVEL_PK NUMBER

Source Channel Level Pk
REP_LEVEL_ID NUMBER

Salesrep Level Id
SR_REP_LEVEL_PK NUMBER

Source Salesrep Level Pk
BEST_FORECAST_AMOUNT NUMBER

Best Forecast Amount
FORECAST_AMOUNT NUMBER

Forecast Amount
WORST_FORECAST_AMOUNT NUMBER

Worst Forecast Amount
PIPELINE_AMOUNT NUMBER

Pipeline Amount
WEIGHTED_PIPELINE_AMOUNT NUMBER

weighted Pipeline Amount
FORECAST_START_DATE DATE

Forecast Start Date
FORECAST_END_DATE DATE

Forecast End Date
FORECAST_CATEGORY VARCHAR2 (80)
Forecast Category
TIME_LEVEL_ID NUMBER

Time Level Id
WORKSHEET_CODE NUMBER

Worksheet Flag
GROUP_LEVEL NUMBER

Group Level
Query Text

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


SELECT INTEREST_TYPE_LEVEL_ID
,      SR_INTEREST_TYPE_ID
,      GEO_LEVEL_ID
,      SR_GEO_LEVEL_PK
,      ORG_LEVEL_ID
,      SR_ORG_LEVEL_PK
,      CHN_LEVEL_ID
,      SR_CHN_LEVEL_PK
,      REP_LEVEL_ID
,      SR_REP_LEVEL_PK
,      BEST_FORECAST_AMOUNT
,      FORECAST_AMOUNT
,      WORST_FORECAST_AMOUNT
,      PIPELINE_AMOUNT
,      WEIGHTED_PIPELINE_AMOUNT
,      FORECAST_START_DATE
,      FORECAST_END_DATE
,      FORECAST_CATEGORY
,      TIME_LEVEL_ID
,      WORKSHEET_CODE
,      GROUP_LEVEL
FROM APPS.MSD_SR_SALES_FCST_V;

Dependencies

[top of page]

APPS.MSD_SR_SALES_FCST_V references the following:

SchemaAPPS
SynonymAS_FORECAST_CATEGORIES
SynonymAS_INTERNAL_FORECASTS
SynonymAS_OPP_WORKSHEET_LINES
SynonymAS_PROD_WORKSHEET_LINES
SynonymENI_DENORM_HIERARCHIES
SynonymGL_PERIODS
SynonymJTF_RS_GROUPS_B
SynonymJTF_RS_GRP_RELATIONS
SynonymMSD_SETUP_PARAMETERS
PL/SQL PackageMSD_SR_UTIL - show dependent code
SynonymMTL_DEFAULT_CATEGORY_SETS

APPS.MSD_SR_SALES_FCST_V is not referenced by any database object