[Home] [Help]
View: OKI_EXP_NOT_RENEWED_V
| Product: | OKI - Contracts Intelligence (Obsolete) |
|---|
| Description: | Summarized information about contract lines that have expired without being renewed. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT ENR.ID
, ENR.PERIOD_NAME
, ENR.PERIOD_SET_NAME
, ENR.PERIOD_TYPE
, ENR.AUTHORING_ORG_ID
, ENR.AUTHORING_ORG_NAME
, ENR.CUSTOMER_PARTY_ID
, ENR.CUSTOMER_NAME
, ENR.CONTACT_ID
, ENR.SALESREP_NAME
, ENR.SCS_CODE
, ENR.CONTRACT_COUNT
, ENR.BASE_LOST_AMOUNT
, ENR.REQUEST_ID
, ENR.PROGRAM_APPLICATION_ID
, ENR.PROGRAM_ID
, ENR.PROGRAM_UPDATE_DATE
FROM OKI_EXP_NOT_RENEWED ENR
Columns
| Name |
| ID |
| PERIOD_NAME |
| PERIOD_SET_NAME |
| PERIOD_TYPE |
| AUTHORING_ORG_ID |
| AUTHORING_ORG_NAME |
| CUSTOMER_PARTY_ID |
| CUSTOMER_NAME |
| CONTACT_ID |
| SALESREP_NAME |
| SCS_CODE |
| CONTRACT_COUNT |
| BASE_LOST_AMOUNT |
| REQUEST_ID |
| PROGRAM_APPLICATION_ID |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |