SELECT proj.segment1 project#, proj.NAME proj_name,
hc.account_number customer_account_number#
FROM pa_projects_all proj, pa_project_customers pc, hz_cust_accounts hc
WHERE 1 = 1
AND proj.project_id = pc.project_id
AND pc.customer_id = hc.cust_account_id
hc.account_number customer_account_number#
FROM pa_projects_all proj, pa_project_customers pc, hz_cust_accounts hc
WHERE 1 = 1
AND proj.project_id = pc.project_id
AND pc.customer_id = hc.cust_account_id
No comments:
Post a Comment