Project Change Order Basic Information

/* Formatted on 10/3/2016 8:01:45 PM (QP5 v5.114.809.3010) */
SELECT   pci.ci_id,
         pci.summary Change_Order_Name,
         pci.ci_number Change_Order_Number,
         pci.description,
         pci.status_code,
         pcim.description
  FROM   pa_control_items pci, pa_ci_impacts pcim
 WHERE       project_id = :p_project_id
         AND pci.ci_id = :p_change_order_id
         AND pci.ci_id = pcim.ci_id
         AND pcim.impact_type_code = 'FINPLAN';