Enabling Link to access Excel file in iProcurement

Enabling Link to access
Excel file in iProcurement  

                        Oracle iprocurement
module is widely used by oracle users to raise catalogue and non-catalogue
Purchase Requisitions. IProcurment module is very user friendly screen to raise
requisitions and hence it is most used module. 

                        We have a requirement
from one of our customer to show the Approved Supplier List in Oracle
iProcurement Page itself when the user Clicks a link under “Purchasing News”
Area.  The customer also wants to show
below details along with the approved Suppliers list.

                        This document describes
the Steps to get the above mentioned details and the steps to create a link in
iProcurement Page under “Purchasing News” Area.    The excel sheet which is stored in the
database will open when the user clicks the link in iprocurement Page.

                Write a SQL query to get the required data from the
database which need to be stored in the database and to retrive when the users
click the link. 

For
examble, below query is used to obtain the above data

SELECT
DISTINCT STORE.NAME store_name, smartforms.template_name request_name,

                pas.commodity_id,

                pas.vendor_name supplier,

                (SELECT NAME

                   FROM apps.hr_operating_units

                  WHERE organization_id =
smartforms.org_id) operating_unit,

                (SELECT segment1 || ‘.’ ||
segment2

                   FROM apps.mtl_categories_b

                  WHERE category_id =
smartforms.category_id) CATEGORY

           FROM apps.icx_cat_shop_stores_vl
STORE,

                apps.icx_cat_store_contents
store_contents,

               
apps.por_noncat_templates_all_vl smartforms,

                apps.po_asl_suppliers_v pas

          WHERE store_contents.store_id =
STORE.store_id(+)

            AND smartforms.template_id =
store_contents.content_id(+)

            AND smartforms.org_id IN (210,
2616)           

            AND pas.commodity_id =
smartforms.category_id

            AND pas.owning_organization_id IN (

                                      SELECT
organization_id

                                        FROM
apps.org_organization_definitions

                                       WHERE
operating_unit =

                                                            
smartforms.org_id)

       ORDER BY CATEGORY

The Sample output will be as
below.