Schema Map - relationship between tables / views

Hi

Here is relation between logical units:

select * from reference_sys_tab
 

Conjuction with dictionary_sys_view_tab might help to identify views connected with LU’s.

I believe one reason standard Oracle reporting tools can’t tell you much is that IFS does not use much by way of constraints, etc. Business rules and parent/child relationships are defined by the package API code. Right now I could go in and delete all records from CUSTOMER_INFO_TAB, making all CUSTOMER_INFO_ADDRESS records orphans -- no conditional key linkage would prevent that, as far as I can tell.

Good to know about the Reference_Sys table!

Thanks,

Joe Kaufman