Query to get Projects Program name in Oracle Apps R12 - Orapoint

This query will help you to get project name, project number, program name, program number in Oracle R12 Application.

select  SEGMENT1 project_number,
         NAME project_name,
         SUBSTR (segment1,1,2) Program_number,
         (select  DESCRIPTION
         from    FND_FLEX_VALUES_VL
         where   FLEX_VALUE_MEANING like '0%' 
             and FLEX_VALUE_MEANING = ppa.segment1) program_name
 from    pa_projects_all ppa;