VIEW: APPS.IGW_PRPO_CATEGORY_AMTS_V

Source

View Text - Preformatted

SELECT ib.proposal_id , ib.budget_period_id , 'CC' period_type , ib.start_date , ir.proposal_budget_category_code , ir.proposal_budget_category , ir.proposal_budget_category description , ir.period_total_direct_cost , 12 period_months , null percent_dollar_flag , ir.eb_total from igw_report_budget ir , igw_budget_periods ib , igw_budgets ibd WHERE ibd.proposal_id = ib.proposal_id and ibd.version_id = ib.version_id and ib.proposal_id = ir.proposal_id and ib.version_id = ir.version_id and ib.budget_period_id = ir.budget_period_id and ir.proposal_form_number = ibd.proposal_form_number and ir.proposal_budget_category_code IN (select budget_category_code from igw_report_budget_seed where proposal_form_number = ibd.proposal_form_number UNION select distinct proposal_budget_category_code from igw_report_budget_seed where proposal_form_number = ibd.proposal_form_number) union select ibp.proposal_id , ibp.budget_period_id , 'CC' period_type , ibp.start_date , ibd.budget_category_code , fl.meaning , ibd.line_item_description description , ibd.line_item_cost , 12 period_months , 'DO' percent_dollar_flag , null eb_total from igw_budgets ib , igw_budget_periods ibp , igw_budget_details ibd , fnd_lookups fl where ib.proposal_id = ibp.proposal_id and ib.final_version_flag = 'Y' and ib.version_id = ibp.version_id and ibp.proposal_id = ibd.proposal_id and ibp.version_id = ibd.version_id and ibp.budget_period_id = ibd.budget_period_id and ibd.budget_category_code = fl.lookup_code and fl.lookup_type = 'IGW_BUDGET_CATEGORY'

View Text - HTML Formatted

SELECT IB.PROPOSAL_ID
, IB.BUDGET_PERIOD_ID
, 'CC' PERIOD_TYPE
, IB.START_DATE
, IR.PROPOSAL_BUDGET_CATEGORY_CODE
, IR.PROPOSAL_BUDGET_CATEGORY
, IR.PROPOSAL_BUDGET_CATEGORY DESCRIPTION
, IR.PERIOD_TOTAL_DIRECT_COST
, 12 PERIOD_MONTHS
, NULL PERCENT_DOLLAR_FLAG
, IR.EB_TOTAL
FROM IGW_REPORT_BUDGET IR
, IGW_BUDGET_PERIODS IB
, IGW_BUDGETS IBD
WHERE IBD.PROPOSAL_ID = IB.PROPOSAL_ID
AND IBD.VERSION_ID = IB.VERSION_ID
AND IB.PROPOSAL_ID = IR.PROPOSAL_ID
AND IB.VERSION_ID = IR.VERSION_ID
AND IB.BUDGET_PERIOD_ID = IR.BUDGET_PERIOD_ID
AND IR.PROPOSAL_FORM_NUMBER = IBD.PROPOSAL_FORM_NUMBER
AND IR.PROPOSAL_BUDGET_CATEGORY_CODE IN (SELECT BUDGET_CATEGORY_CODE
FROM IGW_REPORT_BUDGET_SEED
WHERE PROPOSAL_FORM_NUMBER = IBD.PROPOSAL_FORM_NUMBER UNION SELECT DISTINCT PROPOSAL_BUDGET_CATEGORY_CODE
FROM IGW_REPORT_BUDGET_SEED
WHERE PROPOSAL_FORM_NUMBER = IBD.PROPOSAL_FORM_NUMBER) UNION SELECT IBP.PROPOSAL_ID
, IBP.BUDGET_PERIOD_ID
, 'CC' PERIOD_TYPE
, IBP.START_DATE
, IBD.BUDGET_CATEGORY_CODE
, FL.MEANING
, IBD.LINE_ITEM_DESCRIPTION DESCRIPTION
, IBD.LINE_ITEM_COST
, 12 PERIOD_MONTHS
, 'DO' PERCENT_DOLLAR_FLAG
, NULL EB_TOTAL
FROM IGW_BUDGETS IB
, IGW_BUDGET_PERIODS IBP
, IGW_BUDGET_DETAILS IBD
, FND_LOOKUPS FL
WHERE IB.PROPOSAL_ID = IBP.PROPOSAL_ID
AND IB.FINAL_VERSION_FLAG = 'Y'
AND IB.VERSION_ID = IBP.VERSION_ID
AND IBP.PROPOSAL_ID = IBD.PROPOSAL_ID
AND IBP.VERSION_ID = IBD.VERSION_ID
AND IBP.BUDGET_PERIOD_ID = IBD.BUDGET_PERIOD_ID
AND IBD.BUDGET_CATEGORY_CODE = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'IGW_BUDGET_CATEGORY'