[Home] [Help]
View: OKI_RENEW_BY_STATUSES_V
Product: | OKI - Contracts Intelligence (Obsolete) |
Description: | Holds information about renewal contracts by contract status. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RBS.ID
, RBS.PERIOD_NAME
, RBS.PERIOD_SET_NAME
, RBS.PERIOD_TYPE
, RBS.AUTHORING_ORG_ID
, RBS.AUTHORING_ORG_NAME
, RBS.STATUS_CODE
, RBS.SCS_CODE
, RBS.BASE_AMOUNT
, RBS.CONTRACT_COUNT
, RBS.REQUEST_ID
, RBS.PROGRAM_APPLICATION_ID
, RBS.PROGRAM_ID
, RBS.PROGRAM_UPDATE_DATE
FROM OKI_RENEW_BY_STATUSES RBS
Columns
Name |
ID |
PERIOD_NAME |
PERIOD_SET_NAME |
PERIOD_TYPE |
AUTHORING_ORG_ID |
AUTHORING_ORG_NAME |
STATUS_CODE |
SCS_CODE |
BASE_AMOUNT |
CONTRACT_COUNT |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |