1 Reply Latest reply on Jan 4, 2012 6:36 AM by 908793

    How to Identify Manual Receipts from rcv_shipment_headers & Lines table

    858905
      Hi,

      I'm building a Trigger on rcv_transaction table , I need to select all the Manual Receipts (not the receipts generated automatically using the ASN & RCV files).
      What condition should I use in the where clause for capturing only Manual Receipts?

      In the select statement i have only below tables for updating a custom table,so using below tables how can i filter the data for Manual Receipts?

      rcv_shipment_headers
      rcv_shipment_lines
      po_headers_all
      po_lines_all


      Thanks
      Pravin