View: BIS_CUSTOM_RELATED_LINKS_V

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_CUSTOM_RELATED_LINKS_V

View Text

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')