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 
  

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>