PSB Flexfield Mapping

Description
Categories: BI Publisher
Application: Public Sector Budgeting (Obsolete)
Source: Flexfield Mapping Report (XML)
Short Name: PSBRPFLX_XML
DB package: PSB_PSBRPFLX_XMLP_PKG
select distinct a.code_combination_id in_ccid, 
	PSB_PSBRPFLX_XMLP_PKG.cf_accountformula(a.code_combination_id) CF_ACCOUNT
from psb_ws_account_lines a,gl_code_combinations cc
where a.currency_code <> 'STAT' and
a.code_combination_id = cc.code_combination_id and
cc.summary_flag <> 'Y' and
exists
(select 1 from psb_ws_lines b
where b.account_line_id = a.account_line_id and
b.worksheet_id =:p_global_worksheet_id )
order by a.code_combination_id
Parameter Name SQL text Validation
Worksheet
 
LOV Oracle