query re writing

 Hi All,

can the query be re written in anyother efficientt ways?

SELECT A.BUSINESS_UNIT_GL, A.JOURNAL_ID, A.ACCOUNT, A.CHARTFIELD1, A.PRODUCT, A.DEPTID, A.BUSINESS_UNIT_PC, A.PROJECT_ID, A.ACTIVITY_ID, A.RESOURCE_TYPE, A.RESOURCE_CATEGORY, A.RESOURCE_SUB_CAT, A.ANALYSIS_TYPE, A.MONETARY_AMOUNT, A.CURRENCY_CD, A.DESCR1, A.EX_DOC_ID, TO_CHAR(A.TRANS_DT,'YYYY-MM-DD'), A.NAME, A.LINE_NBR, TO_CHAR(A.ACCOUNTING_DT,'YYYY-MM-DD'), A.ACCOUNTING_PERIOD, A.FISCAL_YEAR, TO_CHAR(B.APPROVAL_DT,'YYYY-MM-DD'), TO_date( TO_CHAR(B.APPROVAL_DT,'YYYY-MM-DD'),'YYYY-MM-DD')-TO_DATE( TO_CHAR(A.TRANS_DT,'YYYY-MM-DD'),'YYYY-MM-DD')