VIEW: APPS.OKS_INST_HIST_DETAILS_V

Source

View Text - Preformatted

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, IHD.DATE_CANCELLED DATE_CANCELLED FROM OKS_INST_HIST_DETAILS IHD

View Text - HTML Formatted

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
, IHD.DATE_CANCELLED DATE_CANCELLED
FROM OKS_INST_HIST_DETAILS IHD