we have multiple queries that stopped working due to the changes made in the database regarding the portfolio tables. We now are struggeling to find all the info (fields) in the new structure.
one of our problems is; we don't know where to locate the field pfm_portfolios.bdgt_cst_total in the following query:
SELECT DISTINCT u.unique_name AS kpl,
FROM (prj_obs_associations a
RIGHT JOIN prj_obs_units u
ON a.unit_id = u.ID)
INNER JOIN prj_obs_types t
ON u.type_id = t.ID
INNER JOIN inv_investments p
ON a.record_id = p.ID
INNER JOIN pfm_Investments pfc
ON p.id = pfc.investment_id
INNER JOIN pfm_portfolios pf
ON pfc.PORTFOLIO_ID = pf.ID
WHERE t.unique_name = 'obs_m_sth'
AND a.table_name = 'SRM_PROJECTS'
AND pfc.ODF_OBJECT_CODE = 'project'
AND TO_CHAR (pf.start_date, 'YYYY') = TO_CHAR (SYSDATE, 'YYYY');
can you help us?