Oracle EBS Latam Tax-Company WTH Applicability

Oracle EBS Latam Tax-Company WTH Applicability

Tables:-
JL_ZZ_AP_COMP_AWT_TYPES

SQL Example:-

SELECT
c.name  "Operating Unit"
,b.name "Legal Entity"
,awt_type_code  "With Holding Tax Type"
,wh_agent_flag  "WH Agent Flag"
,payment_city   "Payment City"
FROM
APPS.JL_ZZ_AP_COMP_AWT_TYPES a
,APPS.XLE_ENTITY_PROFILES b
,APPS.HR_OPERATING_UNITS c
WHERE 1=1
AND a.legal_entity_id = b.legal_entity_id
AND b.legal_entity_id   = c.default_legal_context_id ;