Monday, 27 March 2017

Project Basic Info qurey in R12

/* Formatted on 3/27/2017 2:35:45 PM (QP5 v5.114.809.3010) */
SELECT   proj.carrying_out_organization_name project_organization,
         proj.segment1 project_number,
         proj.name Project_Short_Name,
         proj.city,
         proj.region,
         proj.long_name project_long_name,
         proj.start_date transaction_start_date,
         proj.target_finish_date Target_Finish_Date,
         proj.project_type,
         proj.project_type_class_code,
         proj.completion_date,
         proj.public_sector_flag,
         proj.project_status_name,
         proj.project_status_code,
         proj.wf_status_code,
         proj.country_name,
         proj.country_code,
         proj.record_version_number,
         proj.target_start_date,
         proj.scheduled_start_date,
         proj.scheduled_finish_date,
         proj.actual_start_date,
         proj.actual_finish_date,
         opr.name operating_unit
  FROM   pa_projects_prm_v proj, hr_all_organization_units_vl opr
 WHERE   proj.org_id = opr.organization_id
         AND proj.project_id = :p_project_id;

No comments:

Post a Comment