Oracle EBS Latam Tax-Condition Classes

Oracle EBS Latam Tax-Condition Classes

Tables:-
JL_ZZ_AR_TX_ATT_CLS_LOOKUP_V
JL_ZZ_AR_TX_ATT_CLS_V

SQL Example:-

SELECT
jzav.tax_attr_class_type  "Class Type"
,jzav.tax_attr_class_code "Class Code"
,jzav.tax_attribute_name  "Condition Code"
,jzalv.start_date_active  "Start Date Active"
,jzalv.end_date_active  "End Date Active"
,hou.name "Name"
,jzav.tax_category  "Tax Category"
,jzav.enabled_flag  "Enabled Flag"
FROM
JL_ZZ_AR_TX_ATT_CLS_LOOKUP_V jzalv
,JL_ZZ_AR_TX_ATT_CLS_V jzav
,HR_OPERATING_UNITS hou
WHERE 1=1
AND jzalv.lookup_type = jzav.tax_attr_class_type
 AND jzav.org_id = hou.organization_id
 AND jzalv.lookup_type   = UPPER('Organization_Class')
 AND hou.short_code= '&&';