I would like to create an array or table like below
I simply delcare my type and array
type array_t is table of varchar2(250);
invoice_array array_t;
BEGIN
select glr.reference_4,glr.je_header_id, glr.je_line_num
BULK COLLECT INTO invoice_array
from gl_import_references glr,
xla_ae_lines xlines
where je_header_id in (select je_header_id from nlas_sla_analysis_tbl where source = 'Receivables')
and je_line_num in (select je_line_num from nlas_sla_analysis_tbl b where source = 'Receivables' and je_header_id = glr.je_header_id)
and glr.gl_sl_link_id = xlines.gl_sl_link_id
and glr.gl_sl_link_table = xlines.gl_sl_link_table