JL Argentine Turnover Tax Data Upload Verification

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Latin America Localizations
Source: Argentine Turnover Tax Data Upload Verification Report
Short Name: JLARSTDV
DB package: JL_AR_APPLICABLE_TAXES
Run JL Argentine Turnover Tax Data Upload Verification and other Oracle EBS reports with Blitz Report™ on our demo environment
				SELECT 	INVALL.PUBLISH_DATE		PUBLISH_DATE_INVALL, 
					INVALL.START_DATE			START_DATE_INVALL, 
					INVALL.END_DATE				END_DATE_INVALL, 
					INVALL.TAXPAYER_ID			TAXPAYER_ID_INVALL, 
					INVALL.RATE_CHANGE_FLAG		RATE_CHANGE_FLAG_INVALL,
					INVALL.WHT_GROUP_NUM		WHT_GROUP_INVALL,
					INVALL.WHT_RATE				WHT_RATE_INVALL,
					INVALL.PERCEPTION_GROUP_NUM		PERCEPTION_GROUP_INVALL,
					INVALL.PERCEPTION_RATE			PERCEPTION_RATE_INVALL,
					NVL(FND.MESSAGE_TEXT,'INVALID TAXPAYER ID, PLEASE VERIFY')	REASON_FNDMSG
					FROM JL_AR_TURN_UPL_T INVALL, JGZZ_AR_TAX_GLOBAL_TMP ARGT, FND_NEW_MESSAGES FND
                                        -- Bug 17450797 Start
                                            ,FND_APPLICATION FAP
                                        -- Bug 17450797 End
					WHERE :P_REV_TEMP_DATA 	 =  'Y'
					AND   :P_VALIDATION_DATA =	'Y'
					AND   INVALL.START_DATE 	>= 	(SELECT MAX(START_DATE) FROM JL_AR_TURN_UPL)
					AND   INVALL.END_DATE   	<= 	(SELECT MAX(END_DATE) FROM JL_AR_TURN_UPL)
					AND   INVALL.TAXPAYER_ID =  ARGT.JG_INFO_N1
					AND   INVALL.START_DATE  =  ARGT.JG_INFO_D1
					AND   INVALL.END_DATE    =  ARGT.JG_INFO_D2
                                        -- Bug 17450797 Start
                                        AND   FND.language_code  =  userenv('LANG')   
                                        AND   FND.application_id =  FAP.application_id
                                        AND   FAP.application_short_name = 'JL'  
                                        -- Bug 17450797 End
					AND   ARGT.JG_INFO_V1	 =  FND.MESSAGE_NAME
					AND   EXISTS (SELECT 1 from JL_AR_TURN_UPL IALL where IALL.TAXPAYER_ID <> INVALL.TAXPAYER_ID)
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
Review Temporary Data 
 
 LOV Oracle
Validate Temporary Data 
 
 LOV Oracle
Finalize Data 
 
 LOV Oracle
Responsibility 
 
 LOV Oracle
P_START_DATE 
 
 LOV Oracle
End Date 
 
 LOV Oracle
AP Withholding Tax Type 
 
 LOV Oracle
AR Perception Tax Type 
 
 Char
Download
Related Blitz Reports
JL Argentine Receivables Withholding Taken Flat File - draft JL Argentine Payables Withholding Certificate - draft ZX Taiwanese Receivables Government Uniform Invoice Report- Not Supported: Reserved For Future Use ZX Taiwanese Output VAT Report- Not Supported: Reserved For Future Use XLA Entity ID Mappings ZX Taiwanese Sales Return and Discount Report- Not Supported: Reserved For Future Use ZX Taiwanese Pro Forma 401 Report- Not Supported: Reserved For Future Use ZX Taiwanese Receivables Zero-Rate Tax Report- Not Supported: Reserved For Future Use AR Applied Receipts
Blitz Report™

Blitz Report™ provides multiple benefits: