ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4704551A9E05362FB09050512Y 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) JA JAINJVR_XML US JA India - Journal Voucher 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 ZHS JA 印度 - 日记帐凭证报表 Imported from BI Publisher Description: 日记帐凭证报表 - 印度本地化 Application: 亚太地区本地化 Source: 印度 - 日记帐凭证报表 (XML) Short Name: JAINJVR_XML DB package: JA_JAINJVR_XMLP_PKG BI Publisher &p_selected_jv_no :lp_column_value :lp_from_date :lp_to_date :p_chart_of_accts_id :p_column_value :p_conc_request_id :p_from_date :p_jv_no :p_selected_jv_no :p_sob_id :p_source :p_to_date 1 -30 :p_chart_of_accts_id Number SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = fnd_profile.value('GL_SET_OF_BKS_ID') US Chart Of Accts ID ZHS 科目表标识 2 -20 :p_sob_id Number fnd_profile.value('GL_SET_OF_BKS_ID') US Sob ID ZHS SOB 标识 3 10 :p_source LOV Oracle JA_IN_GL_SOURCE Y select a.je_source id, a.je_source value, null description from gl_je_headers a where (a.je_source,a.rowid) in (select b.je_source,max(b.rowid) from gl_je_headers b group by b.je_source) order by value,description US Source ZHS 来源 4 20 :p_jv_no LOV Oracle JA_IN_JV_NO Y select a.doc_sequence_value id, a.doc_sequence_value value, null description from gl_je_headers a where (a.doc_sequence_value,a.rowid) in (select b.doc_sequence_value,max(b.rowid) from gl_je_headers b where b.je_source=:$flex$.ja_in_gl_source group by b.doc_sequence_value) and a.doc_sequence_value is not null and a.je_source=:$flex$.ja_in_gl_source order by value,description US JV Number ZHS JV 编号 5 30 :p_from_date Date Y US Start Date ZHS 起始日期 6 40 :p_to_date Date Y US End Date ZHS 终止日期