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]

VIEW: APPS.MSD_SR_SALES_FCST_V

Object Details

Object Name:	MSD_SR_SALES_FCST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSD.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	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:

APPS: AS_FORECAST_CATEGORIES; AS_INTERNAL_FORECASTS; AS_OPP_WORKSHEET_LINES; AS_PROD_WORKSHEET_LINES; ENI_DENORM_HIERARCHIES; GL_PERIODS; JTF_RS_GROUPS_B; JTF_RS_GRP_RELATIONS; MSD_SETUP_PARAMETERS; MSD_SR_UTIL - show dependent code; MTL_DEFAULT_CATEGORY_SETS

APPS.MSD_SR_SALES_FCST_V is not referenced by any database object