PROMPT Creating view 'INTERFACE_STATE'
CREATE OR REPLACE FORCE VIEW INTERFACE_STATE
 (ROW_CREATE_TIME
 ,ROW_DATE_TIME
 ,CUSER
 ,MUSER
 ,MTERM
 ,SOURCE
 ,TO_BE_ARCHIVED
 ,APPN_ROW_ID
 ,SYSTEM_ID
 ,SYSTEM_NAME
 ,STATUS
 ,LAST_ACTIVE_TIME
 ,DESCRIPTION
 ,CHECK_DB_SESSION_NAME
) AS
SELECT ROW_CREATE_TIME, ROW_DATE_TIME, CUSER, MUSER, MTERM, SOURCE, TO_BE_ARCHIVED, APPN_ROW_ID, ID, NAME, STATUS, LAST_MESSAGE_OUT, DESCRIPTION, NULL
FROM SYS_INTERFACE;
