| ${if(p_all='true', " SELECT * FROM gl_je_headers gjh ,gl_je_sources_tl gjs ,gl_je_categories_tl gjc ,gl_je_batches gjb ,gl_je_lines gjl ,fnd_user fnd ,hr_employees p ,apps.cux_gl_code_combinations_v gcc WHERE gjh.je_source = gjs.je_sour ce_name AND gjc.je_category_name = gjh.je_category AND gjh.je_batch_id = gjb.je_batch_id AND gjh.je_header_id = gjl.je_header_id AND gjs.language = 'ZHS' AND gjc.language = 'ZHS' /*AND trunc(SYSDATE) BETWEEN nvl(p.effective_start_date, SYSDATE - 1) AND nvl(p.effective_end_date, SYSDATE)*/ AND fnd.user_id = gjh.created_by AND p.employee_id = fnd.employee_id AND gjl.code_combination_id = gcc.code_combination_id AND (gjh.je_source IN ('Manual' ,'Manual (Copied)' ,'Encumbrance' ,'Encumbrance (Copied)' ,'Recurring' ,'Revaluation') OR (gjh.je_source IN ('Payables', 'Receivables') AND NOT EXISTS (SELECT 1 FROM gl_import_references gir WHERE gir.je_header_id = gjh.je_header_id AND gir.je_line_num = gjl.je_line_num))) and (gjb.name || '+' || gjh.name ) in(SELECT document_number FROM tempmain ) "+ " AND gjh.ledger_id ="+ {p_ledger_id}+ " AND gcc.segment1 IN (" +{p_company_code} +")" +" AND gjh.default_effective_date BETWEEN to_date('"+{P _GL_DATE_FROM}+" 00:00:00' ,'yyyy-mm-dd hh24:mi:ss') AND to_date('"+{P_GL_DATE_TO}+" 23:59:59', 'yyyy-mm-dd hh24:mi:ss')" ${if(p_description <> ""," and (gjl.description like '%"+p_description+"%' )" ,"") } |
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
