[Home] [Help] [Dependency Information]
Object Name: | OKI_FORECAST_BY_ORGS |
---|---|
Object Type: | TABLE |
Owner: | OKI |
FND Design Data: | OKI.OKI_FORECAST_BY_ORGS |
Subobject Name: | |
Status: | VALID |
This table holds the forecast and booked contract amounts for an organization for any given period.
It is maintained by the Load Forecast By Organizations, Contracts Intelligence concurrent manager job.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKI_FORECAST_BY_ORGS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_NAME
PERIOD_SET_NAME AUTHORING_ORG_ID SCS_CODE |
OKI_FORECAST_BY_ORGS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | The internal identifier for the row. | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | The name from General Ledger for the period of this information. |
PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | The name of the General Ledger period set used to determine valid periods. |
PERIOD_TYPE | VARCHAR2 | (15) | The type of General Ledger period used for this information. | |
AUTHORING_ORG_ID | NUMBER | Yes | The internal identifier of the operating unit in which the contract was authored. | |
AUTHORING_ORG_NAME | VARCHAR2 | (240) | The name of the operating unit in which the contract was authored. | |
SCS_CODE | VARCHAR2 | (30) | The category (sub-class) code for the contract. | |
BASE_FORECAST_AMOUNT | NUMBER | The forecasted amount, in the base currency. | ||
BASE_BOOKED_AMOUNT | NUMBER | The sum of booked renewals, in the base currency. | ||
REQUEST_ID | NUMBER | (15) | Concurrent Manager audit column. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager audit column. | |
PROGRAM_ID | NUMBER | (15) | Concurrent Manager audit column. | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Manager audit column. | ||
SECURITY_GROUP_ID | NUMBER | Used for application hosting. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, PERIOD_NAME
, PERIOD_SET_NAME
, PERIOD_TYPE
, AUTHORING_ORG_ID
, AUTHORING_ORG_NAME
, SCS_CODE
, BASE_FORECAST_AMOUNT
, BASE_BOOKED_AMOUNT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID
FROM OKI.OKI_FORECAST_BY_ORGS;
OKI.OKI_FORECAST_BY_ORGS does not reference any database object
OKI.OKI_FORECAST_BY_ORGS is referenced by following:
|
|
|