View: UMX_ALL_ROLE_VL

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.UMX_ALL_ROLE_VL

View Text

(SELECT WR.NAME
, WRT.DISPLAY_NAME
, WRT.DESCRIPTION
, WR.LANGUAGE
, WR.ORIG_SYSTEM
, WR.ORIG_SYSTEM_ID
, WR.PARENT_ORIG_SYSTEM
, WR.PARENT_ORIG_SYSTEM_ID
, WR.START_DATE
, WR.STATUS
, WR.EXPIRATION_DATE
, WR.OWNER_TAG
, WR.PARTITION_ID
FROM WF_LOCAL_ROLES WR
, WF_LOCAL_ROLES_TL WRT
WHERE WR.PARTITION_ID IN (2
, 13)
AND WR.ORIG_SYSTEM IN ( 'UMX'
, 'FND_RESP')
AND WR.NAME = WRT.NAME
AND WR.ORIG_SYSTEM = WRT.ORIG_SYSTEM
AND WR.ORIG_SYSTEM_ID = WRT.ORIG_SYSTEM_ID
AND WR.PARTITION_ID = WRT.PARTITION_ID
AND WRT.LANGUAGE = USERENV('LANG') UNION ALL (SELECT WR.NAME
, WR.DISPLAY_NAME
, WR.DESCRIPTION
, WR.LANGUAGE
, WR.ORIG_SYSTEM
, WR.ORIG_SYSTEM_ID
, WR.PARENT_ORIG_SYSTEM
, WR.PARENT_ORIG_SYSTEM_ID
, WR.START_DATE
, WR.STATUS
, WR.EXPIRATION_DATE
, WR.OWNER_TAG
, WR.PARTITION_ID
FROM WF_LOCAL_ROLES WR
WHERE WR.PARTITION_ID IN (2
, 13)
AND WR.ORIG_SYSTEM IN ( 'UMX'
, 'FND_RESP')
AND NOT EXISTS (SELECT NULL
FROM WF_LOCAL_ROLES_TL WRT
WHERE WRT.LANGUAGE = USERENV('LANG')
AND WRT.NAME = WR.NAME
AND WRT.ORIG_SYSTEM = WR.ORIG_SYSTEM
AND WRT.ORIG_SYSTEM_ID = WR.ORIG_SYSTEM_ID
AND WRT.PARTITION_ID = WR.PARTITION_ID )))