GMF Accounting Unit Mapping

Description
Categories: BI Publisher, Manufacturing
Application: Process Manufacturing Financials
Source: Accounting Unit Mapping Report (XML)
Short Name: GLR17USR_XML
DB package: GMF_GLR17USR_XMLP_PKG
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
Parameter Name SQL text Validation
Non Block Sql
 
LOV Oracle
SY ALL
 
To Whse
 
LOV Oracle
From Whse
 
LOV Oracle
To Orgn
 
LOV Oracle
From Orgn
 
LOV Oracle
To Acctg Unit
 
LOV Oracle
From Acctg Unit
 
LOV Oracle
Company
 
LOV Oracle