1 Reply Latest reply on Apr 19, 2015 9:36 PM by Mohammed Ahmad

    Script to list PO number for a specific range of accounts code

    User579817-OC

      Helloo

       

      I need a script to list all PO numbers for a specific range of accounts code.  The script is used for inventory valuation.

       

      Grateful if anyone can help.

        • 1. Re: Script to list PO number for a specific range of accounts code
          Mohammed Ahmad

          Hello,

          Please, if this reply is late; just ignore it

           

          The following SQL select statement assumes that you know the charge/inv. valuation natural accounts and natural account segment is 2:

           

          select po_num, authorization_status, closed_code

          from PO_DISTRIBUTIONS_INQ_V a

          where destination_type_code = any ('INVENTORY', 'EXPENSE')

          and a.code_combination_id in

          (select b.code_combination_id from GL_CODE_COMBINATIONS_V b where segment2 = any ('170702110', '720201000'))

           

          '170702110', '720201000' are sample natural accounts

           

          Thanks