Project Management

Get Involved. Join the Conversation.

Topic

    Michelle Swisher
    Table Name where Project Notes reside
    Topic posted September 20, 2018 by Michelle SwisherRed Ribbon: 250+ Points, tagged Grants Management, Project Billing & Revenue, Project Contracts, Project Management, Project Performance Reporting 
    99 Views, 2 Comments
    Title:
    Table Name where Project Notes reside
    Summary:
    Table Name where Project Notes reside
    Content:

    Does anyone know the table name where Project Notes reside?  We are needing to create an OTBI report that outputs the Project Notes that have been entered on the Project Financial Management Page for a Project.

    Version:
    Currently on R12 but will updating to R13 in early October 2018
    Image:
    Document:

    Comment

     

    • Alexandru Eremia - Oracle


      select note_txt from zmm_notes where SOURCE_OBJECT_UID in (select project_id from pjf_projects_all_tl where name='project name')
       

      Regards,

      Alex

    • Isaline Nguyen

      Hello,

      What did you use in the query to pull the project description? I found project ID and project number but I cannot seem to pinpoint the right table for description.

      Thank you,

      Regards,

      Isaline