India Local Payables Tax type

Query to find out the localization Tax Type for Purchasing Module


SELECT typ.lookup_type tax_lookup_type, typ.meaning tax_lookup_type_meaning,
       typ.description tax_lookup_type_desc, val.lookup_code tax_type,
       val.meaning tax_type_meaning, val.description tax_type_desc,
       val.enabled_flag, val.start_date_active, val.end_date_active
  FROM fnd_lookup_types_vl typ, fnd_lookup_values_vl val
 WHERE typ.lookup_type = val.lookup_type
   AND val.lookup_type = 'JAI_TAX_TYPE'
   AND val.end_date_active IS NULL
   AND val.enabled_flag = 'Y'