Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Project Settings

SOLVED
Go to solution
Highlighted
imeireles
Acclaimed Contributor

Project Settings

Hello,

 

Someone knows which tables stores the informations about project type settings like microsoft project integration. When the user sets the option PPM controls all shared work plan information.

 

I need to know these informations for close the work plan automatically.

 

I'm using 9.14 version.

 

Thank you.

 

Best Regards.

 

 

1 REPLY
Utkarsh_Mishra
Honored Contributor
Solution

Re: Project Settings

Project setting are stored in itg_settings_attributes , itg_settings_cont_attrs  and
itg_settings_containers, below are few examples

 

select p.project_name ,p.pfm_request_id, ps.attribute_name,ps.attribute_value, KR.STATUS_CODE
from pm_projects p
join pm_work_plans wp on (wp.project_id = p.project_id AND wp.entity_type = 'WORK_PLAN')
join wp_tasks t on (t.work_plan_id = wp.work_plan_id and t.sequence_number = 0)
join kdrv_project_setup ps on ps.source_id = t.task_id and ps.source_entity_id = 6
join kcrt_requests kr on (KR.REQUEST_ID = p.pfm_request_id
                        and KR.STATUS_CODE in ('IN_PROGRESS','NEW'))
where 1=1
--and p.project_id = 47677
and ps.attribute_name like 'CE.rollupCostsToBudget'
and ps.attribute_value in ('AUTO_LABOR_MANUAL_NONLABOR','AUTO_LABOR_AUTO_NONLABOR');

-------------------------------------------

select p.project_name ,p.pfm_request_id, ps.attribute_name,ps.attribute_value, KR.STATUS_CODE
from pm_projects p
join pm_work_plans wp on (wp.project_id = p.project_id AND wp.entity_type = 'WORK_PLAN')
join wp_tasks t on (t.work_plan_id = wp.work_plan_id and t.sequence_number = 0)
join kdrv_project_setup ps on ps.source_id = t.task_id and ps.source_entity_id = 6
join kcrt_requests kr on (KR.REQUEST_ID = p.pfm_request_id
                        and KR.STATUS_CODE in ('IN_PROGRESS','NEW'))
where 1=1
--and p.project_id = 49360 
and ps.attribute_name like 'CE.approvedByPM'
and ps.attribute_value in ('true');

 

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
//Add this to "OnDomLoad" event