Projects Tables in oracle fusion

Projects Tables in oracle fusion

In this post , We will be discuss about Projects Tables in oracle fusion. Project tables helps to project the oracle fusion project details. We will get the complete information about projects in these oracle fusion tables. We do use these tables in oracle fusion , to develop the custom BIP oracle fusion project reports. Please find below the detail about Projects Tables in oracle fusion.

4 Important Projects Tables in oracle fusion

1.PJF_PROJECTS_ALL_VL
2.PJF_TASKS_V
3.PJC_EXP_ITEMS_ALL
4.PJF_EXP_TYPES_TL

PJF_PROJECTS_ALL_VL:- 

This table do store basic information about Projects in oracle fusion.

PJF_TASKS_V  :- 

This table do store Project task related informations in oracle fusion.

PJC_EXP_ITEMS_ALL :- 

This table do store the Project Expenditure Item informations in oracle fusion.

PJF_EXP_TYPES_TL :- 

This table do store the Project Expenditure type Information's in oracle fusion.

Project Details SQL Query Using Projects Tables in oracle fusion

select PPA.SEGMENT1 PROJECT#
,PPA.NAME PROJECT_NAME
,PPA.DESCRIPTION PROJECT_DESCRIPTION
,PPA.START_DATE PROJECT_START_DATE
,PPA.COMPLETION_DATE PROJECT_COMPLETION_DATE
,PPA.CLOSED_DATE
,PTV.TASK_NUMBER PROJECT_TASK_NUMBER
,PTV.TASK_ID TASK_ID
,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 PPA.SEGMENT1