My Training Notes & Tutorials

Code Snippet of the Week

From the post: Tax Classification Set Code Assignments

SELECT DISTINCT 
       SET_CODE AS "Set Code", 
       SET_NAME AS "Set Name", 
       v.lookup_type AS "Set Assignments" 
   FROM 
       FND_SETID_SETS s 
       JOIN fnd_lookup_values v 
       ON s.set_id = v.set_id 
   WHERE 
       v.lookup_type IN ('ZX_OUTPUT_CLASSIFICATIONS', 'ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS') 
       AND s.language = 'US' 
       AND v.set_id IN 
       ( 
           SELECT set_id 
           FROM fnd_lookup_values 
           WHERE lookup_code='rate code' 
       ) 
   ORDER BY 1, 2, 3;

My Training Notes & Tutorials

Code Snippet of the Week

Explore Topics