[Home] [Help]
View: OKI_FORECAST_BY_ORGS_V
Product: | OKI - Contracts Intelligence (Obsolete) |
Description: | Summarized forecast and booked contract information by operating unit and period. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT FBO.ID
, FBO.PERIOD_NAME
, FBO.PERIOD_SET_NAME
, FBO.PERIOD_TYPE
, FBO.AUTHORING_ORG_ID
, FBO.AUTHORING_ORG_NAME
, FBO.SCS_CODE
, FBO.BASE_FORECAST_AMOUNT
, FBO.BASE_BOOKED_AMOUNT
, FBO.REQUEST_ID
, FBO.PROGRAM_APPLICATION_ID
, FBO.PROGRAM_ID
, FBO.PROGRAM_UPDATE_DATE
FROM OKI_FORECAST_BY_ORGS FBO
Columns
Name |
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 |