Oracle EBS Latam Tax-Latin Tax Categories

Oracle EBS Latam Tax-Latin Tax Categories

Tables:-
JL_ZZ_AR_TX_CATEGRY_V

SQL Example:-

SELECT
hou.name  "Name"
,jzv.tax_category "Tax Category"
 ,TO_CHAR(jzv.start_date_active,'DD-MM-YYYY') "Effective From"
 ,jzv.description "Category Description"
 ,jzv.threshold_check_level_desc  "Threshold Check"
 ,jzv.threshold_check_grp_by_desc_nb  "Grouping Condition Type"
 ,jzv.threshold_check_grp_by_desc "Grouping Condition"
 ,jzv.org_tax_attribute_desc    "Org Determing Condition"
 ,jzv.cus_tax_attribute "Cust Determining Condtion"
 ,jzv.txn_tax_attribute "Trans Determining Condition"
 ,jzv.mandatory_in_class  "Mandatory In Class"
 ,jzv.tax_code 
 ,jzv.tax_rate 
 ,jzv.tax_authority_code
 ,jzv.print_flag
 FROM
 APPS.JL_ZZ_AR_TX_CATEGRY_V jzv
 , APPS.hr_operating_units hou
 WHERE 1=1
 AND jzv.org_id = hou.organization_id;