Oracle EBS Latam Tax-Latin Fiscal Classification

Oracle EBS Latam Tax-Latin Fiscal Classification

Tables:-
JL_ZZ_AR_TX_FSC_LOOKUP_V
JL_ZZ_AR_TX_FSC_CLS_ALL

SQL Example:-

SELECT
jzat.lookup_code
,jzat.meaning
,jzat.description
 ,TO_CHAR(jzat.start_date_active,'DD-MM-YYYY')
 ,TO_CHAR(jzat.end_date_active,'DD-MM-YYYY')
 ,hou.name,TO_CHAR(jzatf.start_date_active,'DD-MM-YYYY')
 ,TO_CHAR(jzatf.end_date_active,'DD-MM-YYYY')
 ,jzatf.tax_code,jzatf.enabled_flag
 FROM
 apps.JL_ZZ_AR_TX_FSC_LOOKUP_V jzat
 ,apps.JL_ZZ_AR_TX_FSC_CLS_ALL jzatf
 ,apps.hr_operating_units hou
 WHERE 1=1
 AND jzatf.org_id = hou.organization_id
 AND jzatf.fiscal_classification_code = jzat.lookup_code ;