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
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 |