Query to get Project and Tasks Details in Oracle Fusion ERP

SELECT 
  ppa.project_id,
  ppa.segment1 project_number, 
  ppat.name project_name ,
  PTV.TASK_NUMBER,
  PTV.TASK_NAME,
  PTV.DESCRIPTION TASK_DESCRIPTION,
  pptt.project_type 
FROM 
  PJF_PROJECTS_ALL_B ppa, 
  PJF_PROJECTS_ALL_TL ppat,
  PJF_TASKS_V PTV ,
  PJF_PROJECT_TYPES_TL PPTT
where 
  1 = 1 
  AND ppa.project_id = ppat.project_id 
  AND ppat.language = USERENV('LANG')
  and ppa.project_id = ptv.project_id 
  and ppa.project_type_id = pptt.project_type_id 
  AND pptt.language = USERENV('LANG')
  AND ppa.project_id = :P_PROJECT_ID