SELECT DISTINCT segment1 
                Project#, 
                b.transaction_source, 
                (SELECT SUM(raw_cost) 
                 FROM   pa_expenditure_items_all PE, 
                        pa_tasks PT 
                 WHERE  PE.task_id = pt.task_id 
                        AND pt.task_number = 'RST' 
                        AND pe.project_id = a.project_id 
                        AND pe.attribute1 IS NULL 
                        AND pe.attribute2 IS NULL 
                        AND PE.org_id = 170 
                        AND pe.project_id = pt.project_id 
                        AND pe.transaction_source = b.transaction_source 
                        AND Trunc(pE.creation_date) > '01-OCT-2015')       "RST" 
                , 
                (SELECT SUM(raw_cost) 
                 FROM   pa_expenditure_items_all PE, 
                        pa_tasks PT 
                 WHERE  PE.task_id = pt.task_id 
                        AND pt.task_number = 'RGT' 
                        AND pe.project_id = a.project_id 
                        AND pe.attribute1 IS NULL 
                        AND pe.attribute2 IS NULL 
                        AND PE.org_id = 170 
                        AND pe.project_id = pt.project_id 
                        AND pe.transaction_source = b.transaction_source 
                        AND Trunc(pE.creation_date) > '01-OCT-2015')       "RGT" 
                , 
                (SELECT SUM(raw_cost) 
                 FROM   pa_expenditure_items_all PE, 
                        pa_tasks PT 
                 WHERE  PE.task_id = pt.task_id 
                        AND pt.task_number = 'RGN' 
                        AND pe.project_id = a.project_id 
                        AND pe.attribute1 IS NULL 
                        AND pe.attribute2 IS NULL 
                        AND PE.org_id = 170 
                        AND pe.project_id = pt.project_id 
                        AND pe.transaction_source = b.transaction_source 
                        AND Trunc(pE.creation_date) > '01-OCT-2015')       "RGN" 
                , 
                (SELECT SUM(raw_cost) 
                 FROM   pa_expenditure_items_all PE, 
                        pa_tasks PT 
                 WHERE  PE.task_id = pt.task_id 
                        AND pt.task_number NOT IN ( 'RGN', 'RGT', 'RST' ) 
                        AND pe.project_id = a.project_id 
                        AND PE.org_id = 170 
                        AND pe.project_id = pt.project_id 
                        AND pe.transaction_source = b.transaction_source 
                        AND Trunc(pE.creation_date) > '01-OCT-2015') 
                "All Other Tasks", 
                Decode(A.project_status_code, '1020', 'Yes', 
                                              'No') 
                "READY TO LIQUIDATE FLAG Y/N", 
                A.project_type, 
                a.attribute4 
                "IPS#", 
                (SELECT short_text 
                 FROM   fnd_documents_short_text 
                 WHERE  media_id IN (SELECT media_id 
                                     FROM   fnd_attached_docs_form_vl 
                                     WHERE  category_description = 
                                            'Project Country, State and City' 
                                            AND entity_name = 'PA_PROJECTS' 
                                            AND datatype_name = 'Short Text' 
                                            AND pk1_value = A.project_id)) 
                "COUNTRY", 
                (SELECT SUM(raw_cost) 
                 FROM   pa_expenditure_items_all PE 
                 WHERE  pe.project_id = a.project_id 
                        AND Trunc(pE.creation_date) > '01-OCT-2015' 
                        AND PE.org_id = 170) 
                "QTR to Date Total of All Tasks", 
                (SELECT SUM(raw_cost) 
                 FROM   pa_expenditure_items_all PE 
                 WHERE  pe.project_id = a.project_id 
                        AND PE.org_id = 170) 
                "PROJECT TOTAL OF ALL TASKS" 
FROM   pa_projects_all a, 
       pa_expenditure_items_all b 
WHERE  A.project_type IN ( 'PPS_Extended_Scope', 'PPS_EOM_Direct', 
                           'PPS_EOM_Indirect' ) 
       AND a.project_id = b.project_id 
       ---and a.segment1='303117' 
       AND a.org_id = 170 ---and trunc(A.creation_date)>'01-JAN-2015' 
       AND a.project_status_code NOT IN ( 
           'CLOSED', 'PENDING_CLOSE', 'UNAPPROVED' ) 
-- 

SUM(CASE WHEN AND pt.task_number = 'RST' 
              AND pe.attribute1 IS NULL 
              AND pe.attribute2 IS NULL 
              AND pe.transaction_source = b.transaction_source 
              AND Trunc(pE.creation_date) > to_date('01-OCT-2015', 'DD-MON-YYYY') 
         THEN raw_cost
    END) as "RST",
SUM(CASE WHEN AND pt.task_number = 'RGT' 
              AND pe.attribute1 IS NULL 
              AND pe.attribute2 IS NULL 
              AND pe.transaction_source = b.transaction_source 
              AND Trunc(pE.creation_date) > to_date('01-OCT-2015', 'DD-MON-YYYY') 
         THEN raw_cost
    END) as "RGT",

Provided below are:

1. the first chapter of the book.  Reading this will help you decide if the book is something you are interested in before you spend money on it.
2. the scripts from the book.  You can use these in your tuning work regardless of it you purchase the book or not later.  These are free.
3. an organizational document that will help you record the significant events of a SQL Tuning session so you can explain to someone else later how you solved a problem.
4. a brief description of the kind of info you will want to provide to ORAFaq, when you are looking for detailed tuning help.