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.BIL_OBI_FST_PG_V

Object Details

Object Name:	BIL_OBI_FST_PG_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

Summarized view on periods for sales forecast

[View Source]

Columns

Name	Datatype	Length	Comments
EFFECTIVE_TIME_ID	NUMBER		Time Id for sales forecast submission
PARENT_SALES_GROUP_ID	NUMBER		Parent sales group id
SALES_GROUP_ID	NUMBER		Sales Group Id for submitted forecast
SALESREP_ID	NUMBER		Sales Rep id for the submitted forecast
PRODUCT_CATEGORY_ID	NUMBER		Product category id for the submitted forecast
ROLLUP_FLAG	VARCHAR2	(1)	Flag for rolled up and non-rolled up data
FORECAST_AMT	NUMBER		Submitted forecast amount in primary currency
FORECAST_AMT_S	NUMBER		Submitted forecast amount in secondary currency
FORECAST_AMT_SUB	NUMBER		Submitted forecast amount for subordinate in primary currency
FORECAST_AMT_SUB_S	NUMBER		Submitted forecast amount for subordinate in secondary currency
OPP_FORECAST_AMT	NUMBER		Opportunity forecast amount in primary currency
OPP_FORECAST_AMT_S	NUMBER		Opportunity Forecast amount in secondary currency
OPP_FORECAST_AMT_SUB	NUMBER		Opportunity forecast amount for subordinate in primary currency
OPP_FORECAST_AMT_SUB_S	NUMBER		Opportunity forecast amount for subordinate in secondary currency

Query Text

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


SELECT EFFECTIVE_TIME_ID
,      PARENT_SALES_GROUP_ID
,      SALES_GROUP_ID
,      SALESREP_ID
,      PRODUCT_CATEGORY_ID
,      ROLLUP_FLAG
,      FORECAST_AMT
,      FORECAST_AMT_S
,      FORECAST_AMT_SUB
,      FORECAST_AMT_SUB_S
,      OPP_FORECAST_AMT
,      OPP_FORECAST_AMT_S
,      OPP_FORECAST_AMT_SUB
,      OPP_FORECAST_AMT_SUB_S
FROM APPS.BIL_OBI_FST_PG_V;

Dependencies

[top of page]

APPS.BIL_OBI_FST_PG_V references the following:

APPS: BIL_OBI_FST_PG_MV; FII_TIME_ENT_PERIOD; FII_TIME_ENT_QTR; FII_TIME_ENT_YEAR; FII_TIME_STRUCTURES; FND_PROFILE - show dependent code

APPS.BIL_OBI_FST_PG_V is not referenced by any database object