[Home] [Help] [Dependency Information]
Object Name: | AS_FRCST_REP_OPP_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.AS_FRCST_REP_OPP_LINES_V is not referenced by any database object
|
|
|