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|
Category: OracleSaaSQueries