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

sql query controlling settings defined on a given project in PPM v7.5

Highlighted
dokhelar
Occasional Contributor

sql query controlling settings defined on a given project in PPM v7.5

Hi
Has someone written a sql query controlling settings defined on a given project, in PPM v7.5 ?
My need = sql query to control the 'Cost and Effort settings' of the projects, specially the settings related to financial managment =
flag 'Allow capitalized costs on this project '
flag 'Enable Financial Management for Work Plan'
rule defined for Planned costs
rule defined for Actual labor costs on the work plan
rule for Roll up actual costs from the work plan into the project budget

Who knows the Oracle tables where these information are stored ?
François
//Add this to "OnDomLoad" event