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
Run GMF Accounting Unit Mapping and other Oracle EBS reports with Blitz Report™ on our demo environment
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
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 GL Other - Calendar Validation GL Chart of Accounts - Mapping Rules GML OPM Apps Receipt Number ECC Cost Management, WIP Valuation (Process) FA Insurance Data Report- Not Supported: Reserved For Future Use GMF GL Expense Allocation Definition CAC Inventory Organization Summary
Blitz Report™

Blitz Report™ provides multiple benefits: