[Home] [Help]
View: OKS_INST_HIST_V
View Text
SELECT DISTINCT INS_ID
, TRANSACTION_DATE
, TRANSACTION_TYPE
, SYSTEM_ID
, INSTANCE_QTY_OLD
, INSTANCE_AMT_OLD
, OLD_CONTRACT_ID
, OLD_CONTACT_START_DATE
, OLD_CONTRACT_END_DATE
, OLD_SERVICE_LINE_ID
, OLD_SERVICE_START_DATE
, OLD_SERVICE_END_DATE
, OLD_SUBLINE_ID
, OLD_SUBLINE_START_DATE
, OLD_SUBLINE_END_DATE
, SUBLINE_DATE_TERMINATED
, OLD_CUSTOMER
, OLD_K_STATUS
, TRANSFER_OPTION
FROM OKS_INST_HIST_DETAILS
Columns
| Name |
| INS_ID |
| TRANSACTION_DATE |
| TRANSACTION_TYPE |
| SYSTEM_ID |
| INSTANCE_QTY_OLD |
| INSTANCE_AMT_OLD |
| OLD_CONTRACT_ID |
| OLD_CONTRACT_START_DATE |
| OLD_CONTRACT_END_DATE |
| OLD_SERVICE_LINE_ID |
| OLD_SERVICE_START_DATE |
| OLD_SERVICE_END_DATE |
| OLD_SUBLINE_ID |
| OLD_SUBLINE_START_DATE |
| OLD_SUBLINE_END_DATE |
| SUBLINE_DATE_TERMINATED |
| OLD_CUSTOMER |
| OLD_K_STATUS |
| TRANSFER_OPTION |