Oracle EBS Latam Tax-State Province

Oracle EBS Latam Tax-State Province

Tables:-
FND_LOOKUP_TYPES_VL
FND_LOOKUP_VALUES_VL

SQL Example:-

SELECT
fltv.lookup_type
,fltv.meaning
,fav.application_name
,fltv.description
,DECODE(fltv.customization_level,'U','User','','Other') "Access Level"
,flvv.lookup_code
,flvv.meaning "Line Meaning"
,flvv.description "Line Desc"
,flvv.tag
,TO_CHAR(flvv.start_date_active,'DD-MM-YYYY') "Start Date Active"
,TO_CHAR(flvv.end_date_active,'DD-MM-YYYY') "End Date Active"
,flvv.enabled_flag
FROM
APPS.FND_LOOKUP_TYPES_VL fltv
,APPS.FND_LOOKUP_VALUES_VL flvv
,APPS.FND_APPLICATION_VL FAV
WHERE 1=1
AND fltv.lookup_type  =flvv.lookup_type
AND fltv.application_id = fav.application_id
AND fav.application_name IN ('Latin America Localizations')
AND fltv.lookup_type = 'JLZZ_STATE_PROVINCE';