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


VIEW: APPS.AS_FRCST_MGR_OPP_LINES_V

Object Details
Object Name: AS_FRCST_MGR_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)
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
DIRECT_REPORT VARCHAR2 (360)
Direct Report
FORECAST_CREDIT_OWNER VARCHAR2 (360)
Owner of the opportunity line
FORECAST_CREDIT_GROUP_NAME VARCHAR2 (60) Yes Forecast Credit Group Name
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

Forecast Category Identifier
CREDIT_TYPE_ID NUMBER

Credit Type identifier of the sales credit
TO_CURRENCY VARCHAR2 (15)
Target currency code in currency conversion
PERIOD_NAME VARCHAR2 (15)
Currency conversion period name
PERIOD_SET_NAME VARCHAR2 (15)
Calendar
SALES_GROUP_ID NUMBER

Sales Group 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
,      DIRECT_REPORT
,      FORECAST_CREDIT_OWNER
,      FORECAST_CREDIT_GROUP_NAME
,      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
FROM APPS.AS_FRCST_MGR_OPP_LINES_V;

Dependencies

[top of page]

APPS.AS_FRCST_MGR_OPP_LINES_V references the following:

SchemaAPPS
SynonymAS_FST_SALES_CATEGORIES
SynonymAS_PERIOD_RATES
SynonymAS_SALES_CREDITS_DENORM
SynonymAS_SALES_STAGES_ALL_TL
SynonymAS_STATUSES_TL
ViewENI_PROD_DENORM_HRCHY_V
SynonymJTF_RS_GROUPS_DENORM
SynonymJTF_RS_GROUPS_TL
SynonymJTF_RS_GROUP_MEMBERS
SynonymJTF_RS_RESOURCE_EXTNS
SynonymJTF_RS_ROLES_B
SynonymJTF_RS_ROLE_RELATIONS
SynonymMTL_CATEGORIES_TL
SynonymMTL_SYSTEM_ITEMS_TL

APPS.AS_FRCST_MGR_OPP_LINES_V is not referenced by any database object