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
Imported from BI Publisher
Journal Voucher Report - India Local
Journal Voucher Report - India Local
SQL 27 lines
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) |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Source | LOV Oracle | |
| JV Number | LOV Oracle | |
| Start Date | Date | |
| End Date | Date |