GMF Sub-Event/Account Title
Description
- Categories
- BI Publisher
- Application
- Process Manufacturing Financials
- Source
- Sub-Event/Account Title Report (XML)
- Short Name
- GLR20USR_XML
- DB package
- GMF_GLR20USR_XMLP_PKG
Imported from BI Publisher
Detailed Subledger Report of OPM GL
Detailed Subledger Report of OPM GL
SQL 25 lines
select e.trans_source_code, b.event_code , b.event_desc , c.sub_event_code , c.sub_event_desc, d.acct_ttl_code , d.acct_ttl_desc from gl_evnt_mst b, gl_sevt_ttl a, gl_sevt_mst c, gl_acct_ttl d, gl_srce_mst e where a.sub_event_type = c.sub_event_type and d.acct_ttl_type = a.acct_ttl_type and b.trans_source_type = e.trans_source_type and b.event_type = c.event_type and c.sub_event_type = a.sub_event_type &SourceCP &EventCP &SubEventCP &AcctTtlCP order by e.trans_source_code, b.event_code, c.sub_event_code, d.acct_ttl_code |
Parameters 8
| Parameter | Type | List of values SQL |
|---|---|---|
| From Source | LOV Oracle | |
| To Source | LOV Oracle | |
| From Event | LOV Oracle | |
| To Event | LOV Oracle | |
| From Sub-Event | LOV Oracle | |
| To Sub-Event | LOV Oracle | |
| From Acct Ttl | LOV Oracle | |
| To Acct Ttl | LOV Oracle |