Product: | BIS - Applications BIS |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BIS_RELATED_LINKS_V |
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')