JG General Ledger Journal and Balance - draft

Description
Categories: BI Publisher
Application: Regional Localizations
Source: General Ledger Journal and Balance Report (XML) - Not Supported: Reserved For Future Use
Short Name: JGZZGLJRB_XML
DB package: JG_JGZZGLJRB_XMLP_PKG
SELECT a.*,
	JG_JGZZGLJRB_XMLP_PKG.legal_entity_nameformula(a.LEGAL_ENTITY_ID, :LEGAL_ENTITY_NAME) LEGAL_ENTITY_NAME, 
	JG_JGZZGLJRB_XMLP_PKG.le_address_line_1formula(a.LEGAL_ENTITY_ID, :LE_ADDRESS_LINE_1) LE_ADDRESS_LINE_1, 
	JG_JGZZGLJRB_XMLP_PKG.le_address_line_2formula(a.LEGAL_ENTITY_ID, :LE_ADDRESS_LINE_2) LE_ADDRESS_LINE_2, 
	JG_JGZZGLJRB_XMLP_PKG.le_address_line_3formula(a.LEGAL_ENTITY_ID, :LE_ADDRESS_LINE_3) LE_ADDRESS_LINE_3, 
	JG_JGZZGLJRB_XMLP_PKG.le_cityformula(a.LEGAL_ENTITY_ID, :LE_CITY) LE_CITY, 
	JG_JGZZGLJRB_XMLP_PKG.le_postal_codeformula(a.LEGAL_ENTITY_ID, :LE_POSTAL_CODE) LE_POSTAL_CODE, 
	JG_JGZZGLJRB_XMLP_PKG.le_registration_numberformula(a.LEGAL_ENTITY_ID, :LE_REGISTRATION_NUMBER) LE_REGISTRATION_NUMBER, 
	JG_JGZZGLJRB_XMLP_PKG.le_activity_codeformula(a.LEGAL_ENTITY_ID, :LE_ACTIVITY_CODE) LE_ACTIVITY_CODE,
	JG_JGZZGLJRB_XMLP_PKG.acct_level10_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL10_VALUE, 
	JG_JGZZGLJRB_XMLP_PKG.acct_level10_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL10_VALUE_DESC, 
	JG_JGZZGLJRB_XMLP_PKG.acct_level9_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL9_VALUE, 
	JG_JGZZGLJRB_XMLP_PKG.acct_level9_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL9_VALUE_DESC, 
	JG_JGZZGLJRB_XMLP_PKG.acct_level8_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL8_VALUE, 
	JG_JGZZGLJRB_XMLP_PKG.acct_level8_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL8_VALUE_DESC, 
	JG_JGZZGLJRB_XMLP_PKG.acct_level7_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL7_VALUE, 
	JG_JGZZGLJRB_XMLP_PKG.acct_level7_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL7_VALUE_DESC, 
	JG_JGZZGLJRB_XMLP_PKG.acct_level6_valueformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL6_VALUE, 
	JG_JGZZGLJRB_XMLP_PKG.acct_level6_value_descformula(a.segment1, a.ACCT_VALUE_DESC) ACCT_LEVEL6_VALUE_DESC, 
	JG_JGZZGLJRB_XMLP_PKG.acct_level5_valueformula(a<