Skip to Main Content

Putting comments from Planning in a report via SQL

791389Aug 13 2010 — edited Aug 14 2010
Has anyone built a report in Web Analysis using the SQL Spreadsheet to report comments entered in via the Planning Application. I found three tables in the Planning repository that contain notes, two of them tie together but the third is too generic and I have not been able to find the reference data.
The tables are: hsp_cell_note, hsp_cell_note_item, hsp_text_cell_value. I'm planning on writing a PL/SQL procedure that loads the data into a summary table with reference members but wanted to check if this has already been done and someone could share the "How" it was done.

Thanks in Advance!