1 Reply Latest reply on Aug 25, 2008 12:06 PM by 560941

    Identify Requisition from Iprocurment

    656616
      Hello ,

      Is There a way to Idntify Requisition that came from the Iprocurment and not from the application ??

      Gil
        • 1. Re: Identify Requisition from Iprocurment
          560941
          Hi,

          Look for APPS_SOURCE_CODE column in PO_REQUISITION_HEADERS table. This should be populated with 'POR' for iProc requisitions.

          To list all the requisitions came from iProc use the script below :

          SELECT * FROM PO.PO_REQUISITION_HEADERS_ALL WHERE APPS_SOURCE_CODE = 'POR'

          Rgds,
          Bala