/* Formatted on 2007/01/19 11:24 (Formatter Plus v4.8.7) */
SELECTc.segment1
|| '.'
|| c.segment2
|| '.'
|| c.segment3
|| '.'
|| c.segment4
|| '.'
|| c.segment5 csegment,
tvsn_gl_flexdescr (l.set_of_books_id,
'.',
c.segment1
|| '.'
|| c.segment2
|| '.'
|| c.segment3
|| '.'
|| c.segment4
|| '.'
|| c.segment5,
''
) csegment_desc,
SUBSTR (h.external_reference, 12, 18) year_num,
TO_CHAR (TRUNC (SYSDATE), 'yyyy-mm-dd') pdate,
SUBSTR (h.external_reference, 1, 10) month_num, h.currency_code,
l.description l_description, l.entered_cr, l.entered_dr,
l.accounted_cr, l.accounted_dr, h.description h_description,
l.code_combination_id, l.set_of_books_id, h.set_of_books_id
FROM gl_je_headers h, gl_je_lines l, gl_code_combinations c,
gl_je_batches b
WHERE h.je_header_id = l.je_header_id
AND c.code_combination_id = l.code_combination_id
AND h.je_batch_id + 0 = b.je_batch_id + 0
--AND h.NAME LIKE 'AARON_TEST16'
AND h.period_name = '12-07'
AND h.default_effective_date >=
_s_date
AND h.default_effective_date =
_s_bname
AND b.NAME =
_s_ef
AND TO_NUMBER (SUBSTR (h.external_reference, 1, 10)) <=
_e_ef
ANDfnd_profile.get ('ORG_ID', v_org_id);
|