PSB Budget Group Account Ranges Listing

Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Budget Group Account Ranges Listing (XML)
Short Name: PSBBGASR_XML
DB package: PSB_PSBBGASR_XMLP_PKG
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
Parameter Name SQL text Validation
Ledger
 
LOV Oracle
Budget Group Name
 
LOV Oracle
Print Subgroups
 
LOV Oracle