SELECT DISTINCT A.PROJECT_TYPE_CLASS_CODE , A.ACCUM_CATEGORY_CODE , B.MEANING FROM PA_LOOKUPS B , PA_ACCUM_COLUMNS A WHERE A.ACCUM_CATEGORY_CODE = B.LOOKUP_CODE AND B.LOOKUP_TYPE = 'ACCUMULATION_CATEGORY'
View Text - HTML Formatted
SELECT DISTINCT A.PROJECT_TYPE_CLASS_CODE , A.ACCUM_CATEGORY_CODE , B.MEANING FROM PA_LOOKUPS B , PA_ACCUM_COLUMNS A WHERE A.ACCUM_CATEGORY_CODE = B.LOOKUP_CODE AND B.LOOKUP_TYPE = 'ACCUMULATION_CATEGORY'