View: UMX_LSA_ROLE_SET_ROLES_V

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

View Text

(SELECT NVL(UMX_FGA_UTILS_PKG.GET('BULK_SELECTION_VALUE')
, NVL2(ULRSR.ROLE_NAME
, 'Y'
, 'N')) IS_SELECTED
, WLR.NAME ROLE_NAME
, NVL(WLRT.DISPLAY_NAME
, WLR.DISPLAY_NAME) DISPLAYNAME
, NVL(WLRT.DESCRIPTION
, WLR.DESCRIPTION) DESCRIPTION FROM WF_LOCAL_ROLES WLR
, WF_LOCAL_ROLES_TL WLRT
, FND_LOOKUP_ASSIGNMENTS CAT
, UMX_LSA_ROLE_SET_ROLES ULRSR WHERE WLR.OWNER_TAG LIKE UMX_FGA_UTILS_PKG.GET('ROLE_APPL')
AND CAT.OBJ_NAME(+) = 'UMX_ACCESS_ROLE'
AND NVL(CAT.LOOKUP_CODE
, '%') LIKE UMX_FGA_UTILS_PKG.GET('ROLE_CAT')
AND WLR.NAME = CAT.INSTANCE_PK1_VALUE(+)
AND CAT.INSTANCE_PK2_VALUE IS NULL
AND CAT.INSTANCE_PK3_VALUE IS NULL
AND CAT.INSTANCE_PK4_VALUE IS NULL
AND CAT.INSTANCE_PK5_VALUE IS NULL
AND WLR.NAME LIKE UMX_FGA_UTILS_PKG.GET('ROLE_CODE')
AND ULRSR.ROLE_SET_ID(+) = UMX_FGA_UTILS_PKG.GET('ROLE_SET_ID')
AND WLR.NAME = ULRSR.ROLE_NAME(+)
AND WLR.PARTITION_ID IN (2
, 13)
AND WLR.ORIG_SYSTEM IN ('UMX'
, 'FND_RESP')
AND WLR.ORIG_SYSTEM_ID LIKE '%'
AND WLR.ORIG_SYSTEM = WLRT.ORIG_SYSTEM (+)
AND WLR.ORIG_SYSTEM_ID = WLRT.ORIG_SYSTEM_ID (+)
AND WLR.NAME = WLRT.NAME (+)
AND WLR.PARTITION_ID = WLRT.PARTITION_ID (+)
AND WLRT.LANGUAGE (+) = USERENV('LANG'))