ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN CA76CD0F7F8A17BDE05362FB0905E8C7Y select count(*) count, gl.name ledger, gb.period_name, (select flvv.description from fnd_lookup_values_vl flvv where gb.actual_flag=flvv.lookup_code and flvv.lookup_type='BATCH_TYPE' and flvv.view_application_id=101 and flvv.security_group_id=0) balance_type, gb.actual_flag from gl_ledgers gl, gl_balances gb where gl.ledger_id=gb.ledger_id group by gl.name, gb.period_name, gb.actual_flag order by count(*) desc US Andy Encumbrance test :dummy :lp_all_orgs :lp_organization_id :lp_revision_date :p_all_orgs :p_alt_option :p_alt_option_type :p_alternate_desg :p_bom_or_eng :p_cat_between :p_category_from :p_category_set :p_category_set_id :p_category_structure_id :p_category_to :p_compo_flexdata :p_conc_request_id :p_debug :p_err_msg :p_explode_option :p_explode_option_type :p_explosion_level :p_explosion_quantity :p_full_desc_choice :p_full_description :p_group_id :p_impl :p_impl_flag :p_item_from :p_item_id :p_item_structure_id :p_item_to :p_locator_flexdata :p_locator_structure_id :p_msg_buf :p_no :p_order_by :p_order_by_type :p_org_hierarchy :p_organization_id :p_organization_name :p_plan_factor :p_plan_factor_flag :p_print_option1 :p_print_option1_flag :p_print_option2 :p_print_option2_flag :p_print_option3 :p_print_option3_flag :p_print_option4 :p_print_option4_flag :p_print_option5 :p_print_option5_flag :p_print_option6 :p_print_option6_flag :p_prvd31_cnt :p_prvd32_cnt :p_qty_precision :p_range_option :p_range_option_type :p_revision :p_revision_date :p_sequence_id :p_sequence_id1 :p_specific_item :p_verify_flag :p_yes