JG General Ledger Journal Entry - draft

Description
Categories: BI Publisher
Application: Regional Localizations
Source: General Ledger Journal Entry Report (XML) - Not Supported: Reserved For Future Use
Short Name: JGZZGLJRN_XML
DB package: JG_JGZZGLJRN_XMLP_PKG
	select
	inner.*,
	JG_JGZZGLJRN_XMLP_PKG.legal_entity_nameformula(inner.LEGAL_ENTITY_ID, :LEGAL_ENTITY_NAME) LEGAL_ENTITY_NAME,
	JG_JGZZGLJRN_XMLP_PKG.le_address_line_1formula(inner.LEGAL_ENTITY_ID, :LE_ADDRESS_LINE_1) LE_ADDRESS_LINE_1,
	JG_JGZZGLJRN_XMLP_PKG.le_address_line_2formula(inner.LEGAL_ENTITY_ID, :LE_ADDRESS_LINE_2) LE_ADDRESS_LINE_2,
	JG_JGZZGLJRN_XMLP_PKG.le_address_line_3formula(inner.LEGAL_ENTITY_ID, :LE_ADDRESS_LINE_3) LE_ADDRESS_LINE_3,
	JG_JGZZGLJRN_XMLP_PKG.le_cityformula(inner.LEGAL_ENTITY_ID, :LE_CITY) LE_CITY,
	JG_JGZZGLJRN_XMLP_PKG.le_postal_codeformula(inner.LEGAL_ENTITY_ID, :LE_POSTAL_CODE) LE_POSTAL_CODE,
	JG_JGZZGLJRN_XMLP_PKG.le_registration_numberformula(inner.LEGAL_ENTITY_ID, :LE_REGISTRATION_NUMBER) LE_REGISTRATION_NUMBER,
	JG_JGZZGLJRN_XMLP_PKG.le_activity_codeformula(inner.LEGAL_ENTITY_ID, :LE_ACTIVITY_CODE) LE_ACTIVITY_CODE
	from 
	(SELECT
    &P_PERIOD_INX_HINT
    LGR.NAME LEDGER_NAME,
    LGR.LEDGER_ID LEDGER_ID,
    glc.acctg_environment_code ENVIRONMENT_CODE,
    lgr.configuration_id CONFIGURATION_ID,
    fnd_flex_xml_publisher_apis.process_kff_combination_1('acct', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'N', 'VALUE') ACCT,
    fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'VALUE') ACCT_VALUE,
    fnd_flex_xml_publisher_apis.process_kff_combination_1('balancing_segment_value', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'VALUE') BALANCING_SEGMENT_VALUE,
    fnd_flex_xml_publisher_apis.process_kff_combination_1('cost_center_value', 'SQLGL', 'GL#',