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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 Name SQL text Validation
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
ECC Cost Management, WIP Valuation (Process) GMF GL Expense Allocation Detail FA Insurance Values Detail Report- Not Supported: Reserved For Future Use FA Insurance Data Report- Not Supported: Reserved For Future Use CAC Inventory Organization Summary GMF Accounting Unit Mapping GMF GL Expense Allocation Definition XLA Validate Application Accounting Definitions- Not Supported: Reserved For Future Use AR Transactions and Lines
Blitz Report™

Blitz Report™ provides multiple benefits: