GMF Accounting Unit Mapping

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Accounting Unit Mapping Report of OPM GL
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 NameSQL textValidation
Company
 
LOV Oracle
From Acctg Unit
 
LOV Oracle
To Acctg Unit
 
LOV Oracle
From Orgn
 
LOV Oracle
To Orgn
 
LOV Oracle
From Whse
 
LOV Oracle
To Whse
 
LOV Oracle
Download
Related Blitz Reports
GCS Data Submission Impacted Balances Base Data Source GCS Data Submission Impacted Balances Data Source AI INV On Hand Qty Value GL Other - Calendar Validation GL Chart of Accounts - Mapping Rules AI INV Period Close Details AI AP Trial Balance GML OPM Apps Receipt Number GMF Item Costs
Blitz Report™