JL Colombian Third Party / Account Report- Not Supported: Reserved For Future Use

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Colombian Third Party / Account Report
Application: Latin America Localizations
Source: Colombian Third Party / Account Report (XML) - Not Supported: Reserved For Future Use
Short Name: JLCOGLNA_XML
DB package: JL_JLCOGLNA_XMLP_PKG
Run JL Colombian Third Party / Account Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT	nit.nit NIT,
	nit.name NAME,
	bal.nit_id NIT_ID,
	bal.account_code ACCOUNT,
	acc.description DESCRIPTION,
	bal.period_name PERIOD,
                  glc.user_je_category_name CATEGORY,
	jeb.name BATCH_NAME,
	jeh.name JOURNAL,
	trx.je_batch_id BATCH,
	trx.je_header_id JOURNAL2,
	trx.document_number DOCUMENT,
	jeh.doc_sequence_value DOC_SEQUENCE,
	trx.accounting_date ADATE,
	nvl(trx.accounted_dr,0) DEBITS,
	nvl(trx.accounted_cr,0) CREDITS,
	nvl(trx.entered_dr,0) ODEBITS,
	nvl(trx.entered_cr,0) OCREDITS,
	bal.currency_code CURRENCY1,
	bal.currency_code CURRENCY2,
	cc.code_combination_id CCID
FROM	jl_co_gl_trx trx,
               gl_code_combinations cc,
                jl_co_gl_nits nit,
	jl_co_gl_nit_accts_v acc,
               gl_je_batches jeb,
               gl_je_headers jeh ,
               gl_je_categories glc,
                jl_co_gl_balances bal
WHERE	bal.set_of_books_id = :P_SET_OF_BOOKS_ID
AND 	trx.je_batch_id = jeb.je_batch_id(+)
AND	trx.je_header_id = jeh.je_header_id(+)
AND	cc.chart_of_accounts_id = :STRUCT_NUM
AND	cc.chart_of_accounts_id = acc.chart_of_accounts_id
AND	cc.code_combination_id = bal.code_combination_id
AND	nit.nit_id = bal.nit_id
AND	acc.account_code = bal.account_code
AND           trx.category = jeh.je_category(+)
AND           jeh.je_category = glc.je_category_name(+)
AND	to_number(to_char(bal.period_year)||LPAD(to_char(bal.period_num),2,'0'))
                BETWEEN  to_number(to_char(:C_PYEAR2)||LPAD(to_char(:C_PNUM2),2,'0'))
AND	to_number(to_char(:C_PYEAR3)||LPAD(to_char(:C_PNUM3),2,'0'))
AND	nit.nit BETWEEN  to_number(:P_START_NIT) AND to_number(:P_END_NIT)       
AND     bal.code_combination_id = trx.code_combination_id(+)
AND     bal.period_name   = trx.period_name(+)
and       bal.nit_id = trx.nit_id(+)
ORDER BY nit.nit, trx.account_code,trx.accounting_date
Parameter Name SQL text Validation
Operating Unit
 
LOV
Company Name
 
LOV Oracle
Starting Period
 
LOV Oracle
Ending Period
 
LOV Oracle
Starting Third Party ID
 
LOV Oracle
Ending Third Party ID
 
LOV Oracle
DebugFlag
 
Char