BI Report does not return all data

I have a query against an XMLTABLE that returns about 50 rows. If I put this same query into my data model, it only returns about 5.

I attached the XML portion.

Here is my query:

select xmlx.LINES_TRX_NBR,xmll.* from jcibi.bi_request bi,
                         XMLTABLE('/JCI_ARPRINT/LIST_G_HEADERS/G_HEADERS/LIST_G_LINES' PASSING

bi.x_payload
                            COLUMNS
                            LINES_TRX_NBR varchar2(20) PATH  'LINES_TRX_NBR',
                            LINES_XML XMLTYPE PATH 'G_LINES') xmlx,
                            XMLTABLE('G_LINES' PASSING LINES_XML
                              COLUMNS    LINENUMBER varchar2(10) PATH 'LINENUMBER',
                                  LINEDESC  varchar2(200) PATH 'LINEDESC',
                                  EXTAMOUNT  varchar2(20) PATH 'EXTAMOUNT' )  xmll
                           where (bi.request_id) = 49198149