SVC_STD_TXT_TOOLTIP_VL
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: VIEW
Columns
Name |
---|
STD_TXT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER STDTXT_NAME HTML_FLAG FOLDER_ID SCOPE USER_PARTY_ID ENABLED_FLAG START_DATE END_DATE STD_TXT_NUMBER DOMAIN STRIPE_CD OBJECT BU_ORG_ID STD_TXT_UNIQUE_NUMBER TOOLTIP |
Query
SQL_Statement |
---|
SELECT b.STD_TXT_ID, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER, b.STDTXT_NAME, b.HTML_FLAG, b.FOLDER_ID, b.SCOPE, b.USER_PARTY_ID, b.ENABLED_FLAG, b.START_DATE, b.END_DATE, b.STD_TXT_NUMBER, b.DOMAIN, b.STRIPE_CD, b.OBJECT, b.BU_ORG_ID, b.STD_TXT_UNIQUE_NUMBER, tl.TOOLTIP FROM SVC_STANDARD_TEXT_B b LEFT JOIN SVC_STANDARD_TEXT_TL tl ON b.STD_TXT_ID = tl.STD_TXT_ID WHERE tl.LANGUAGE = USERENV('LANG') |