SELECT DISTINCT gl_je_journal_lines_v.period_name,gl_je_journal_lines_v.je_category,
gl_je_journal_lines_v.line_reference_1,
gl_je_journal_lines_v.line_reference_2,
TO_CHAR (NULL) third_party_name, TO_CHAR (NULL) third_party_number,
je_source "Source", gl_je_journal_lines_v.SET_OF_BOOKS_ID "set_of_books_id" ,
segment1
|| '-'
|| segment2
|| '-'
|| segment3
|| '-'
|| segment4
|| '-'
|| segment5
|| '-'
|| segment6
|| '-'
|| segment7
|| '-'
|| segment8 SEGMENT,
gl_je_journal_lines_v.currency_code, line_entered_dr, line_entered_cr,
line_accounted_dr ,line_accounted_cr
,gl_je_journal_lines_v.JE_HEADER_ID,--TO_NUMBER (NULL) je_header_id,
LINE_JE_LINE_NUM,--TO_NUMBER (NULL) je_line_num,
line_code_combination_id,
gl_je_journal_lines_v.DOC_SEQUENCE_VALUE,
HEADER_EFFECTIVE_DATE,--TO_DATE (NULL) gl_date,
LINE_ATTRIBUTE1,--TO_CHAR (NULL) attribute1,
LINE_ATTRIBUTE2,--TO_CHAR (NULL) attribute2,
LINE_ATTRIBUTE3,--TO_CHAR (NULL) attribute3,
LINE_DESCRIPTION description--TO_CHAR (NULL) description
FROM gl_je_journal_lines_v , gl_summary_combinations_v, gl_sets_of_books
WHERE gl_summary_combinations_v.code_combination_id = gl_je_journal_lines_v.line_code_combination_id
AND actual_flag = 'A'
AND batch_status || '' = 'P'
AND gl_je_journal_lines_v.currency_code != 'STAT'
AND gl_je_journal_lines_v.set_of_books_id =gl_sets_of_books.set_of_books_id
AND gl_sets_of_books.mrc_sob_type_code = 'P'
AND ( NVL (effective_period_num, 0) >= :cf_period_from
AND (NVL (effective_period_num, 0) <= :cf_period_to)
)
AND ( NVL (segment1, 0) >= :p_org_from
AND (NVL (segment1, 0) <= :p_org_to)
)
AND ( NVL (segment5, 0) >= :p_account_from
AND (NVL (segment5, 0) <= :p_account_to)
)
and gl_je_journal_lines_v.SET_OF_BOOKS_ID not in ( 1014,1015,1016 )
AND je_source='Receivables'
