1 Reply Latest reply on Jul 27, 2009 8:03 PM by Mike F -Oracle

    Prices in iProcurement

    713774
      How is the price field in iProcurement (11i) populated? What is the source of the information?
      Thanks,
        • 1. Re: Prices in iProcurement
          Mike F -Oracle
          If it is an item in the item master - the price is coming from there.

          If you put the item on a blanket or quotation - then the price will be seen from there.

          You can use the following query to assist in understanding where the price is coming from.

          Inventory item -

          select icip.* from icx_cat_item_prices icip, icx_cat_items_b icib
          where icip.rt_item_id = icib.rt_item_id
          and icib.internal_item_num = '&internal_item';


          One Time Item -

          select icip.* from icx_cat_item_prices icip, icx_cat_items_b icib
          where icip.rt_item_id = icib.rt_item_id
          and icib.supplier_part_num = '&supplier_item_number';


          This table shows the pricing and from what is the source.

          Regards,