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
SQL 12 lines
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 |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Worksheet | LOV Oracle |