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')