It is the same table.
select def.* from CMN_SCH_JOB_DEFINITIONS def
join cmn_lookups_v clv on clv.id=def.job_type and clv.lookup_type='SCH_JOB_TYPE' and clv.language_code='en'
where clv.lookup_code='REPORT'
Original Message:
Sent: 06-16-2021 02:03 PM
From: Jaya Santosh Kumar Patchipulusu
Subject: Which table stores Reports details
I'm looking for table that stores reports( Reports and Jobs) related information, I got the table that stores Jobs info (CMN_SCH_JOB_DEFINITIONS).