GMF Sub-Event/Account Title

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Detailed Subledger Report of OPM GL
Application: Process Manufacturing Financials
Source: Sub-Event/Account Title Report (XML)
Short Name: GLR20USR_XML
DB package: GMF_GLR20USR_XMLP_PKG
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
Parameter NameSQL textValidation
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
Download
Related Blitz Reports
CAC Inventory Lot and Locator OPM Value (Period-End) GMF GL Expense Allocation Detail FA Insurance Values Detail Report- Not Supported: Reserved For Future Use CAC OPM Batch Material Summary CAC Inventory and Intransit Value (Period-End) - Discrete/OPM FA Insurance Data Report- Not Supported: Reserved For Future Use ECC Cost Management, WIP Valuation (Process) APL Lot Cost Trend CAC Inventory Organization Summary
Blitz Report™