eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGW_BUDGET_LINE_CATEGORY_V

Source

View Text - Preformatted


SELECT pbd.proposal_id , pbd.version_id , pbd.budget_period_id , pbd.line_item_id , pbd.line_item_cost , pbd.expenditure_type , pbd.line_item_description , pbd.budget_category_code , fl.meaning budget_category , pbd.budget_justification from igw_budget_details pbd , igw_budget_expenditures_v et , igw_lookups_v fl WHERE pbd.expenditure_type = nvl(et.budget_expenditure,pbd.expenditure_type) and pbd.expenditure_category_flag = et.expenditure_category_flag and pbd.budget_category_code = fl.lookup_code and fl.lookup_type = 'IGW_BUDGET_CATEGORY'

View Text - HTML Formatted

SELECT PBD.PROPOSAL_ID
, PBD.VERSION_ID
, PBD.BUDGET_PERIOD_ID
, PBD.LINE_ITEM_ID
, PBD.LINE_ITEM_COST
, PBD.EXPENDITURE_TYPE
, PBD.LINE_ITEM_DESCRIPTION
, PBD.BUDGET_CATEGORY_CODE
, FL.MEANING BUDGET_CATEGORY
, PBD.BUDGET_JUSTIFICATION
FROM IGW_BUDGET_DETAILS PBD
, IGW_BUDGET_EXPENDITURES_V ET
, IGW_LOOKUPS_V FL
WHERE PBD.EXPENDITURE_TYPE = NVL(ET.BUDGET_EXPENDITURE
, PBD.EXPENDITURE_TYPE)
AND PBD.EXPENDITURE_CATEGORY_FLAG = ET.EXPENDITURE_CATEGORY_FLAG
AND PBD.BUDGET_CATEGORY_CODE = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'IGW_BUDGET_CATEGORY'