JL Argentine Monotributistas Billing vs. Threshold Verification

				SELECT 	A.JL_INFO_V1		            SUPPLIER_NAME, 
						A.JL_INFO_V2			        TAXPAYER_ID, 
						A.JL_INFO_V3			        SIM_REG_CONT_TYPE, 
						A.JL_INFO_N6			        THRESHOLD, 
						A.JL_INFO_V6			        INVOICE_NUM,
						TO_CHAR(A.JL_INFO_D1,'DD-MON-YYYY')				    INVOICE_DATE,
						A.JL_INFO_V7					INVOICE_STATUS,
						A.JL_INFO_V8					DGI_TYPE,
						A.JL_INFO_N4		            INVOICE_AMT,
						A.JL_INFO_N5			        INV_AMT_EXC_TAX,
						A.JL_INFO_V9				    THRESHOLD_MET
						FROM JL_ZZ_INFO_T  A
						WHERE A.JL_INFO_V9 = 'N'
						  AND A.JL_INFO_V4 = 'N'
						  AND A.JL_INFO_V5 = 'N'
						  AND :P_REPORT_MODE = '02'
						  AND NOT EXISTS (SELECT 1 FROM JL_ZZ_INFO_T B WHERE A.JL_INFO_N1 = B.JL_INFO_N1 AND B.JL_INFO_V9 = 'Y')
						ORDER BY A.JL_INFO_V1,A.JL_INFO_D1,A.JL_INFO_N3

SELECT A.JL_INFO_V1 SUPPLIER_NAME, A.JL_INFO_V2 TAXPAYER_ID, A.JL_INFO_V3 SIM_REG_CONT_TYPE, A.JL_INFO_N6 THRESHOLD, A.JL_INFO_V6 INVOICE_NUM, TO_CHAR(A.JL_INFO_D1,'DD-MON-YYYY') INVOICE_DATE, A.JL_INFO_V7 INVOICE_STATUS, A.JL_INFO_V8 DGI_TYPE, A.JL_INFO_N4 INVOICE_AMT, A.JL_INFO_N5 INV_AMT_EXC_TAX, A.JL_INFO_V9 THRESHOLD_MET FROM JL_ZZ_INFO_T A WHERE A.JL_INFO_V9 = 'N' AND A.JL_INFO_V4 = 'N' AND A.JL_INFO_V5 = 'N' AND :P_REPORT_MODE = '02' AND NOT EXISTS (SELECT 1 FROM JL_ZZ_INFO_T B WHERE A.JL_INFO_N1 = B.JL_INFO_N1 AND B.JL_INFO_V9 = 'Y') ORDER BY A.JL_INFO_V1,A.JL_INFO_D1,A.JL_INFO_N3