PPM SQL : Querying for Projects & Classifications
Use the below query to fetch list of Projects & key data needed by Business Analysts SELECT (SELECT name FROM HR_ORGANIZATION_UNITS_F_TL WHERE organization_id = ppp.ORG_ID AND LANGUAGE = ‘US’) Business_Unit_Name ,(SELECT name FROM pjf_projects_all_vl p1WHERE p1.project_id = ppp.created_from_project_id) Project_Template ,(SELECT project_type FROM pjf_project_types_vlWHERE project_type_id = ppp.project_type_id) Project_Type ,SEGMENT1 Project_Number ,NAME Project_Name ,DESCRIPTION Project_Description ,(SELECT […]
PPM SQL : Querying for Projects & Classifications Read More »