[Home] [Help]
View: OKI_WIP_BY_CUSTOMERS_V
Product: | OKI - Contracts Intelligence (Obsolete) |
Description: | Holds information about renewals by customer for a given period. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT WBC.ID
, WBC.PERIOD_NAME
, WBC.PERIOD_SET_NAME
, WBC.PERIOD_TYPE
, WBC.AUTHORING_ORG_ID
, WBC.AUTHORING_ORG_NAME
, WBC.CUSTOMER_PARTY_ID
, WBC.CUSTOMER_NAME
, WBC.SCS_CODE
, WBC.BASE_FORECAST_AMOUNT
, WBC.BASE_BOOKED_AMOUNT
, WBC.BASE_LOST_AMOUNT
, WBC.REQUEST_ID
, WBC.PROGRAM_APPLICATION_ID
, WBC.PROGRAM_ID
, WBC.PROGRAM_UPDATE_DATE
FROM OKI_WIP_BY_CUSTOMERS WBC
Columns
Name |
ID |
PERIOD_NAME |
PERIOD_SET_NAME |
PERIOD_TYPE |
AUTHORING_ORG_ID |
AUTHORING_ORG_NAME |
CUSTOMER_PARTY_ID |
CUSTOMER_NAME |
SCS_CODE |
BASE_FORECAST_AMOUNT |
BASE_BOOKED_AMOUNT |
BASE_LOST_AMOUNT |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |