DARTS : UM_HR_ACCTG_VW - HR Acctg Line with cf descr

SELECT a.run_dt
 , a.seqnum
 , a.line_nbr
 , a.accounting_dt
 , a.accounting_period
 , a.appl_jrnl_id
 , a.audit_actn
 , a.budget_dt
 , a.budget_line_status
 , a.budget_ref
 , a.business_unit
 , a.business_unit_gl
 , a.currency_cd
 , a.deptid
 , b.descr
 , a.fund_code
 , a.account
 , c.descr
 , a.class_fld
 , a.program_code
 , d.descr
 , a.project_id
 , e.descr
 , a.operating_unit
 , f.descr
 , a.fiscal_year
 , a.foreign_amount
 , a.foreign_currency
 , a.gl_distrib_status
 , a.in_process_flg
 , a.jobcode
 , a.journal_date
 , a.journal_id
 , a.journal_line
 , a.journal_line_date
 , a.jrnl_ln_ref
 , a.kk_amount_type
 , a.ledger
 , a.ledger_group
 , a.line_Descr
 , a.monetary_amount
 , a.off_cycle
 , a.open_item_status
 , a.pay_end_dt
 , a.paygroup
 , a.position_nbr
 , a.process_instance
 , a.rate_div
 , a.rate_mult
 , a.rt_type
 , a.run_id
 , a.statistic_amount
 , a.statistics_code
 , a.um_award_flag
 , a.um_code
 , a.um_code_desc
 , a.um_code_type
 , a.um_deptid_hr
 , g.um_hr_dept_descr
 , a.use_distribution
  FROM ps_um_hr_acctg_ln a
  , ps_dept_tbl b
  , ps_gl_account_tbl c
  , ps_program_tbl d
  , ps_project e
  , ps_oper_unit_tbl f
  , ps_um_hr_xref g
 WHERE b.setid = 'UMSYS'
   AND a.deptid = b.deptid
   AND b.effdt = (
 SELECT MAX(b_ed.effdt)
  FROM ps_dept_tbl b_ed
 WHERE b.setid = b_ed.setid
   AND b.deptid = b_ed.deptid
   AND b_ed.effdt <= a.accounting_dt)
   AND c.setid = 'UMSYS'
   AND c.account = a.account
   AND c.effdt = (
 SELECT MAX(c_ed.effdt)
  FROM ps_gl_account_tbl c_ed
 WHERE c.setid = c_ed.setid
   AND c.account = c_ed.account
   AND c.effdt <= a.accounting_dt)
   AND d.setid(+) = 'UMSYS'
   AND d.program_code(+) = a.program_code
   AND (d.effdt = (
 SELECT MAX(d_ed.effdt)
  FROM ps_program_tbl d_ed
 WHERE d.setid = d_ed.setid
   AND d.program_code = d_ed.program_code
   AND d_ed.effdt <= a.accounting_dt)
    OR d.effdt IS NULL)
   AND e.business_unit(+) = 'UMSYS'
   AND e.project_id (+) = a.project_id
   AND f.setid(+) = 'UMSYS'
   AND f.operating_unit(+) = a.operating_unit
   AND (f.effdt = (
 SELECT MAX(f_ed.effdt)
  FROM ps_oper_unit_tbl f_ed
 WHERE f.setid = f_ed.setid
   AND f.operating_unit = f_ed.operating_unit
   AND f_ed.effdt <= a.accounting_dt)
    OR f.effdt IS NULL)
   AND a.um_deptid_hr = g.um_hr_deptid(+);