[Home] [Help]
View: OKI_RENEWAL_AGING_V
Product: | OKI - Contracts Intelligence (Obsolete) |
Description: | Holds the values for the aging of renewals by time period. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ORA.ID
, ORA.PERIOD_NAME
, ORA.PERIOD_SET_NAME
, ORA.PERIOD_TYPE
, ORA.AUTHORING_ORG_ID
, ORA.AUTHORING_ORG_NAME
, ORA.CUSTOMER_PARTY_ID
, ORA.CUSTOMER_NAME
, ORA.SCS_CODE
, ORA.AGE_GROUP1
, ORA.AGE_GROUP2
, ORA.AGE_GROUP3
, ORA.AGE_GROUP4
, ORA.REQUEST_ID
, ORA.PROGRAM_APPLICATION_ID
, ORA.PROGRAM_ID
, ORA.PROGRAM_UPDATE_DATE
FROM OKI_RENEWAL_AGING ORA
Columns
Name |
ID |
PERIOD_NAME |
PERIOD_SET_NAME |
PERIOD_TYPE |
AUTHORING_ORG_ID |
AUTHORING_ORG_NAME |
CUSTOMER_PARTY_ID |
CUSTOMER_NAME |
SCS_CODE |
AGE_GROUP1 |
AGE_GROUP2 |
AGE_GROUP3 |
AGE_GROUP4 |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |