JL Argentine Monotributistas Billing vs. Threshold Verification

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Latin America Localizations
Source: Argentine Monotributistas Billing vs. Threshold Verification Report
Short Name: JLARMTBT_XMLP
DB package: JL_ZZ_AP_MONOTRIB_AWT_PKG
Run JL Argentine Monotributistas Billing vs. Threshold Verification and other Oracle EBS reports with Blitz Report™ on our demo environment
				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
Parameter Name SQL text Validation
Report Mode 
 
 LOV Oracle
Company Name 
 
 LOV Oracle
Supplier Name 
 
 LOV Oracle
Taxpayer ID 
 
 LOV Oracle
Reporting Date 
 
 Date
Download
Related Blitz Reports
JL Colombian Payables Withholding Report- Not Supported: Reserved For Future Use JL Regional Fixed Assets Inflation Adjusted Asset Summary- Not Supported: Reserved For Future Use JL Argentine Payables Withholding Certificate - draft JL Argentine Payables Withholding Flat File - draft JL Colombian Payables Withholding Certificate - draft JG ECE Payables VAT Register JE Italian Annual Supplier Listing JG EMEA VAT: Summary AP Extract JE Croatian Supplier Invoice Tax
Blitz Report™

Blitz Report™ provides multiple benefits: