Query Project Agreement with Project Details.

SELECT d.customer_id,
ppc.customer_name,
d.agreement_type,
d.description agreement_desc,
d.CUSTOMER_ORDER_NUMBER,
AGREEMENT_NUM,TRUNC(D.CREATION_DATE) AGGREMENT__DATE,
TRUNC(D.LAST_UPDATE_DATE) AGREMENT_LAST_UPDATE_DATE,
SEGMENT1 PROJECT_NUMBER,
c.project_type,
LONG_NAME PROJECT_LONG_NAME,
ALLOCATED_AMOUNT,
TRUNC(PPF.CREATION_DATE) funding_creation_date,
TRUNC(PPF.LAST_UPDATE_DATE) funding_last_update_date,
PPF.FUNDING_CURRENCY_CODE,
PPF.PROJECT_CURRENCY_CODE,
PPF.PROJFUNC_CURRENCY_CODE,
PPF.PROJFUNC_ALLOCATED_AMOUNT,
submit_baseline_flag
FROM pa_project_fundings PPF,
pa_projects_all c,
pa_agreements_all d,
pa_project_customers_v ppc,
pa_project_contacts_v ppct
WHERE PPF.project_id = c.project_id
AND PPF.agreement_id = d.agreement_id
and ppc.project_id = c.project_id
and c.project_id = ppct.project_id (+)
AND c.project_type = ‘TMIND Contract’;