FAI_DEEP_LINKS_VL

Details

• Schema: FUSION

• Object owner: FAI

• Object type: VIEW

Columns

Name
DEEP_LINK_ID DEEP_LINK_CODE USAGE_TYPE DESTINATION_URL DEEP_LINK_PROPERTIES FAMILY PRODUCT CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MODULE_ID NAME DESCRIPTION MESSAGE

Query

SQL_Statement

SELECT b.DEEP_LINK_ID DEEP_LINK_ID, b.DEEP_LINK_CODE DEEP_LINK_CODE, b.USAGE_TYPE USAGE_TYPE, b.DESTINATION_URL DESTINATION_URL, b.DEEP_LINK_PROPERTIES DEEP_LINK_PROPERTIES, b.FAMILY FAMILY, b.PRODUCT PRODUCT, b.CREATED_BY CREATED_BY, b.CREATION_DATE CREATION_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, b.MODULE_ID MODULE_ID, tl.NAME NAME, tl.DESCRIPTION DESCRIPTION, tl.MESSAGE MESSAGE FROM FAI_DEEP_LINKS_B b, FAI_DEEP_LINKS_TL tl WHERE b.DEEP_LINK_ID = tl.DEEP_LINK_ID AND tl.LANGUAGE = USERENV('LANG')