SVC_STANDARD_TEXT_EXP_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 TEXT SOURCE_LANG LANGUAGE 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

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, tl.TEXT, tl.SOURCE_LANG, tl.LANGUAGE, 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 FROM SVC_STANDARD_TEXT_B b LEFT JOIN SVC_STANDARD_TEXT_TL tl ON b.STD_TXT_ID = tl.STD_TXT_ID