Oracle Apps Knowledge Sharing

Query to fetch defined Base Descriptor Details in Oracle iProcurement (ICX_CAT_ATTRIBUTES_TL)

                In this post, we have a given a query which helps you to fetch the base descriptor details defined at catalog level. This is the same information which is shown while requester in item details screen after searching a catalog item in Oracle iProcurement. 

Key Tables:

ICX_CAT_ATTRIBUTES_TL

Query: 

SELECT attribute_id,
       sequence,
       attribute_name, 
       description,
       DECODE(searchable,1,'YES','NO') searchable,
       DECODE(search_results_visible,1,'YES','NO') visible_on_search_results,
       DECODE(item_detail_visible,1,'YES','NO') visible_on_item_detail_screen,       
       stored_in_table, 
       stored_in_column,
       creation_date
  FROM icx_cat_attributes_tl  icat
 WHERE language = 'US';
 

Hope it helps!!