Saturday, April 04, 2020

Oracle EBS GST-Tax Conversion

Oracle EBS GST-Tax Conversion
Configuration:Tax Conversion,
Responsibility:Oracle Financials For India,
Navigation:Tax Configuration ->Define Tax Conversion

Tables:-
JAI_IM_TAX_MAPPING

Example:-

SELECT DISTINCT
hou.NAME  "Opearting Unit"
,jitm.TAXABLE_EVENT "Taxable Event"
,decode(jitm.USE_EBS_TAX,'Y','Yes') "Use EBS Tax Rate"
,NULL AS "Imported Tax Rate Name"
,NULL AS  "OFI Tax Rate Name"
,NULL AS  "Inclusive Flag"
FROM
APPS.JAI_IM_TAX_MAPPING jitm,
APPS.hr_operating_units  hou
WHERE 1=1
AND jitm.ORG_ID=hou.ORGANIZATION_ID
AND hou.name= '&&';

0 Comments:

Post a Comment

<< Home