[Home] [Help]
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
)))