[Home] [Help] [Dependency Information]
Object Name: | AS_FORECAST_CATEGORIES_TL |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_FORECAST_CATEGORIES_TL |
Subobject Name: | |
Status: | VALID |
Forecast categories will determine the selection of interest types available for forecast. Any opportunity which has interest types mapped to the forecast category can only be used for forecasting purpose.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AS_FORECAST_CATEGORIES_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
FORECAST_CATEGORY_ID ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_CATEGORY_ID | NUMBER | Yes | Forecast Category Identifier | |
CREATED_BY | NUMBER | Yes | Standard Who Column | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LANGUAGE | VARCHAR2 | (4) | Defined language for the row's translated columns | |
SOURCE_LANG | VARCHAR2 | (4) | Language used at the time of insertion | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
FORECAST_CATEGORY_NAME | VARCHAR2 | (80) | Forecast Category Name | |
SECURITY_GROUP_ID | NUMBER | Subscriber id, for CRM Online Services use | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_CATEGORY_ID
, CREATED_BY
, CREATION_DATE
, LANGUAGE
, SOURCE_LANG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, FORECAST_CATEGORY_NAME
, SECURITY_GROUP_ID
, ZD_EDITION_NAME
FROM OSM.AS_FORECAST_CATEGORIES_TL;
OSM.AS_FORECAST_CATEGORIES_TL does not reference any database object
OSM.AS_FORECAST_CATEGORIES_TL is referenced by following:
|
|
|