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

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OPP_DESCRIPTION	VARCHAR2	(240)		A description of the opportunity
OPP_NUMBER	VARCHAR2	(30)	Yes	Opportunity Number
PRODUCT_NAME	VARCHAR2	(240)		Product Name
PRODUCT_CATEGORY_NAME	VARCHAR2	(240)		Product Category Name
CUSTOMER_NAME	VARCHAR2	(360)		Customer Name
STATUS	VARCHAR2	(240)		Status of the Opportunity
SALES_STAGE	VARCHAR2	(60)		Sales Stage Name
WIN_PROBABILITY	NUMBER			Win Probability
FORECAST_DATE	DATE			The date that id to be used for forecasting
OPP_WORST_FORECAST_AMOUNT	NUMBER			Worst Forecast Amount for Opportunity
OPP_FORECAST_AMOUNT	NUMBER			Forecast Amount for Opportunity
OPP_BEST_FORECAST_AMOUNT	NUMBER			Best Forecast Amount for Opportunity
PIPELINE_AMOUNT	NUMBER			Sales Credit Amount
WEIGHTED_AMOUNT	NUMBER			Weighted Amount
WON_AMOUNT	NUMBER			Won Amount
FORECAST_CATEGORY_ID	NUMBER		Yes	Forecast Category Identifier
CREDIT_TYPE_ID	NUMBER			Credit Type identifier of the sales credit
TO_CURRENCY	VARCHAR2	(15)	Yes	Target currency code in currency conversion
PERIOD_NAME	VARCHAR2	(15)	Yes	Currency conversion period name
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	Calendar
SALES_GROUP_ID	NUMBER			Sales Group Identifier
SALESFORCE_ID	NUMBER		Yes	Salesforce Identifier

Query Text

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


SELECT OPP_DESCRIPTION
,      OPP_NUMBER
,      PRODUCT_NAME
,      PRODUCT_CATEGORY_NAME
,      CUSTOMER_NAME
,      STATUS
,      SALES_STAGE
,      WIN_PROBABILITY
,      FORECAST_DATE
,      OPP_WORST_FORECAST_AMOUNT
,      OPP_FORECAST_AMOUNT
,      OPP_BEST_FORECAST_AMOUNT
,      PIPELINE_AMOUNT
,      WEIGHTED_AMOUNT
,      WON_AMOUNT
,      FORECAST_CATEGORY_ID
,      CREDIT_TYPE_ID
,      TO_CURRENCY
,      PERIOD_NAME
,      PERIOD_SET_NAME
,      SALES_GROUP_ID
,      SALESFORCE_ID
FROM APPS.AS_FRCST_REP_OPP_LINES_V;

Dependencies

[top of page]

APPS.AS_FRCST_REP_OPP_LINES_V references the following:

APPS: AS_FST_SALES_CATEGORIES; AS_PERIOD_RATES; AS_SALES_CREDITS_DENORM; AS_SALES_STAGES_ALL_TL; AS_STATUSES_TL; ENI_PROD_DENORM_HRCHY_V; MTL_CATEGORIES_TL; MTL_SYSTEM_ITEMS_TL

APPS.AS_FRCST_REP_OPP_LINES_V is not referenced by any database object