Project Expenditure Cost Distribution Lines with Transfer Status Code

SELECT ppa.segment1, pt.task_number, pcdla.expenditure_item_id, pcdla.line_num,
   DECODE (pcdla.transfer_status_code, 'P', 'Pending', 'V', 'Received', 'A', 'Accepted') transfer_status, 'V' new_transfer_status_code
  FROM pa_cost_distribution_lines_all pcdla, pa_projects_all ppa, pa_tasks pt
 WHERE ppa.project_id = pcdla.project_id
   AND pt.task_id = pcdla.task_id