ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4193869E053B46B63588994Y SELECT &CP_FLEXDATA_HIGH flexdata_high, &CP_FLEXDATA_LOW flexdata_low, lines.account_position_set_id account_position_set_id2, lines.include_or_exclude_type /*PSB_PSBBGASR_XMLP_PKG.cf_flexfield_lowformula(:COA_ID, (lines.segment1_low || '\n' || lines.segment2_low || '\n' || lines.segment3_low || '\n' || lines.segment4_low || '\n' || lines.segment5_low || '\n' || lines.segment6_low || '\n' || lines.segment7_low || '\n' || lines.segment8_low || '\n' || lines.segment9_low || '\n' || lines.segment10_low || '\n' || lines.segment11_low || '\n' || lines.segment12_low || '\n' || lines.segment13_low || '\n' || lines.segment14_low || '\n' || lines.segment15_low || '\n' || lines.segment16_low || '\n' || lines.segment17_low || '\n' || lines.segment18_low || '\n' || lines.segment19_low || '\n' || lines.segment20_low || '\n' || lines.segment21_low || '\n' || lines.segment22_low || '\n' || lines.segment23_low || '\n' || lines.segment24_low || '\n' || lines.segment25_low || '\n' || lines.segment26_low || '\n' || lines.segment27_low || '\n' || lines.segment28_low |, :CF_FLEXFIELD_LOW) CF_FLEXFIELD_LOW, PSB_PSBBGASR_XMLP_PKG.cf_flexfield_highformula(:COA_ID, (lines.segment1_high || '\n' || lines.segment2_high || '\n' || lines.segment3_high || '\n' || lines.segment4_high || '\n' || lines.segment5_high || '\n' || lines.segment6_high || '\n' || lines.segment7_high || '\n' || lines.segment8_high || '\n' || lines.segment9_high || '\n' || lines.segment10_high || '\n' || lines.segment11_high || '\n' || lines.segment12_high || '\n' || lines.segment13_high || '\n' || lines.segment14_high || '\n' || lines.segment15_high || '\n' || lines.segment16_high || '\n' || lines.segment17_high || '\n' || lines.segment18_high || '\n' || lines.segment19_high || '\n' || lines.segment20_high || '\n' || lines.segment21_high || '\n' || lines.segment22_high || '\n' || lines.segment23_high || '\n' || lines.segment24_high || '\n' || lines.segment25_high || '\n' || lines.segment26_high || '\n' || lines.segment27_high || '\, :CF_FLEXFIELD_HIGH) CF_FLEXFIELD_HIGH*/ FROM psb_account_position_sets sets, psb_account_position_set_lines lines WHERE lines.account_position_set_id = sets.account_position_set_id and lines.account_position_set_id=:account_position_set_id ORDER BY lines.include_or_exclude_type PSB PSBBGASR_XML US PSB Budget Group Account Ranges Listing Application: Public Sector Budgeting (Obsolete) Source: Budget Group Account Ranges Listing (XML) Short Name: PSBBGASR_XML DB package: PSB_PSBBGASR_XMLP_PKG BI Publisher &cp_flexdata_high &cp_flexdata_low :account_position_set_id 1 10 :p_set_of_books_id LOV Oracle PSB_SET_OF_BOOKS Y select set_of_books_id id, name value, null description from gl_sets_of_books order by name US Ledger 2 20 :p_budget_group_id LOV Oracle PSB_BUDGET_GROUP_BY_SOB Y select budget_group_id id, name value, null description from psb_budget_groups_v where budget_group_type='R' and (root_set_of_books_id=:$flex$.psb_set_of_books or set_of_books_id=:$flex$.psb_set_of_books) order by name US Budget Group Name 3 30 :p_print_subgroups_flag LOV Oracle PSB_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description N Y US Print Subgroups