[Home] [Help] [Dependency Information]
Object Name: | OKS_STATUS_FORECAST |
---|---|
Object Type: | TABLE |
Owner: | OKS |
FND Design Data: | OKS.OKS_STATUS_FORECAST |
Subobject Name: | |
Status: | VALID |
OKS_STATUS_FORECAST stores information for service forecast
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOOKING_FORECAST | NUMBER | Booking Forecast | ||
RUN_FLAG | NUMBER | Run Flag | ||
RUN_TIME | DATE | Run Time | ||
CURRENCY | VARCHAR2 | (240) | Currency | |
STATUS_TYPE | VARCHAR2 | (30) | Status Type | |
STATUS_CODE | VARCHAR2 | (30) | Status Code | |
NUMBER_OF_CONTRACTS | NUMBER | Number of Contracts | ||
CONTRACT_VALUE | NUMBER | Contract Value | ||
REV_REC_VALUE | NUMBER | Rev Rec Value | ||
FORECAST_VALUE | NUMBER | Forecast Value | ||
SECURITY_GROUP_ID | NUMBER | Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete. | ||
CONC_REQUEST_ID | NUMBER | Conc Request Id |
Cut, paste (and edit) the following text to query this object:
SELECT BOOKING_FORECAST
, RUN_FLAG
, RUN_TIME
, CURRENCY
, STATUS_TYPE
, STATUS_CODE
, NUMBER_OF_CONTRACTS
, CONTRACT_VALUE
, REV_REC_VALUE
, FORECAST_VALUE
, SECURITY_GROUP_ID
, CONC_REQUEST_ID
FROM OKS.OKS_STATUS_FORECAST;
OKS.OKS_STATUS_FORECAST does not reference any database object
OKS.OKS_STATUS_FORECAST is referenced by following:
|
|
|