SELECT d.org_id ,r.distribution_rule ,r.meaning ,r.description ,d.project_type FROM pa_project_type_distributions d ,pa_distribution_rules r where d.distribution_rule =r.distribution_rule ORDER BY r.meaning
View Text - HTML Formatted
SELECT D.ORG_ID , R.DISTRIBUTION_RULE , R.MEANING , R.DESCRIPTION , D.PROJECT_TYPE FROM PA_PROJECT_TYPE_DISTRIBUTIONS D , PA_DISTRIBUTION_RULES R WHERE D.DISTRIBUTION_RULE =R.DISTRIBUTION_RULE ORDER BY R.MEANING