DBA Data[Home] [Help]

VIEW: APPS.PA_PROJECTS_DIST_RULE_V

Source

View Text - Preformatted

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