1 Reply Latest reply: Jun 11, 2013 7:02 AM by Azadare M RSS

    Automate Sub inventory transfer

    Azadare M
      Hi All,

      My org have an existing MES-Oracle interface and now our business need is to perform sub inventory transfer.

      I have a staging table XXXX_MES_BACK_FLUSH and a interface table MTL_TRANSACTIONS_INTERFACE
      I need to transfer data from XXXX_MES_BACK_FLUSH table to MTL_TRANSACTIONS_INTERFACE table where transaction type description should be 'Subinventory Transfer'
      Here I want know that which tables should be used here for the above requirements?and what are necessary are required for this?from which table I can select data and from which tables I can insert data?