ERPstuff - Oracle EBS Community

i know all that steps but i want to know how get account description from db tables

thanks for your reply but if i want to make acustom report
and i want to see account description what asuitable query for that

what is fsg tool
please i wait your reply

u can use this solution
i hope it useful
select decode(trunc(110.5),0,'ZERO',to_char(to_date(trunc(110.5),'J'),'JSP'))
||' AND ' || decode(trunc(mod(110.5,1)*100),0,'ZERO',
to_char(to_date(trunc(mod(110.5,1)*100),'J'),'JSP'))||' '||'Only' into m
from dual;

i want to make report
to get gl oaccount(segment and description)
like that
1.0000.101.200
company.dept.cc
and so on