DBA Data[Home] [Help]

VIEW: APPS.IGW_REPORT_BUDGET_SEED_V

Source

View Text - Preformatted

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'
View Text - HTML Formatted

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'