VIEW: APPS.BIS_RELATED_LINKS_V

Source

View Text - Preformatted

SELECT r.RELATED_LINK_ID ,r.CREATION_DATE ,r.CREATED_BY ,r.LAST_UPDATE_DATE ,r.LAST_UPDATED_BY ,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 , f.description ,r.LAST_UPDATE_LOGIN ,r.RESPONSIBILITY_ID ,r.SECURITY_GROUP_ID ,r.RESPONSIBILITY_APPLICATION_ID ,r.DISPLAY_SEQUENCE FROM BIS_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.CREATION_DATE ,r.CREATED_BY ,r.LAST_UPDATE_DATE ,r.LAST_UPDATED_BY ,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.LAST_UPDATE_LOGIN ,r.RESPONSIBILITY_ID ,r.SECURITY_GROUP_ID ,r.RESPONSIBILITY_APPLICATION_ID ,r.DISPLAY_SEQUENCE FROM BIS_RELATED_LINKS_vl r where r.link_type IN ('USER_URL', 'PRESEED_USER_URL')
   

View Text - HTML Formatted

SELECT R.RELATED_LINK_ID
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, 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
, F.DESCRIPTION
, R.LAST_UPDATE_LOGIN
, R.RESPONSIBILITY_ID
, R.SECURITY_GROUP_ID
, R.RESPONSIBILITY_APPLICATION_ID
, R.DISPLAY_SEQUENCE
FROM BIS_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.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, 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.LAST_UPDATE_LOGIN
, R.RESPONSIBILITY_ID
, R.SECURITY_GROUP_ID
, R.RESPONSIBILITY_APPLICATION_ID
, R.DISPLAY_SEQUENCE
FROM BIS_RELATED_LINKS_VL R
WHERE R.LINK_TYPE IN ('USER_URL'
, 'PRESEED_USER_URL')