SMO_SYSTEM_BO_TYPES_VL

Details

• Schema: FUSION

• Object owner: SMO

• Object type: VIEW

Columns

Name
SYSTEM_BO_TYPE_ID OBJECT_VERSION_NUMBER SYSTEM_BO_TYPE_CODE PARENT_BO_TYPE_ID SYSTEM_BO_TYPE_NAME SYSTEM_BO_TYPE_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT SSBTB.SYSTEM_BO_TYPE_ID SYSTEM_BO_TYPE_ID, SSBTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SSBTB.SYSTEM_BO_TYPE_CODE SYSTEM_BO_TYPE_CODE, SSBTB.PARENT_BO_TYPE_ID PARENT_BO_TYPE_ID, SSBTTL.SYSTEM_BO_TYPE_NAME SYSTEM_BO_TYPE_NAME, SSBTTL.SYSTEM_BO_TYPE_DESCRIPTION SYSTEM_BO_TYPE_DESCRIPTION, SSBTB.CREATED_BY CREATED_BY, SSBTB.CREATION_DATE CREATION_DATE, SSBTB.LAST_UPDATED_BY LAST_UPDATED_BY, SSBTB.LAST_UPDATE_DATE LAST_UPDATE_DATE, SSBTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM SMO_SYSTEM_BO_TYPES_B SSBTB, SMO_SYSTEM_BO_TYPES_TL SSBTTL WHERE SSBTTL.SYSTEM_BO_TYPE_ID = SSBTB.SYSTEM_BO_TYPE_ID AND SSBTTL.LANGUAGE = USERENV('LANG')