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:

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
SynonymMTL_CATEGORIES_TL
SynonymMTL_SYSTEM_ITEMS_TL

APPS.AS_FRCST_REP_OPP_LINES_V is not referenced by any database object