How to link the bank statment with general ledgers

How to link the bank statment with general ledgers, We have the recods in gl_je_lines tables with categoery 'Bank Statements' but these records are not exists in ce_statement_lines table.

Can you please me to link the gl_je_lines with ce_statement_lines tables.

Below script is not working, We are not getting any records from below script:

SELECT 

H.JE_SOURCE,

H.JE_CATEGORY,

H.JE_HEADER_ID,

H.DOC_SEQUENCE_VALUE,

H.DEFAULT_EFFECTIVE_DATE,

D.JE_LINE_NUM,

D.DESCRIPTION,

D.ACCOUNTED_CR,

D.ACCOUNTED_DR,

SH.STATEMENT_HEADER_ID,

SH.STATEMENT_NUMBER,