JL Argentine Turnover Tax Data Upload Verification

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
Blitz Report™