SELECT distinct il.meaning proposal_budget_category , proposal_budget_category_code , proposal_form_number from igw_report_budget_seed ir , igw_lookups_v il WHERE ir.proposal_budget_category_code = il.lookup_code and il.lookup_type = 'IGW_BUDGET_CATEGORY'
SELECT DISTINCT IL.MEANING PROPOSAL_BUDGET_CATEGORY
, PROPOSAL_BUDGET_CATEGORY_CODE
, PROPOSAL_FORM_NUMBER
FROM IGW_REPORT_BUDGET_SEED IR
, IGW_LOOKUPS_V IL
WHERE IR.PROPOSAL_BUDGET_CATEGORY_CODE = IL.LOOKUP_CODE
AND IL.LOOKUP_TYPE = 'IGW_BUDGET_CATEGORY'
|
|
|