Dear Avinash,

Condition: Visitcode is null but beneficiary registration ID is available under t_benvisitdetail table, using the beneficiaryregistration ID we have identified the visitcode at i_ben_flow_outreach table expect APL project.

For your reference please find the below query.

select distinct beneficiary_reg_id,beneficiary_visit_code from db_iemr.i_ben_flow_outreach where beneficiary_reg_id in
(select distinct beneficiaryregid from db_iemr.t_benvisitdetail where visitcode is null);