Siebel SQLs/Error Messages >  SQLs to link Integration Component, integration objects, XML Tag and views

Integration Component Name from XML Tag or BI Publisher document Name:

SELECT
distinct report.NAME TEMPLATE,
a.xml_tag,
b.name as int_component ,
c.name as Int_Objekt,
a.name as Field_name
FROM SIEBEL.S_XMLP_REP_TMPL report,
SIEBEL.S_XMLP_RPT_VIEW vreport,
SIEBEL.S_APP_VIEW v,
SIEBEL.S_VIEW rv,
SIEBEL.S_REPOSITORY r,
SIEBEL.S_XMLP_REP_IOBJ io,
siebel.s_int_field a,
siebel.s_int_comp b,
SIEBEL.S_int_obj c
WHERE report.ROW_ID = vreport.REPORT_ID
AND vreport.VIEW_ID = v.ROW_ID
AND v.NAME = rv.NAME
AND rv.REPOSITORY_ID = r.ROW_ID
AND report.XMLP_REP_INTOBJ_ID = io.ROW_ID(+)
AND r.NAME = 'Siebel Repository'
and c.name = io.INT_OBJ_NAME
and a.int_comp_id = b.row_id
and b.int_obj_id = c.row_id
AND report.NAME LIKE '%document name%'
and a.xml_tag = 'xmltag name';

INT OBJ Name und Int Comp Name from XML Tag:

select a.xml_tag, b.name as int_component , c.name as Int_Objekt
from siebel.s_int_field a, siebel.s_int_comp b, SIEBEL.S_int_obj c
where a.xml_tag = 'xmltag name'
and a.int_comp_id = b.row_id
and b.int_obj_id = c.row_id;

View and Integration Object:

SELECT report.CREATED REL_CREATED,
report.NAME TEMPLATE,
v.ROW_ID VIEW_ID,
v.NAME VIEWNAME,
vreport.X_ENABLE_KNIFE ACTIVE,
vreport.X_BUS_CASE BUS_CASE,
rv.BUSOBJ_NAME,
rv.THREAD_APPLET_NAME,
io.INT_OBJ_NAME IO_NAME
FROM SIEBEL.S_XMLP_REP_TMPL report,
SIEBEL.S_XMLP_RPT_VIEW vreport,
SIEBEL.S_APP_VIEW v,
SIEBEL.S_VIEW rv,
SIEBEL.S_REPOSITORY r,
SIEBEL.S_XMLP_REP_IOBJ io
WHERE report.ROW_ID = vreport.REPORT_ID
AND vreport.VIEW_ID = v.ROW_ID
AND v.NAME = rv.NAME
AND rv.REPOSITORY_ID = r.ROW_ID
AND report.XMLP_REP_INTOBJ_ID = io.ROW_ID(+)
AND r.NAME = 'Siebel Repository'
AND report.NAME LIKE '%document name%';