How to derive projects, project customer details using select statement

Oracle Projects fully integrates with Oracle Receivables to process your invoices and track customer payments. Oracle Projects generates draft invoices and uses Oracle Receivables to collect payments for the project invoices and transfer the accounting transactions to Oracle General Ledger. When you transfer invoices to Oracle Receivables, Oracle Projects also maintains project balances of unbilled receivables and unearned revenue and creates accounting transactions for these amounts.

Following query will fetch details of Oracle projects, project customers,project organization and project key members based on project role type:-

SELECT pp.project_id, pp.segment1 project_number, pp.name project_name,
               pp.project_type, pp.project_status_code, pp.start_date prj_start_date,
               pp.completion_date prj_end_date, hou.name prj_orgn_name,
               po.organization_id prj_orgn_id, hc.cust_account_id,
               hc.account_number cust_account_number,
               NVL (hc.account_name, hp.party_name) prj_customer_name,
               rol.meaning km_project_role_type_name, hc.account_name,
               pppn.project_role_type km_project_role_type, ppxn.person_id person_id,
               ppxn.full_name km_employee_name,
               ppxn.employee_number km_employee_number,
               pppn.start_date_active km_start_date, pppn.end_date_active km_end_date
  FROM pa_projects_all pp,
               pa_project_customers pc,
               pa_all_organizations po,
               hr_all_organization_units hou,
               hz_cust_accounts hc,
               hz_parties hp,
               pa_project_players pppn,
               per_people_x ppxn,
               pa_project_role_types rol
WHERE hc.cust_account_id = pc.customer_id
     AND hou.organization_id = po.organization_id
     AND po.organization_id = pp.carrying_out_organization_id
     AND pp.project_id = pc.project_id
     AND pppn.project_id = pp.project_id
     AND pppn.person_id = ppxn.person_id
     AND pppn.project_role_type = rol.project_role_type
     AND hp.party_id = hc.party_id
     AND rol.project_role_type = :p_project_role
     AND pp.segment1 = NVL (:p_project_num, pp.segment1)
     AND NVL (pppn.end_date_active, SYSDATE + 1) >= SYSDATE;