ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F41A3869E053B46B63588994 SELECT gl_cc.CONCATENATED_SEGMENTS, ROUND(sum(nvl(pg_intr.entered_dr, 0)), 2) debits, ROUND(sum(nvl(pg_intr.entered_cr, 0)), 2) credits, pg_intr.reference2, pg_intr.period_name, pg_intr.budget_version_id, gl_budget_set_name, pg_intr.gl_budget_set_id, gl_bv.budget_name, pg_intr.budget_year_id, pg_intr.currency_code, pbud_per.name, pb_st.name stage_name, pg_intr.code_combination_id, pg_intr.worksheet_id worksheet_id, PSB_PSBOTGLR_XMLP_PKG.CP_1_p CP_1 FROM psb_gl_interfaces pg_intr, GL_CODE_COMBINATIONS_kfv gl_cc, psb_budget_periods pbud_per, gl_budgets_v gl_bv, psb_gl_budget_sets pg_set, psb_budget_stages pb_st WHERE pg_intr.worksheet_id= :p_worksheet_id AND nvl(pg_intr.budget_source_type,'BP') = :p_budget_source_type AND gl_cc.code_combination_id = pg_intr.code_combination_id AND pg_intr.budget_version_id = gl_bv.budget_version_id AND pbud_per.budget_period_id = pg_intr.budget_year_id AND pb_st.budget_stage_id(+) = pg_intr.budget_stage_id AND pg_set.gl_budget_set_id = pg_intr.gl_budget_set_id AND ((:p_budget_year_id IS NULL) OR (pg_intr.budget_year_id = :p_budget_year_id) ) AND ((:p_gl_budget_set_id IS NULL) OR (pg_intr.gl_budget_set_id = :p_gl_budget_set_id) ) GROUP BY pg_intr.worksheet_id, gl_cc.concatenated_segments, pg_intr.reference2, pg_intr.period_name, pg_intr.budget_version_id, gl_budget_set_name, pg_intr.gl_budget_set_id, pg_intr.budget_year_id, gl_bv.budget_name, pg_intr.currency_code, pbud_per.name, pb_st.name, pg_intr.code_combination_id &cp_sort ORDER BY 7 ASC,8 ASC,9 ASC,6 ASC,10 ASC,11 ASC, 5 ASC,13 ASC,12 ASC Y PSB PSBOTGLR_XML US PSB Budget Journal Edit Application: Public Sector Budgeting (Obsolete) Source: Budget Journal Edit Report (XML) Short Name: PSBOTGLR_XML DB package: PSB_PSBOTGLR_XMLP_PKG BI Publisher &cp_sort :p_budget_source_type :p_budget_year_id :p_gl_budget_set_id :p_worksheet_id 1 10 :p_worksheet_id LOV Oracle PSB_SRS_XLA_WS Y select worksheet_id id, worksheet_id value, name description from psb_worksheets where worksheet_id in (select worksheet_id from psb_gl_interfaces where budget_source_type in('BP','SW')) order by value,description US Worksheet 2 20 :p_currency_code LOV Oracle PSB_BUDGET_CURRENCY Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='PSB_CURRENCY_TYPE' order by value,description select meaning from fnd_lookups where lookup_type ='PSB_CURRENCY_TYPE' and lookup_code = 'C' Y US Currency Code 3 30 :p_budget_year_id LOV Oracle PSB_SRS_INTF_BJE_YEAR Y select budget_period_id id, name value, description description from psb_budget_periods where budget_period_id in (select budget_year_id from psb_gl_interfaces where worksheet_id=:$flex$.psb_srs_xla_ws and budget_source_type in ('BP','SW')) order by value,description US Year 4 40 :p_gl_budget_set_id LOV Oracle PSB_SRS_INTF_BUDGET_SET Y select gl_budget_set_id id, gl_budget_set_name value, null description from psb_gl_budget_sets where gl_budget_set_id in (select gl_budget_set_id from psb_gl_interfaces where worksheet_id=:$flex$.psb_srs_xla_ws and budget_source_type in ('BP','SW')) order by value,description US Budget Set 5 50 :p_order_by1 LOV Oracle PSB_SRS_RPT_ORDERBY1_GLI Y select application_column_name id, segment_name value, segment_name description from fnd_id_flex_segments where id_flex_code='GL#' and id_flex_num in (select chart_of_accounts_id from gl_sets_of_books where set_of_books_id in (select distinct set_of_books_id from psb_gl_interfaces where budget_source_type in ('BP','SW') and worksheet_id=:$flex$.psb_srs_xla_ws)) order by value,description US Report Order by 1 6 60 :p_order_by2 LOV Oracle PSB_SRS_RPT_ORDERBY2_GLI Y select application_column_name id, segment_name value, segment_name description from fnd_id_flex_segments where id_flex_code='GL#' and application_column_name<> :$flex$.psb_srs_rpt_orderby1_gli and id_flex_num in (select chart_of_accounts_id from gl_sets_of_books where set_of_books_id in (select distinct set_of_books_id from psb_gl_interfaces where budget_source_type in ('BP','SW') and worksheet_id=:$flex$.psb_srs_xla_ws)) order by value,description US Report Order by 1 7 70 :p_order_by3 LOV Oracle PSB_SRS_RPT_ORDERBY3_GLI Y select application_column_name id, segment_name value, segment_name description from fnd_id_flex_segments where id_flex_code='GL#' and application_column_name<> :$flex$.psb_srs_rpt_orderby1_gli and application_column_name<>:$flex$.psb_srs_rpt_orderby2_gli and id_flex_num in (select chart_of_accounts_id from gl_sets_of_books where set_of_books_id in (select distinct set_of_books_id from psb_gl_interfaces where budget_source_type in ('BP','SW') and worksheet_id=:$flex$.psb_srs_xla_ws)) order by value,description US Report Order by 3 :$flex$.psb_srs_rpt_orderby1_gli Report Order by 1 Report Order by 1 :$flex$.psb_srs_rpt_orderby1_gli Report Order by 1 Report Order by 3 :$flex$.psb_srs_rpt_orderby2_gli Report Order by 1 Report Order by 3 :$flex$.psb_srs_xla_ws Worksheet Budget Set :$flex$.psb_srs_xla_ws Worksheet Report Order by 1 :$flex$.psb_srs_xla_ws Worksheet Report Order by 1 :$flex$.psb_srs_xla_ws Worksheet Report Order by 3 :$flex$.psb_srs_xla_ws Worksheet Year