DBA Data[Home] [Help]

VIEW: APPS.BIS_CUSTOM_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, level_site_id, level_responsibility_id, level_org_id, level_application_id, level_function_id, level_user_id, r.creation_date, r.created_by, r.last_update_date, r.last_updated_by, r.last_update_login from bis_custom_related_links r, bis_custom_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
, LEVEL_SITE_ID
, LEVEL_RESPONSIBILITY_ID
, LEVEL_ORG_ID
, LEVEL_APPLICATION_ID
, LEVEL_FUNCTION_ID
, LEVEL_USER_ID
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_LOGIN
FROM BIS_CUSTOM_RELATED_LINKS R
, BIS_CUSTOM_RELATED_LINKS_TL RTL
WHERE R.RELATED_LINK_ID = RTL.RELATED_LINK_ID
AND RTL.LANGUAGE = USERENV('LANG')