Select ITEM, LOC, DIFF_DATE, nvl(t.bod_soh_rms,0) - nvl(t.bod_soh_sim,0) BOD_Diff , nvl(t.eod_soh_rms,0) -
nvl(t.eod_soh_sim,0) EOD_diff , (nvl(t.bod_soh_rms,0) - nvl(t.bod_soh_sim,0)) -(nvl(t.eod_soh_rms,0) - nvl(t.eod_soh_sim,0) )
Today_Diff, nvl( SALES_SIM ,0)-nvl(SALES_RMS,0) Sales_diff, nvl( RECEIVED_QTY_SIM,0)-nvl( RECEIVED_QTY_RMS,0)-nvl(RDW_QTY_RMS,0) Rec_Diff ,
nvl(RTV_SIM,0)- nvl(RTV_RMS,0) RTV_diff, nvl(INV_ADJ_SIM,0)-nvl(INV_ADJ_RMS,0) Inv_Adj_Diff ,TRAN_DATE, BOD_SOH_RMS, BOD_SOH_SIM, SALES_SIM,
SALES_RMS, SALES_MBS, RTV_SIM, RTV_RMS, INV_ADJ_SIM, INV_ADJ_RMS, RECEIVED_QTY_SIM, RECEIVED_QTY_RMS, SHIPPED_QTY_SIM, SHIPPED_QTY_RMS,
IN_TRANSIT_QTY_SIM, IN_TRANSIT_QTY_RMS, RETURN_SIM, RETURN_RMS,RDW_QTY_SIM, RDW_QTY_RMS,EOD_SOH_RMS,EOD_SOH_SIM, AV_COST_RMS,
(nvl(t.eod_soh_rms,0) - nvl(t.eod_soh_sim,0))*AV_COST_RMS EOD_amt_Diff , t.new_reason today_reason, t.old_reason
yesterday_reason From mproject.recon_sim_rms_stock_diff T where trunc(t.tran_date) = get_vdate -1 order by diff_date,loc,item desc;
I'm using Above query
against this query i could see 11 records in DB, but if i'm using same query for metricbeat i'm getting only 9 records in index.
can you please help me to fix this count mismatch.