VIEW: APPS.UMX_LSA_ROLE_SET_ROLES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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