JL Argentine Turnover Tax Data Upload Verification

Description
Categories: BI Publisher
Columns: Publish Date Invall, Start Date Invall, End Date Invall, Taxpayer Id Invall, Rate Change Flag Invall, Wht Group Invall, Wht Rate Invall, Perception Group Invall, Perception Rate Invall, Reason Fndmsg ...
Application: Latin America Localizations
Source: Argentine Turnover Tax Data Upload Verification Report
Short Name: JLARSTDV
DB package: JL_AR_APPLICABLE_TAXES
				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
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
 
JLAR_NUMBER
 
Number
JLAR_NUMBER_RESP
 
Number