DBA Data[Home] [Help]

VIEW: APPS.BIS_RELATED_LINKS_VL

Source

View Text - Preformatted

SELECT r.related_link_id, function_id, link_type, linked_function_id, linked_field, link_parameters, link_condition, user_url, display_sequence, responsibility_id, security_group_id, responsibility_application_id, rtl.user_link_name, r.creation_date, r.created_by, r.last_update_date, r.last_updated_by, r.last_update_login from bis_related_links r, bis_related_Links_tl rtl WHERE r.related_link_id = rtl.related_Link_id and rtl.language = userenv('LANG')
   
View Text - HTML Formatted

SELECT R.RELATED_LINK_ID
, FUNCTION_ID
, LINK_TYPE
, LINKED_FUNCTION_ID
, LINKED_FIELD
, LINK_PARAMETERS
, LINK_CONDITION
, USER_URL
, DISPLAY_SEQUENCE
, RESPONSIBILITY_ID
, SECURITY_GROUP_ID
, RESPONSIBILITY_APPLICATION_ID
, RTL.USER_LINK_NAME
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_LOGIN
FROM BIS_RELATED_LINKS R
, BIS_RELATED_LINKS_TL RTL
WHERE R.RELATED_LINK_ID = RTL.RELATED_LINK_ID
AND RTL.LANGUAGE = USERENV('LANG')