Product: | OKS - Service Contracts |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKS_INST_HIST_DETAILS_V |
SELECT IHD.ROWID ROW_ID
, IHD.ID ID
, IHD.INS_ID INS_ID
, IHD.TRANSACTION_DATE TRANSACTION_DATE
, IHD.TRANSACTION_TYPE TRANSACTION_TYPE
, IHD.SYSTEM_ID SYSTEM_ID
, IHD.INSTANCE_ID_NEW INSTANCE_ID_NEW
, IHD.INSTANCE_QTY_OLD INSTANCE_QTY_OLD
, IHD.INSTANCE_QTY_NEW INSTANCE_QTY_NEW
, IHD.INSTANCE_AMT_OLD INSTANCE_AMT_OLD
, IHD.INSTANCE_AMT_NEW INSTANCE_AMT_NEW
, IHD.OLD_CONTRACT_ID OLD_CONTRACT_ID
, IHD.OLD_CONTACT_START_DATE OLD_CONTACT_START_DATE
, IHD.OLD_CONTRACT_END_DATE OLD_CONTRACT_END_DATE
, IHD.NEW_CONTRACT_ID NEW_CONTRACT_ID
, IHD.NEW_CONTACT_START_DATE NEW_CONTACT_START_DATE
, IHD.NEW_CONTRACT_END_DATE NEW_CONTRACT_END_DATE
, IHD.OLD_SERVICE_LINE_ID OLD_SERVICE_LINE_ID
, IHD.OLD_SERVICE_START_DATE OLD_SERVICE_START_DATE
, IHD.OLD_SERVICE_END_DATE OLD_SERVICE_END_DATE
, IHD.NEW_SERVICE_LINE_ID NEW_SERVICE_LINE_ID
, IHD.NEW_SERVICE_START_DATE NEW_SERVICE_START_DATE
, IHD.NEW_SERVICE_END_DATE NEW_SERVICE_END_DATE
, IHD.OLD_SUBLINE_ID OLD_SUBLINE_ID
, IHD.OLD_SUBLINE_START_DATE OLD_SUBLINE_START_DATE
, IHD.OLD_SUBLINE_END_DATE OLD_SUBLINE_END_DATE
, IHD.NEW_SUBLINE_ID NEW_SUBLINE_ID
, IHD.NEW_SUBLINE_START_DATE NEW_SUBLINE_START_DATE
, IHD.NEW_SUBLINE_END_DATE NEW_SUBLINE_END_DATE
, IHD.OLD_CUSTOMER OLD_CUSTOMER
, IHD.NEW_CUSTOMER NEW_CUSTOMER
, IHD.OLD_K_STATUS OLD_K_STATUS
, IHD.NEW_K_STATUS NEW_K_STATUS
, IHD.SUBLINE_DATE_TERMINATED SUBLINE_DATE_TERMINATED
, IHD.TRANSFER_OPTION TRANSFER_OPTION
, IHD.CREATED_BY CREATED_BY
, IHD.CREATION_DATE CREATION_DATE
, IHD.LAST_UPDATED_BY LAST_UPDATED_BY
, IHD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IHD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IHD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IHD.SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM OKS_INST_HIST_DETAILS IHD