Results 1 to 3 of 3

Thread: update PO help

  1. #1
    Join Date
    Nov 2005
    Posts
    6

    Unanswered: update PO help

    Hi Gurus,

    In oracle PO there is CLOSED_CODE we want to 'FINALLY CLOSED' all PO which have the CLOSED_CODE ='CLOSED' and the PO's are 30 days old like all the closed to finally closed we dont want to go one by one is there a updte statment any help and any thing to look for or any automatic way do it. we have a othere ERP that recoginise only FINALLY CLOSED

    Thanks in advance

  2. #2
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    Code:
    update PO
    set CLOSED_CODE = 'FINALLY CLOSED' 
    where CLOSED_CODE = 'CLOSED'
    and sysdate - PO_DATE >= 30;

  3. #3
    Join Date
    Nov 2005
    Posts
    6
    Thanks buddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •