Oracle EBS Latam Tax-LAT JL CITY

Oracle EBS Latam Tax-LAT JL CITY

Tables:-
FND_LOOKUP_TYPES_VL
FND_LOOKUP_VALUES_VL
SQL Example:-

SELECT
fltv.lookup_type  "Lookup Type"
,fltv.meaning "Meaning"
 ,fav.application_name  "Application Name"
 ,fltv.description  "Description"
 ,DECODE(fltv.customization_level,'U','User','','Other')  "Access Level"
 ,flvv.lookup_code
 ,flvv.meaning
 ,flvv.description
 ,flvv.tag
 ,TO_CHAR(flvv.start_date_active,'DD-MM-YYYY')
 ,TO_CHAR(flvv.end_date_active,'DD-MM-YYYY')
 ,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 = '&&STATE_PROVINCE';