Lookup Type :- PSP_SUSP_AC_ERRORS
Query :-
SELECT fl.MEANING Error_message,
status,
gli.user_je_source_name source_name,
gli.user_je_category_name category_name,
gli.currency_code currency_code,
gli.accounting_date accounting_date,
gli.period_name period_name,
gli.reference1 batch_name,
gli.attribute1,
gli.je_line_num line_num,
gli.entered_dr,
gli.entered_cr,
gli.reference10 line_description,
gli.reference21 ramco_reference_id
FROM gl_interface gli, fnd_lookups fl
WHERE REGEXP_SUBSTR (gli.status, '[^-,]+',1,1) = fl.lookup_code
AND fl.lookup_type = 'PSP_SUSP_AC_ERRORS'
AND gli.reference1 = 'Depreciation PREPIAD_BOOK/29109'