[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 |