The XC_INC.* objects appear to be JOBI objects related to
XREQ objects. Based on my SQL query for displaying XREQ objects, I came up with a simpler query to display just XC_* JOBI objects.
WITH BIND_PARMS
AS (SELECT 'XC_%' AS OBJECT_NAME FROM DUAL),
OT_TABS
AS ( SELECT OH_Idnr,
RTRIM (
XMLCAST (
XMLAGG (XMLELEMENT (e, OT_Content || CHR (10))
ORDER BY OT_Lnr) AS CLOB))
AS OT_CONTENT_CLOB
FROM OT LEFT OUTER JOIN OH ON OT_OH_Idnr = OH_Idnr
GROUP BY OH_Idnr
ORDER BY OH_Idnr),
INITIAL_DATA_OBJECTS
AS ( SELECT OH.OH_Idnr,
OH_Name,
OH_OType,
OT_TABS.OT_CONTENT_CLOB
FROM OH LEFT JOIN OT_TABS ON OH.OH_Idnr = OT_TABS.OH_Idnr
WHERE OH_NAME LIKE (SELECT OBJECT_NAME FROM BIND_PARMS)
AND OH_Client = 0
AND OH.OH_Idnr < 100000
AND OH_OType = 'JOBI'
AND OH_DeleteFlag = 0
ORDER BY OH_Name)
SELECT *
FROM INITIAL_DATA_OBJECTS
WHERE 1 = 1 AND ROWNUM < 1000
There are also some VARA and PRPT objects related to the XC_* JOB objects.
select * from OH
where 1=1
and OH_Client = 0
and OH_Idnr < 100000
and OH_DeleteFlag = 0
and OH_OType <> 'XREQ'
and OH_Name like 'XC_%'
order by OH_OType,OH_Name asc
As far as I could determine, all of these objects are included with the
initial data. This is evident from the fact that they all have OH_Idnr values less than 100000. One can list all initial data objects using this query:
select * from OH
where 1=1
and OH_Client = 0
and OH_Idnr < 100000
and OH_DeleteFlag = 0
order by OH_Idnr asc