Oracle EBS Latam Tax-Transaction Types Codes

Oracle EBS Latam Tax-Transaction Types Codes

Tables:-
JL_AR_AP_TRX_DGI_CODES

SQL Example:-

SELECT
a.TRX_CATEGORY  "Legal Transaction Category"
,a.TRX_LETTER "Transaction Letter"
,a.DGI_CODE "Transaction Type"
,b.DESCRIPTION "Description"
FROM
APPS.JL_AR_AP_TRX_DGI_CODES a,
APPS.fnd_lookups b,
APPS.fnd_lookup_values b1,
APPS.hz_geographies C,
APPS.xle_entity_profiles xep
WHERE 1=1
AND a.DGI_CODE=b.LOOKUP_CODE
AND b.LOOKUP_TYPE='JLAR_TAX_AUTHORITY_TRX_TYPE'
AND b.LOOKUP_TYPE=b1.LOOKUP_TYPE
AND b.LOOKUP_CODE=b1.LOOKUP_CODE
AND b1.lookup_type = 'JLAR_TAX_AUTHORITY_TRX_TYPE'
AND b1.LANGUAGE='AR'
AND b1.LANGUAGE=c.COUNTRY_CODE
AND c.COUNTRY_CODE='AR'
AND c.GEOGRAPHY_ID=xep.GEOGRAPHY_ID;