SMO_INTEGRATIONS_VL

Details

• Schema: FUSION

• Object owner: SMO

• Object type: VIEW

Columns

Name
INTEGRATION_ID OBJECT_VERSION_NUMBER INTEGRATION_NAME INTEGRATION_DESCRIPTION INTEGRATION_CODE INTEGRATION_TYPE HOST PORT AUTHENTICATION_TYPE AUTH_REFERENCE_KEY CONTEXT_PATH ENABLED_FLAG DEFAULT_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT SIB.INTEGRATION_ID INTEGRATION_ID, SIB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SITL.INTEGRATION_NAME INTEGRATION_NAME, SITL.INTEGRATION_DESCRIPTION INTEGRATION_DESCRIPTION, SIB.INTEGRATION_CODE INTEGRATION_CODE, SIB.INTEGRATION_TYPE INTEGRATION_TYPE, SIB.HOST HOST, SIB.PORT PORT, SIB.AUTHENTICATION_TYPE AUTHENTICATION_TYPE, SIB.AUTH_REFERENCE_KEY AUTH_REFERENCE_KEY, SIB.CONTEXT_PATH CONTEXT_PATH, SIB.ENABLED_FLAG ENABLED_FLAG, SIB.DEFAULT_FLAG DEFAULT_FLAG, SIB.CREATED_BY CREATED_BY, SIB.CREATION_DATE CREATION_DATE, SIB.LAST_UPDATED_BY LAST_UPDATED_BY, SIB.LAST_UPDATE_DATE LAST_UPDATE_DATE, SIB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM SMO_INTEGRATIONS_B SIB, SMO_INTEGRATIONS_TL SITL WHERE SIB.INTEGRATION_ID = SITL.INTEGRATION_ID AND SITL.LANGUAGE = USERENV('LANG')