JA India - Journal Voucher

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Journal Voucher Report - India Local
Application: Asia/Pacific Localizations
Source: India - Journal Voucher Report (XML)
Short Name: JAINJVR_XML
DB package: JA_JAINJVR_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT gjh.LEDGER_ID,
               gsob.name sob_name,
               gjh.default_effective_date,
               gjh.doc_sequence_value,
               gjh.name,
               gjh.je_source,
               gjl.code_combination_id,
               gcc.description,
               gjl.accounted_dr,
                gjl.accounted_cr,
                gjl.je_line_num,
                gjh.je_header_id, 
	JA_JAINJVR_XMLP_PKG.cf_accountformula(gjl.code_combination_id) CF_account, 
	JA_JAINJVR_XMLP_PKG.cf_accts_descformula(gjl.code_combination_id) CF_accts_desc
FROM  gl_je_headers gjh, 
            gl_je_lines   gjl,
            gl_code_combinations gcc,
            gl_sets_of_books gsob
WHERE gjh.je_header_id = gjl.je_header_id
AND      gcc.code_combination_id = gjl.code_combination_id 
AND      gsob.set_of_books_id = gjh.LEDGER_ID
AND     gjh.je_source = NVL(:p_source, gjh.je_source)
&P_SELECTED_JV_NO  
AND     gjh.LEDGER_ID = :p_sob_id
AND     gjh.default_effective_date BETWEEN NVL(:p_from_date, gjh.default_effective_date)
                                                                  AND NVL(:p_to_date, gjh.default_effective_date)
Parameter Name SQL text Validation
Source
 
LOV Oracle
JV Number
 
LOV Oracle
Start Date
 
Date
End Date
 
Date