ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F41E3869E053B46B63588994Y select a.budget_revision_id, b.budget_group_name, e.set_of_books_id, a.code_combination_id, a.account_type, a.currency_code, a.gl_period_name, a.gl_budget_version_id, c.concatenated_segments, c.description, d.start_date, b.submission_date, fl.meaning transaction_type, nvl(decode(a.revision_type, 'I', decode(a.revision_value_type, 'A', a.revision_amount, a.budget_balance*a.revision_amount/100), -(decode(a.revision_value_type, 'A',a.revision_amount, a.budget_balance*a.revision_amount/100))), 0) revision_value, PSB_PSBRPBRT_XMLP_PKG.cf_open_balanceformula(a.code_combination_id, a.gl_budget_version_id, e.set_of_books_id, a.currency_code) CF_open_balance, --PSB_PSBRPBRT_XMLP_PKG.cf_end_balanceformula(:CF_open_balance, :cs_revision_value) CF_end_balance, PSB_PSBRPBRT_XMLP_PKG.cf_acct_flex_descformula(a.code_combination_id) CF_Acct_Flex_Desc, PSB_PSBRPBRT_XMLP_PKG.CP_open_balance_p CP_open_balance, PSB_PSBRPBRT_XMLP_PKG.CP_end_balance_p CP_end_balance from psb_budget_revision_accounts_v a, psb_budget_revisions_v b, gl_code_combinations_kfv c, gl_period_statuses d, psb_gl_budget_sets e, fnd_lookups fl where a.budget_group_id in (SELECT budget_group_id FROM psb_budget_groups WHERE budget_group_type = 'R' START WITH budget_group_id = :p_budget_group_id CONNECT BY PRIOR budget_group_id = parent_budget_group_id) and a.gl_budget_version_id LIKE NVL(:p_gl_budget_version_id, a.gl_budget_version_id) and b.submission_status = 'A' and a.gl_period_name = d.period_name and d.start_date >= :Input_period_start_date and d.end_date <= :Input_period_end_date and a.budget_revision_id = b.budget_revision_id and b.gl_budget_set_id = e.gl_budget_set_id and e.set_of_books_id = d.set_of_books_id and d.application_id = 101 and a.code_combination_id = c.code_combination_id and fl.lookup_type='PSB_REVISION_TRANSACTION_TYPES' and fl.enabled_flag = 'Y' and fl.lookup_code = b.transaction_type ORDER BY 8 ASC,11 ASC,6 ASC,5 ASC,3 ASC,2 ASC,9 ASC,7 ASC,10 ASC,4 ASC , code_combination_id , submission_date , budget_revision_id PSB PSBRPBRT_XML US PSB Budget Revisions Transaction Application: Public Sector Budgeting (Obsolete) Source: Budget Revisions Transaction Report (XML) Short Name: PSBRPBRT_XML DB package: PSB_PSBRPBRT_XMLP_PKG BI Publisher :input_period_end_date :input_period_start_date :p_budget_group_id :p_gl_budget_version_id 1 10 :p_budget_group_id LOV Oracle PSB_BUDGET_GROUPS Y select budget_group_id id, short_name value, name description from psb_budget_groups where budget_group_type='R' order by short_name Y US Budget Group Name 2 20 :p_gl_budget_version_id LOV Oracle PSB_GL_BUDGET_VERSION_ID Y select gl_budget_version_id id, gl_budget_version_id value, null description from psb_budget_revision_accounts_v where budget_revision_acct_line_id in (select max(bra.budget_revision_acct_line_id) from psb_budget_revision_accounts_v bra,psb_budget_revisions br where bra.budget_group_id in (select budget_group_id from psb_budget_groups where budget_group_type='R' start with budget_group_id=:$flex$.psb_budget_groups connect by prior budget_group_id=parent_budget_group_id) and br.submission_status='A' and bra.budget_revision_id=br.budget_revision_id group by bra.gl_budget_version_id) order by value,description US GL Budget Version Number 3 30 :p_start_period LOV Oracle PSB_REVISION_PERIOD Y select period_name id, period_name value, null description from gl_period_statuses where application_id=101 and set_of_books_id=(select nvl(b.set_of_books_id,b.root_set_of_books_id) from psb_budget_groups_v b where b.budget_group_id=:$flex$.psb_budget_groups) and adjustment_period_flag='N' order by start_date Y US Beginning Accounting Period 4 40 :p_end_period LOV Oracle PSB_REVISION_PERIOD Y select period_name id, period_name value, null description from gl_period_statuses where application_id=101 and set_of_books_id=(select nvl(b.set_of_books_id,b.root_set_of_books_id) from psb_budget_groups_v b where b.budget_group_id=:$flex$.psb_budget_groups) and adjustment_period_flag='N' order by start_date Y US Ending Accounting Period