Tables & Views:
PJF_PROJECTS_ALL_VL -- Project Information
PJF_TASKS_V -- Task Information
PJC_EXP_ITEMS_ALL -- Expenditure Item
PJF_EXP_TYPES_TL -- Expenditure Types
Query to get Project,Task and Organization information:
select to_char(ppa.project_id) PROJECT_ID
,to_char(PPA.SEGMENT1) PROJECT_NUMBER
,PPA.NAME PROJECT_NAME
,PPA.DESCRIPTION
,PPA.START_DATE
,PPA.COMPLETION_DATE
,PPA.CLOSED_DATE
,PTV.TASK_NUMBER
,to_char(PTV.TASK_ID) TASK_ID
,to_Char(PPA.CARRYING_OUT_ORGANIZATION_ID) ORGANIZATION_ID
,HRU.NAME ORGANIZATION_NAME
from
PJF_PROJECTS_ALL_VL PPA
,PJF_TASKS_V PTV
,HR_ORGANIZATION_UNITS HRU
where 1=1
and PPA.PROJECT_ID=PTV.PROJECT_ID
and PPA.CARRYING_OUT_ORGANIZATION_ID=HRU.ORGANIZATION_ID(+)
order by to_char(ppa.project_id);