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