Oracle EBS Latam Tax-Latin Tax Profiles

Oracle EBS Latam Tax-Latin Tax Profiles

Tables:-
JL_ZZ_AR_TX_CATEG_ALL
JL_ZZ_AR_TX_CUS_CLS_ALL

SQL Example:-

SELECT DISTINCT ---'JL','Q_LAT_TAX_PROFILES','DATA','E',
 hou.name "Operating Unit"
 ,tc.tax_category "Tax Category"
 ,tcac.tax_attribute_name
,SUBSTR(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tcac.tax_attribute_name, 'CONTRIBUTOR_ATTRIBUTE'),1,80)  "Condition Code"
,tcac.tax_attribute_value "Value Code"
,SUBSTR(JL_ZZ_AR_TX_LIB_PKG.get_lookup_meaning(tcac.tax_attribute_value, 'JLZZ_AR_TX_ATTR_VALUE'),1,80)  "Value Meaning"
,tcac.enabled_flag  "Enabled Flag"
FROM
JL_ZZ_AR_TX_CATEG_ALL tc
,JL_ZZ_AR_TX_CUS_CLS_ALL tcac
,HR_OPERATING_UNITS hou
WHERE 1=1
AND tcac.tax_category_id = tc.tax_category_id
AND tcac.org_id = hou.organization_id;