SELECT A.BUS_OBJ_CD, B.DESCR , A.*
FROM F1_BUS_OBJ A, F1_BUS_OBJ_L B
WHERE
A.BUS_OBJ_CD = B.BUS_OBJ_CD
AND B.LANGUAGE_CD = :LANGUAGE
--AND trim(A.MAINT_OBJ_CD) = 'INSERT_MAINTENANCE_OBJECT_CD'
uploaded by Nuno Rodrigues