ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8D073420474A4911B05F49E4A573665FY select (select hou.name from hr_operating_units hou where x.org_id=hou.organization_id) operating_unit, x.fund_number budget_number, x.short_name budget_name, x.description budget_description, xxen_util.meaning(x.fund_type,'OZF_FUND_TYPE',682) budget_type, (select acv.category_name from ams_categories_vl acv where x.category_id=acv.category_id) budget_category, (select ausv.name from ams_user_statuses_vl ausv where x.user_status_id=ausv.user_status_id) budget_status, (select fav.short_name from ozf_funds_all_vl fav where x.parent_fund_id=fav.fund_id) parent_budget, (select jrrev.resource_name from jtf_rs_resource_extns_vl jrrev where x.owner=jrrev.resource_id) owner, x.start_date_active start_date, x.end_date_active end_date, x.currency_code_tc currency, x.original_amount original_budget, x.transfer_in_amount transfers_in, x.transfer_out_amount transfers_out, x.original_amount+x.transfer_in_amount-x.transfer_out_amount total, x.holdback_amount holdback, x.planned_amount planned, x.committed_amount committed, x.original_amount+x.transfer_in_amount-x.transfer_out_amount-x.holdback_amount-x.committed_amount available, x.recal_committed_amount recalculated_committed, x.utilized_amount utilized, x.earned_amount earned, x.paid_amount paid, x.earned_amount-x.paid_amount unpaid, xxen_util.concatenated_segments(x.accrued_liable_account) liability_account, xxen_util.concatenated_segments(x.ded_adjustment_account) adjustment_account, xxen_util.user_name(x.created_by) created_by, x.creation_date, xxen_util.user_name(x.last_updated_by) last_updated_by, x.last_update_date from ( select fav.*, nvl(decode(:rollup,'Y',fav.rollup_original_budget,fav.original_budget),0) original_amount, nvl(decode(:rollup,'Y',fav.rollup_transfered_in_amt,fav.transfered_in_amt),0) transfer_in_amount, nvl(decode(:rollup,'Y',fav.rollup_transfered_out_amt,fav.transfered_out_amt),0) transfer_out_amount, nvl(decode(:rollup,'Y',fav.rollup_holdback_amt,fav.holdback_amt),0) holdback_amount, nvl(decode(:rollup,'Y',fav.rollup_planned_amt,fav.planned_amt),0) planned_amount, nvl(decode(:rollup,'Y',fav.rollup_committed_amt,fav.committed_amt),0) committed_amount, nvl(decode(:rollup,'Y',fav.rollup_recal_committed,fav.recal_committed),0) recal_committed_amount, nvl(decode(:rollup,'Y',fav.rollup_utilized_amt,fav.utilized_amt),0) utilized_amount, nvl(decode(:rollup,'Y',fav.rollup_earned_amt,fav.earned_amt),0) earned_amount, nvl(decode(:rollup,'Y',fav.rollup_paid_amt,fav.paid_amt),0) paid_amount from ozf_funds_all_vl fav where fav.fund_type in ('FIXED','FULLY_ACCRUED') and (fav.org_id is null or fav.org_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU')) ) x where 1=1 order by operating_unit, x.fund_number OZF US OZF Budgets Trade Management budgets with the amounts of the budget checkbook, in the budget currency: original budget, transfers, holdback, planned, committed, available, utilized, earned, paid and unpaid. Total is the original budget plus transfers in less transfers out. Available is the total less holdback and committed. Unpaid is earned less paid. OZF Budget Utilization lists the accruals, adjustments and payments behind Utilized, Earned and Paid. Rollup Amounts shows the amounts of each budget including its child budgets, as the rollup view of the budget checkbook. Quotas are not included. Enginatics 1=1 :rollup 1 10 1=1 x.org_id in (select hou.organization_id from hr_operating_units hou where hou.name=:operating_unit) LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 2 20 1=1 x.fund_type=xxen_util.lookup_code(:budget_type,'OZF_FUND_TYPE',682) LOV custom select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='OZF_FUND_TYPE' and flvv.view_application_id=682 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and flvv.lookup_code in ('FIXED','FULLY_ACCRUED') order by flvv.meaning US Budget Type 3 30 1=1 x.category_id in (select acv.category_id from ams_categories_vl acv where acv.category_name=:budget_category) LOV custom select acv.category_name value, acv.description from ams_categories_vl acv where acv.arc_category_created_for='FUND' and acv.enabled_flag='Y' order by acv.category_name US Budget Category 4 40 1=1 x.short_name=:budget_name LOV custom select fav.short_name value, fav.fund_number description from ozf_funds_all_vl fav where fav.fund_type in ('FIXED','FULLY_ACCRUED') order by fav.short_name US Budget Name 5 50 1=1 x.user_status_id in (select ausv.user_status_id from ams_user_statuses_vl ausv where ausv.name=:status) LOV custom select ausv.name value, ausv.description from ams_user_statuses_vl ausv where ausv.system_status_type='OZF_FUND_STATUS' and ausv.enabled_flag='Y' order by ausv.name US Status 6 60 :rollup LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Rollup Amounts Show the amounts of each budget including its child budgets.