DIS Items, Folders and Formulas

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Discoverer items (expressions) and folders (objects), including join conditions and formulas (calculated items)
Run DIS Items, Folders and Formulas and other Oracle EBS reports with Blitz Report™ on our demo environment
select
xxen_util.dis_business_area(eo.obj_id,:eul) business_area,
eo.obj_id,
ee.exp_id,
xxen_util.dis_folder_type(eo.obj_type) folder_type,
eo.obj_name folder_name,
nvl2(eo.sobj_ext_table,nvl2(uv.view_name,'View','Table'),null) object_type,
eo.sobj_ext_table object_name,
&sql_text_columns
xxen_util.dis_item_type(ee.exp_type) item_type,
ee.exp_name item_name,
eo3.obj_name join_folder_name,
xxen_util.meaning(ee.fk_mstr_no_detail,'SYS_YES_NO',700) outer_join,
ee.key_name join_name,
ee.fk_obj_id_remote,
ee.key_obj_id,
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,
xxen_api.dis_formula_sql(ee.exp_id,:eul) formula,
ee.it_ext_column db_column_name,
eo2.obj_name lov_folder,
xxen_util.dis_folder_type(eo2.obj_type) lov_folder_type,
ee2.exp_name lov_item,
ee2.lov_query,
&lov_validation_error
edo.dom_name lov_item_class,
ee.exp_formula1,
ee.exp_type,
ee2.it_obj_id lov_obj_id,
ee2.exp_id lov_exp_id,
ee2.exp_type lov_exp_type,
ee2.it_ext_column lov_column_name
from
(
select
ee.*,
ekc.key_name,
ekc.key_obj_id,
ekc.fk_obj_id_remote,
ekc.fk_mstr_no_detail
from
&eul.eul5_expressions ee,
&eul.eul5_key_cons ekc
where
decode(ee.exp_type,'JP',ee.jp_key_id)=ekc.key_id(+)
) ee,
(
select
(
select
xxen_util.long_to_clob('SYS.VIEW$', 'TEXT', v.rowid) text
from
sys."_CURRENT_EDITION_OBJ" o,
sys.view$ v,
sys.user$ u
where
u.name='APPS' and
eo.sobj_ext_table=o.name and
o.obj#=v.obj# and
o.owner#=u.user#
) text,
eo.*
from
&eul.eul5_objs eo
) eo,
user_views uv,
&eul.eul5_domains edo,
(select xxen_util.dis_lov_query(ee2.exp_id,:eul) lov_query, ee2.* from &eul.eul5_expressions ee2) ee2,
&eul.eul5_objs eo2,
&eul.eul5_objs eo3
where
1=1 and
decode(ee.exp_type,'FIL',ee.fil_obj_id,'CI',ee.it_obj_id,'CO',ee.it_obj_id,'JP',ee.key_obj_id)=eo.obj_id(+) and
ee.it_dom_id=edo.dom_id(+) and
edo.dom_it_id_lov=ee2.exp_id(+) and
ee2.it_obj_id=eo2.obj_id(+) and
ee.fk_obj_id_remote=eo3.obj_id(+) and
eo.sobj_ext_table=uv.view_name(+)
order by
eo.obj_name,
decode(ee.exp_type,'CO',1,'CI',2,'FIL',3,'JP',4),
ee.exp_sequence
Parameter Name SQL text Validation
Folder 
eo.obj_name like :folder
 LOV
Folder Identifier 
eo.obj_developer_key=:folder_identifier
 LOV
Folder Type 
eo.obj_type=decode(:folder_type,'Standard','SOBJ','Complex view','COBJ','Custom SQL','CUO')
 LOV
View Name 
eo.sobj_ext_table=:view_name
 LOV
Item Id 
ee.exp_id=:item_id
 Number
Object Id 
eo.obj_id=:object_id
 Number
Used by Workbook 
eo.obj_developer_key in (
select
eex.ex_to_par_devkey
from
eul_us.eul5_documents ed,
eul_us.eul5_elem_xrefs eex
where
ed.doc_name=:workbook and
ed.doc_id=eex.ex_from_id and
eex.ex_from_type='DOC'
)
 LOV
Item 
ee.exp_name=:item
 LOV
Item Type 
ee.exp_type=decode(:item_type,'Condition','FIL','Calculated Item','CI','Item','CO','Join Predicate','JP')
 LOV
Show Object SQL 
xxen_util.dis_folder_sql3(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
Validate LOV SQL 
xxen_report.validate_sql(replace(ee2.lov_query,':$flex$.',':'),'parse') lov_error_message,
 LOV
End User Layer 
<parameter_value>
 LOV
Download
Related Blitz Reports
DIS Workbooks, Folders, Items and LOVs DIS Folders, Business Areas, Items and LOVs DIS Worksheet Execution History DIS Access Privileges DIS Business Areas DIS Workbook Import Validation DIS Worksheet Execution Summary DIS End User Layers EIS Reports
Blitz Report™

Blitz Report™ provides multiple benefits: