Oracle EBS Latam Tax-Latin Tax Lookup

Oracle EBS Latam Tax-Latin Tax Lookup

Tables:-
FND_FLEX_VALUES_VL
FND_FLEX_VALUE_SETS

SQL Example:-

SELECT
ffvv.flex_value
,ffvv.flex_value_meaning
 ,ffvv.description
 ,ffvv.enabled_flag
 ,TO_CHAR(ffvv.start_date_active,'DD-MM-YYYY')
 ,TO_CHAR(ffvv.end_date_active,'DD-MM-YYYY')
 ,ffvs.flex_value_set_name
 FROM APPS.FND_FLEX_VALUES_VL FFVV
 ,APPS.FND_FLEX_VALUE_SETS FFVS
 WHERE 1=1
 AND ffvv.flex_value_set_id = ffvs.flex_value_set_id
 AND ffvs.flex_value_set_name = '&&';