I am working on building a portlet to list the processes against the object. Is there any way to obtain the custom processes name that is running against the object ? I would need the table name
If I am understanding what you are trying to do correctly, this should do the trick:
select ccn.name from bpm_run_processes brp, bpm_def_process_versions bdpv, bpm_def_processes bdp, cmn_captions_nls ccn where brp.id = your_running_process_instance_idand brp.process_version_id = bdpv.idand bdpv.process_id = bdp.idand bdp.id = ccn.pk_idand ccn.table_name = 'BPM_DEF_PROCESSES'and ccn.language_code = 'en'
Retrieving data ...