To_find_responisibiltiy_the_discoverer_rpt_assigned

SELECT --'Shared with --->',
EUL4_DOCUMENTS.DOC_LENGTH/1024 "Size",
EUL4_DOCUMENTS.DOC_CREATED_DATE "Created Date",
DECODE(RFGEUL4_US.EUL4_GET_ISITAPPS_EUL,1,RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_DOCUMENTS.DOC_CREATED_BY),EUL4_DOCUMENTS.DOC_CREATED_BY) "Created By",
EUL4_DOCUMENTS.DOC_NAME "Document Name",
EUL4_ACCESS_PRIVS.AP_CREATED_DATE "Shared Date",
DECODE(DECODE(RFGEUL4_US.EUL4_GET_ISITAPPS_EUL,1,DECODE(EUL4_EUL_USERS.EU_ROLE_FLAG,1,RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME,'R'),RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME)),EUL4_EUL_USERS.EU_USERNAME),'*** Undefined Error 2 ***','Document Not Shared',DECODE(RFGEUL4_US.EUL4_GET_ISITAPPS_EUL,1,DECODE(EUL4_EUL_USERS.EU_ROLE_FLAG,1,RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME,'R'),RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME)),EUL4_EUL_USERS.EU_USERNAME)) "Responsibility Name"
FROM RFGEUL4_US.EUL4_ACCESS_PRIVS EUL4_ACCESS_PRIVS, RFGEUL4_US.EUL4_DOCUMENTS EUL4_DOCUMENTS, RFGEUL4_US.EUL4_EUL_USERS EUL4_EUL_USERS
WHERE ( EUL4_DOCUMENTS.DOC_ID = EUL4_ACCESS_PRIVS.GD_DOC_ID(+) )
AND ( EUL4_EUL_USERS.EU_ID(+) = EUL4_ACCESS_PRIVS.AP_EU_ID )
AND ( EUL4_DOCUMENTS.DOC_CONTENT_TYPE = 'application/vnd.oracle-disco.wb' )
AND EUL4_DOCUMENTS.DOC_NAME LIKE '%Report name%'
ORDER BY EUL4_DOCUMENTS.DOC_NAME ASC,
EUL4_DOCUMENTS.DOC_CREATED_DATE ASC,
'Shared with --->' ASC,
DECODE(DECODE(RFGEUL4_US.EUL4_GET_ISITAPPS_EUL,1,DECODE(EUL4_EUL_USERS.EU_ROLE_FLAG,1,RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME,'R'),RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME)),EUL4_EUL_USERS.EU_USERNAME),'*** Undefined Error 2 ***','Document Not Shared',DECODE(RFGEUL4_US.EUL4_GET_ISITAPPS_EUL,1,DECODE(EUL4_EUL_USERS.EU_ROLE_FLAG,1,RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME,'R'),RFGEUL4_US.EUL4_GET_APPS_USERRESP(EUL4_EUL_USERS.EU_USERNAME)),EUL4_EUL_USERS.EU_USERNAME)) ASC