Error in running query because of SQL Error, Code=1858, Message=ORA-01858
I have created a view that uses the sql below -
SELECT DISTINCT a.emplid
, d.name
, a.g_form_id
, k.g_form_status
, d.g_I9V3_COMPL_DTTM
, a.deptid
, a.business_unit
FROM sysadm.ps_g_form_hire a
, sysadm.ps_g_formlist b
, sysadm.ps_g_formlist k
, sysadm.ps_G_FORM_CHKL ch
, sysadm.ps_G_I9V3_I9_DTLS d
WHERE a.g_form_id = b.g_form_id
AND k.g_form_type = 'CHECKLIST'
AND ch.g_form_id = k.g_form_id
AND a.g_form_id = ch.g_Hire_form_id