MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
SELECT pa.segment1 proj, pa.name proj_name , pa.project_type proj_type, max(pdi.invoice_date) inv_dt, (pap.last_name || ' ' || pap.first_name) people_name ,pag.agreement_num agg_num, pag.agreement_type agg_type,ra.customer_number cust_num,ra.customer_name cust_name FROM pa_projects_all pa, pa_draft_invoices_all pdi, per_all_people_f pap, pa_agreements_all pag, ra_customers ra WHERE pa.project_status_code = 'ACTIVE' AND pa.project_type NOT IN ('B\&P GOVERNMENT', 'CAPITAL', 'EAC', 'ASSESSED', 'UNBURDENED' ,'B\&P COMMERCIAL', 'B\&P CPFF COMMERCIAL') AND pdi.project_id = pa.project_id AND pdi.released_by_person_id = pap.person_id and ra.customer_id=pag.customer_id and (exists (select project_id from pa_expenditure_items_all where project_id = pa.project_id) or exists (select project_id FROM pa_events where project_id = pa.project_id)) group by pa.segment1, pa.name, pa.project_type,pdi.invoice_date, pap.last_name,pap.first_name,pag.agreement_num,pag.agreement_num, pag.agreement_type ,ra.customer_number,ra.customer_name;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|how to find out the count of records based on the subfolders paths||11||39|
|SQL Workhours Count beetween Workhours||3||39|
|I tried to perform dml in a table for auditing who perform dml where a after dml trigger also exists in the same table as per rule i tried to handel with autonomous_transaction but still cant perform.||7||38|
|plsql job on oracle||18||73|