GMF Sub-Event/Account Title

Description
Categories: BI Publisher, Manufacturing
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
Non Block Sql
 
LOV Oracle
To Acct Ttl
 
LOV Oracle
From Acct Ttl
 
LOV Oracle
To Sub-Event
 
LOV Oracle
From Sub-Event
 
LOV Oracle
To Event
 
LOV Oracle
From Event
 
LOV Oracle
To Source
 
LOV Oracle
From Source
 
LOV Oracle