1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| SELECT batch_name, header_name, currency_code, line_je_line_num,
line_description, line_accounted_cr, period_name, line_stat_amount,
line_accounted_dr, header_effective_date, doc_sequence_value, row_id,
line_entered_dr_num, line_entered_cr_num, actual_flag,
batch_description, set_of_books_id, header_description,
doc_sequence_id, je_batch_id, je_header_id, line_code_combination_id,
line_period_name, line_effective_date, line_reference_1,
line_reference_2, line_reference_3, line_reference_4,
line_reference_5, line_reference_6, line_reference_7,
line_reference_8, line_reference_9, line_reference_10,
subledger_doc_sequence_id, subledger_doc_sequence_value, je_source,
je_category, parent_je_header_id, creation_date, created_by,
last_update_date, last_updated_by, last_update_login
FROM gl_je_journal_lines_v
WHERE set_of_books_id = 68
AND batch_status || '' = 'P'
AND (actual_flag = 'A')
AND ( line_code_combination_id IN (
SELECT gah.detail_code_combination_id
FROM gl_account_hierarchies gah
WHERE gah.summary_code_combination_id = 1231525
AND gah.set_of_books_id || '' = 68)
AND (((NVL (period_year, 0) * 1000) + NVL (period_num, 0)) >=
2007001
)
AND (((NVL (period_year, 0) * 1000) + NVL (period_num, 0)) <=
2007004
)
)
AND (currency_code != 'STAT')
AND -1 = -1
ORDER BY je_header_id, line_je_line_num |
Partager