GMF Accounting Unit Mapping
Description
- Categories
- BI Publisher
- Application
- Process Manufacturing Financials
- Source
- Accounting Unit Mapping Report (XML)
- Short Name
- GLR17USR_XML
- DB package
- GMF_GLR17USR_XMLP_PKG
Imported from BI Publisher
Accounting Unit Mapping Report of OPM GL
Accounting Unit Mapping Report of OPM GL
SQL 14 lines
SELECT a.acctg_unit_no Acctg_Unit, a.acctg_unit_desc Description, b.orgn_code Orgn, b.whse_code Whse FROM gl_accu_mst a, gl_accu_map b WHERE a.co_code = :Company and a.acctg_unit_id = b.acctg_unit_id and a.delete_mark = 0 and b.delete_mark = 0 &Acctg_UnitCP &Orgn_CodeCP &Whse_CodeCP ORDER BY a.acctg_unit_no, a.acctg_unit_desc, b.orgn_code |
Parameters 7
| Parameter | Type | List of values SQL |
|---|---|---|
| Company | LOV Oracle | |
| From Acctg Unit | LOV Oracle | |
| To Acctg Unit | LOV Oracle | |
| From Orgn | LOV Oracle | |
| To Orgn | LOV Oracle | |
| From Whse | LOV Oracle | |
| To Whse | LOV Oracle |