VIEW: APPS.BIS_CUSTOM_RELATED_LINKS_V

Source

View Text - Preformatted

SELECT r.related_link_id, r.function_id, r.link_type, r.linked_function_id, r.linked_field, r.link_parameters, r.link_condition, r.user_url, f.user_function_name user_link_name, f.description user_link_description, r.responsibility_id, r.security_group_id, r.responsibility_application_id, r.display_sequence, r.level_site_id, level_responsibility_id, level_application_id, level_org_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_vl r, fnd_form_functions_vl f WHERE r.link_type NOT IN ('USER_URL', 'PRESEED_USER_URL') AND f.function_id=r.linked_function_id UNION ALL SELECT r.related_link_id, r.function_id, r.link_type, r.linked_function_id, r.linked_field, r.link_parameters, r.link_condition, r.user_url, r.user_link_name, r.user_link_name, r.responsibility_id, r.security_group_id, r.responsibility_application_id, r.display_sequence, r.level_site_id, level_responsibility_id, level_application_id, level_org_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_vl r WHERE r.link_type IN ('USER_URL', 'PRESEED_USER_URL')
   

View Text - HTML Formatted

SELECT R.RELATED_LINK_ID
, R.FUNCTION_ID
, R.LINK_TYPE
, R.LINKED_FUNCTION_ID
, R.LINKED_FIELD
, R.LINK_PARAMETERS
, R.LINK_CONDITION
, R.USER_URL
, F.USER_FUNCTION_NAME USER_LINK_NAME
, F.DESCRIPTION USER_LINK_DESCRIPTION
, R.RESPONSIBILITY_ID
, R.SECURITY_GROUP_ID
, R.RESPONSIBILITY_APPLICATION_ID
, R.DISPLAY_SEQUENCE
, R.LEVEL_SITE_ID
, LEVEL_RESPONSIBILITY_ID
, LEVEL_APPLICATION_ID
, LEVEL_ORG_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_VL R
, FND_FORM_FUNCTIONS_VL F
WHERE R.LINK_TYPE NOT IN ('USER_URL'
, 'PRESEED_USER_URL')
AND F.FUNCTION_ID=R.LINKED_FUNCTION_ID UNION ALL SELECT R.RELATED_LINK_ID
, R.FUNCTION_ID
, R.LINK_TYPE
, R.LINKED_FUNCTION_ID
, R.LINKED_FIELD
, R.LINK_PARAMETERS
, R.LINK_CONDITION
, R.USER_URL
, R.USER_LINK_NAME
, R.USER_LINK_NAME
, R.RESPONSIBILITY_ID
, R.SECURITY_GROUP_ID
, R.RESPONSIBILITY_APPLICATION_ID
, R.DISPLAY_SEQUENCE
, R.LEVEL_SITE_ID
, LEVEL_RESPONSIBILITY_ID
, LEVEL_APPLICATION_ID
, LEVEL_ORG_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_VL R
WHERE R.LINK_TYPE IN ('USER_URL'
, 'PRESEED_USER_URL')