Parameter Name |
SQL text |
Validation |
Show Active only |
|
LOV |
Show Items |
|
LOV |
Show Object SQL |
xxen_util.dis_folder_sql2(eo.obj_id,'&eul') folder_sql,
case when lower(dbms_lob.substr(eo.text,15,length(eo.text)-14))=' with read only' then substr(eo.text,1,length(eo.text)-15) else eo.text end view_sql, |
xxen_util.dis_folder_sql2(eo.obj_id,'&eul') folder_sql,
case when lower(dbms_lob.substr(eo.text,15,length(eo.text)-14))=' with read only' then substr(eo.text,1,length(eo.text)-15) else eo.text end view_sql,
|
LOV |
End User Layer |
|
LOV |
Business Area |
eo.obj_id in (
select
ebol.bol_obj_id
from
eul_us1.eul5_bas eb,
eul_us1.eul5_ba_obj_links ebol
where
eb.ba_name=:business_area and
eb.ba_id=ebol.bol_ba_id
) |
eo.obj_id in (
select
ebol.bol_obj_id
from
eul_us1.eul5_bas eb,
eul_us1.eul5_ba_obj_links ebol
where
eb.ba_name=:business_area and
eb.ba_id=ebol.bol_ba_id
)
|
LOV |
Used by Workbook |
eo.obj_developer_key in (
select
eex.ex_to_par_devkey
from
eul_us1.eul5_documents ed,
eul_us1.eul5_elem_xrefs eex
where
ed.doc_name=:workbook and
ed.doc_id=eex.ex_from_id and
eex.ex_from_type='DOC'
) |
eo.obj_developer_key in (
select
eex.ex_to_par_devkey
from
eul_us1.eul5_documents ed,
eul_us1.eul5_elem_xrefs eex
where
ed.doc_name=:workbook and
ed.doc_id=eex.ex_from_id and
eex.ex_from_type='DOC'
)
|
LOV |
Folder |
|
LOV |
Folder Type |
eo.obj_type=decode(:folder_type,'Standard','SOBJ','Complex view','COBJ','Custom SQL','CUO') |
eo.obj_type=decode(:folder_type,'Standard','SOBJ','Complex view','COBJ','Custom SQL','CUO')
|
LOV |
Item |
|
LOV |
Item Type |
ee.exp_type=decode(:item_type,'Condition','FIL','Calculated Item','CI','Item','CO','Join Predicate','JP') |
ee.exp_type=decode(:item_type,'Condition','FIL','Calculated Item','CI','Item','CO','Join Predicate','JP')
|
LOV |
View Name |
eo.sobj_ext_table=:view_name |
eo.sobj_ext_table=:view_name
|
LOV |
Folder Identifier |
eo.obj_developer_key=:folder_identifier |
eo.obj_developer_key=:folder_identifier
|
LOV |
Object Id |
|
Number |
Access Count within x Days |
eqs.qs_created_date>sysdate-:days |
eqs.qs_created_date>sysdate-:days
|
Number |
Item |
|
|
Item Type |
|
|
Show Items |
ee.exp_name item_name,
xxen_util.dis_item_type(ee.exp_type) item_type,
decode(ee.fil_runtime_filter,1,'Optional',0,'Mandatory') condition_type,
coalesce(ee.it_ext_column,xxen_util.dis_formula_sql(ee.exp_id,'&eul')) column_or_formula,
decode(ee.exp_data_type,1,'Varchar',2,'Number',3,'Long',4,'Date',5,'Raw',6,'Large binary object',8,'Char',10,null,ee.exp_data_type) data_type,
eo2.obj_name lov_folder,
ee2.exp_name lov_item,
xxen_util.dis_lov_query(ee2.it_obj_id,ee2.it_ext_column,'&eul') lov_query,
edo.dom_name lov_item_class,
ee.exp_id, |
ee.exp_name item_name,
xxen_util.dis_item_type(ee.exp_type) item_type,
decode(ee.fil_runtime_filter,1,'Optional',0,'Mandatory') condition_type,
coalesce(ee.it_ext_column,xxen_util.dis_formula_sql(ee.exp_id,'&eul')) column_or_formula,
decode(ee.exp_data_type,1,'Varchar',2,'Number',3,'Long',4,'Date',5,'Raw',6,'Large binary object',8,'Char',10,null,ee.exp_data_type) data_type,
eo2.obj_name lov_folder,
ee2.exp_name lov_item,
xxen_util.dis_lov_query(ee2.it_obj_id,ee2.it_ext_column,'&eul') lov_query,
edo.dom_name lov_item_class,
ee.exp_id,
|
|