ORB Report Assignment Details

➜ Back to Library
Description
Categories: ORBIT
Details of the Active Report Assignments. Report can be assigned to ROLE or USER.
It also indicate if the assignee has access to run,copy,edit,delete,export the report
select 
orv_shared.*,
case
when orv_shared.access_permission in
         (1,
          3,
          5,
          7,
          9,
          11,
          13,
          15,
          17,
          19,
          21,
          23,
          25,
          27,
          29,
          31,
          33,
          35,
          37,
          39,
          41,
          43,
          45,
          47,
          49,
          51,
          53,
          55,
          57,
          59,
          61,
          63,
          65,
          67,
          69,
          71,
          73,
          75,
          77,
          79,
          81,
          83,
          85,
          87,
          89,
          91,
          93,
          95,
          97,
          99,
          101,
          103,
          105,
          107,
          109,
          111,
          113,
          115,
          117,
          119,
          121,
          123,
          125,
          127,
          129,
          131,
          133,
          135,
          137,
          139,
          141,
          143,
          145,
          147,
          149,
          151,
          153,
          155,
          157,
          159,
          161,
          163,
          165,
          167,
          169,
          171,
          173,
          175,
          177,
          178,
          181,
          183,
          185,
          187,
          189,
          191,
          193,
          195,
          197,
          199,
          201,
          203,
          205,
          207,
          209,
          211,
          213,
          215,
          217,
          219,
          221,
          223,
          225,
          227,
          229,
          231,
          233,
          235,
          237,
          239,
          241,
          243,
          245,
          247,
          249,
          251,
          253,
          255)
 then
    'Yes'
 else
    'No'
end run_report,
case
 when orv_shared.access_permission in
         (2,
          3,
          6,
          7,
          10,
          11,
          14,
          15,
          18,
          19,
          22,
          23,
          26,
          27,
          30,
          31,
          34,
          35,
          38,
          39,
          42,
          43,
          46,
          47,
          50,
          51,
          54,
          55,
          58,
          59,
          62,
          63,
          66,
          67,
          70,
          71,
          74,
          75,
          78,
          79,
          82,
          83,
          86,
          87,
          90,
          91,
          94,
          95,
          98,
          99,
          102,
          103,
          106,
          107,
          110,
          111,
          114,
          115,
          118,
          119,
          122,
          123,
          126,
          127,
          130,
          131,
          134,
          135,
          138,
          139,
          142,
          143,
          146,
          147,
          150,
          151,
          154,
          155,
          158,
          159,
          162,
          163,
          166,
          167,
          170,
          171,
          174,
          175,
          178,
          179,
          182,
          183,
          186,
          187,
          190,
          191,
          194,
          195,
          198,
          199,
          202,
          203,
          206,
          207,
          210,
          211,
          214,
          215,
          218,
          219,
          222,
          223,
          226,
          227,
          230,
          231,
          234,
          235,
          238,
          239,
          242,
          243,
          246,
          247,
          250,
          251,
          254,
          255)
 then
    'Yes'
 else
    'No'
end edit_report,
case
 when orv_shared.access_permission in
         (4,
          5,
          6,
          7,
          12,
          13,
          14,
          15,
          20,
          21,
          22,
          23,
          28,
          29,
          30,
          31,
          36,
          37,
          38,
          39,
          44,
          45,
          46,
          47,
          52,
          53,
          54,
          55,
          60,
          61,
          62,
          63,
          68,
          69,
          70,
          71,
          76,
          77,
          78,
          79,
          84,
          85,
          86,
          87,
          92,
          93,
          94,
          95,
          100,
          101,
          102,
          103,
          108,
          109,
          110,
          111,
          116,
          117,
          118,
          119,
          124,
          125,
          126,
          127,
          132,
          133,
          134,
          135,
          140,
          141,
          142,
          143,
          148,
          149,
          150,
          151,
          156,
          157,
          158,
          159,
          164,
          165,
          166,
          167,
          172,
          173,
          174,
          175,
          180,
          181,
          182,
          183,
          188,
          189,
          190,
          191,
          196,
          197,
          198,
          199,
          204,
          205,
          206,
          207,
          212,
          213,
          214,
          215,
          220,
          221,
          222,
          223,
          228,
          229,
          230,
          231,
          236,
          237,
          238,
          239,
          244,
          245,
          246,
          247,
          252,
          253,
          244,
          255)
 then
    'Yes'
 else
    'No'
end delete_report,
case
 when orv_shared.access_permission in
         (8,
          9,
          10,
          11,
          12,
          13,
          14,
          15,
          24,
          25,
          26,
          27,
          28,
          29,
          30,
          31,
          40,
          41,
          42,
          43,
          44,
          45,
          46,
          47,
          56,
          57,
          58,
          59,
          60,
          61,
          62,
          63,
          72,
          73,
          74,
          75,
          76,
          77,
          78,
          79,
          88,
          89,
          90,
          91,
          92,
          93,
          94,
          95,
          104,
          105,
          106,
          107,
          108,
          109,
          110,
          111,
          120,
          121,
          122,
          123,
          124,
          125,
          126,
          127,
          136,
          137,
          138,
          139,
          140,
          141,
          142,
          143,
          152,
          153,
          154,
          155,
          156,
          157,
          158,
          159,
          168,
          169,
          170,
          171,
          172,
          173,
          174,
          175,
          184,
          185,
          186,
          187,
          188,
          189,
          190,
          191,
          200,
          201,
          202,
          203,
          204,
          205,
          206,
          207,
          216,
          217,
          218,
          219,
          220,
          221,
          222,
          223,
          232,
          233,
          234,
          235,
          236,
          237,
          238,
          239,
          248,
          249,
          250,
          251,
          252,
          253,
          254,
          255)
 then
    'Yes'
 else
    'No'
end copy_report,
case
 when orv_shared.access_permission in
         (16,
          17,
          18,
          19,
          20,
          21,
          22,
          23,
          24,
          25,
          26,
          27,
          28,
          29,
          29,
          30,
          31,
          49,
          50,
          51,
          52,
          53,
          54,
          55,
          56,
          57,
          58,
          59,
          60,
          61,
          62,
          63,
          80,
          81,
          82,
          83,
          84,
          85,
          86,
          87,
          88,
          89,
          90,
          91,
          92,
          93,
          94,
          95,
          112,
          113,
          114,
          115,
          116,
          117,
          118,
          119,
          120,
          121,
          122,
          123,
          124,
          125,
          126,
          127,
          144,
          145,
          146,
          147,
          148,
          149,
          150,
          151,
          152,
          153,
          154,
          155,
          156,
          157,
          158,
          159,
          176,
          177,
          178,
          179,
          180,
          181,
          182,
          183,
          184,
          185,
          186,
          187,
          188,
          189,
          190,
          191,
          208,
          209,
          210,
          211,
          212,
          213,
          214,
          215,
          216,
          217,
          218,
          219,
          220,
          221,
          222,
          223,
          240,
          241,
          242,
          243,
          244,
          245,
          246,
          247,
          248,
          249,
          250,
          251,
          252,
          253,
          254,
          255)
 then
    'Yes'
 else
    'No'
end schedule_report,
case
 when orv_shared.access_permission in
         (32,
          33,
          34,
          35,
          36,
          37,
          38,
          39,
          40,
          41,
          42,
          43,
          44,
          45,
          46,
          47,
          48,
          49,
          50,
          51,
          52,
          53,
          54,
          55,
          56,
          57,
          58,
          59,
          60,
          61,
          62,
          63,
          96,
          97,
          98,
          99,
          100,
          101,
          102,
          103,
          104,
          105,
          106,
          107,
          108,
          109,
          110,
          111,
          112,
          113,
          114,
          115,
          116,
          117,
          118,
          119,
          120,
          121,
          122,
          123,
          124,
          125,
          126,
          127,
          160,
          161,
          162,
          163,
          164,
          165,
          166,
          167,
          168,
          169,
          170,
          178,
          179,
          180,
          181,
          182,
          183,
          184,
          185,
          186,
          187,
          188,
          189,
          190,
          191,
          224,
          225,
          226,
          227,
          228,
          229,
          230,
          231,
          232,
          233,
          234,
          235,
          236,
          237,
          238,
          239,
          240,
          241,
          242,
          243,
          244,
          245,
          246,
          247,
          248,
          249,
          250,
          251,
          252,
          253,
          254,
          255)
 then
    'Yes'
 else
    'No'
end export_report,
case
 when orv_shared.access_permission in
         (64,
          65,
          66,
          67,
          68,
          69,
          70,
          71,
          72,
          73,
          74,
          75,
          76,
          77,
          78,
          79,
          80,
          81,
          82,
          83,
          84,
          85,
          86,
          87,
          88,
          89,
          90,
          91,
          92,
          93,
          94,
          95,
          96,
          97,
          98,
          99,
          100,
          101,
          102,
          103,
          104,
          105,
          106,
          107,
          108,
          109,
          110,
          111,
          112,
          113,
          114,
          115,
          116,
          117,
          118,
          119,
          120,
          121,
          122,
          123,
          124,
          125,
          126,
          127,
          192,
          193,
          194,
          195,
          196,
          197,
          198,
          199,
          200,
          201,
          202,
          203,
          204,
          205,
          206,
          207,
          208,
          209,
          210,
          211,
          212,
          213,
          214,
          215,
          216,
          217,
          218,
          219,
          220,
          221,
          222,
          223,
          224,
          225,
          226,
          227,
          228,
          229,
          230,
          231,
          232,
          233,
          234,
          235,
          236,
          237,
          238,
          239,
          240,
          241,
          242,
          243,
          244,
          245,
          246,
          247,
          248,
          249,
          250,
          251,
          252,
          253,
          254,
          255)
 then
    'Yes'
 else
    'No'
end generate_link
from
(select 
orv.report_id,
orv.report_name,
orv.report_desc report_description,
orv.folder_name report_folder_name,
olf_domain.property_value domain_name,
orv.report_type,
omos.access_permission,
omos.role_id,
omos.user_id,
orole.name role_name,
case when omos.role_id is null then 'USER' else 'ROLE' end  as shared_type,
xxen_orb_util.orb_user(omos.user_id) shared_user_name,
xxen_orb_util.orb_user(omo_rep.created_by) created_by,
omo_rep.created_date created_date,
xxen_orb_util.orb_user(omo_rep.last_modified_by) last_modified_by,
omo_rep.last_modified_date
from 
xxorb.orb_report_v orv,
xxorb.orb_meta_object omo_rep,
xxorb.orb_meta_object omo_inh_obj,
xxorb.orb_meta_object omo_lm,
xxorb.orb_meta_object omo_domain,
xxorb.orb_localizedstring_flat olf_domain,
xxorb.orb_meta_object_security omos,
xxorb.orb_role orole
where 
omo_rep.id = orv.report_id and
omo_rep.inherited_meta_obj_id = omo_inh_obj.id and
omo_inh_obj.parent_id = omo_lm.id and
omo_lm.parent_id = omo_domain.id and
olf_domain.meta_object_id = omo_domain.id and
olf_domain.property_key = 'name' and
omo_rep.obj_type = 13 and 
omo_inh_obj.obj_type = 10 and
omo_lm.obj_type = 6 and
omo_domain.obj_type = 1 and
omo_rep.id = omos.meta_object_id(+) and
omos.role_id = orole.id(+)
union all
select 
orv.report_id,
orv.report_name,
orv.report_desc report_description,
orv.folder_name report_folder_name,
null domain_name,
orv.report_type,
omos.access_permission,
omos.role_id,
omos.user_id,
orole.name role_name,
case when omos.role_id is null then 'USER' else 'ROLE' end  as shared_type,
xxen_orb_util.orb_user(omos.user_id) shared_user_name,
xxen_orb_util.orb_user(omo_rep.created_by) created_by,
omo_rep.created_date created_date,
xxen_orb_util.orb_user(omo_rep.last_modified_by) last_modified_by,
omo_rep.last_modified_date
from 
xxorb.orb_report_v orv,
xxorb.orb_meta_object omo_rep,
xxorb.orb_meta_object_security omos,
xxorb.orb_role orole
where 
omo_rep.id = orv.report_id and
omo_rep.inherited_meta_obj_id is null and
omo_rep.obj_type = 13 and 
orv.report_type<>'Data Report' and
omo_rep.id = omos.meta_object_id(+) and
omos.role_id = orole.id(+)
)orv_shared 
where 1=1
Parameter NameSQL textValidation
Report Name
orv_shared.report_name=:report_name
LOV
Report Type
orv_shared.report_type=:report_type
LOV
Download
Blitz Report™