JA India - Journal Voucher

Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India - Journal Voucher Report (XML)
Short Name: JAINJVR_XML
DB package: JA_JAINJVR_XMLP_PKG
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)
Ask a question
Parameter Name SQL text Validation
Sob ID
 
Number
Chart Of Accts ID
 
Number
End Date
 
Date
Start Date
 
Date
JV Number
 
LOV Oracle
Source
 
LOV Oracle