Report IO-BC-Table Field Mapping

 

SQL:

--------------------------------------------------------------------
select ic.xml_tag Logical_Entity, ifd.xml_tag Logical_Attribute
  , bc.name BusComp, sf.name Siebel_Field, nvl(sf.JOIN_NAME, bc.table_name) Table_Name, sf.col_name
from s_int_obj io, s_int_comp ic, s_int_field ifd, s_buscomp bc, s_field sf
where io.name = 'SIFLEAInfoIO'
and io.row_id = ic.int_obj_id
and ic.inactive_flg = 'N'
and ic.ext_name = bc.name
and ifd.int_comp_id  = ic.row_id
and ifd.inactive_flg = 'N'
and ifd.name = sf.name
and bc.row_id = sf.buscomp_id
and sf.inactive_flg = 'N'
order by bc.name, ic.xml_tag;

 

-----------------------------------------------------------------------------
SELECT io.name Integration_Object, ic.name Integration_Componen
  , ic.xml_tag IC_XML_Tag, ic.xml_parent_element IC_XML_Container_Element
  , ifd.name IC_Field_Name, ifd.xml_tag BC_Field_XML_Tag
FROM S_INT_OBJ io, S_INT_COMP ic, S_INT_FIELD ifd
WHERE io.name = 'SIFSchoolInfo'
and io.row_id = ic.int_obj_id
and ic.inactive_flg = 'N'
and ic.row_id = ifd.int_comp_id
and ifd.inactive_flg = 'N';