采购订单邮件发送预警设置

Select PAH.OBJECT_ID
  Into &POHEADERID
  from PO_ACTION_HISTORY PAH, PO_HEADERS_ALL PHA
 Where PAH.OBJECT_ID = PHA.PO_HEADER_ID
   And PAH.OBJECT_SUB_TYPE_CODE = PHA.TYPE_LOOKUP_CODE
   And PAH.ROWID = :ROWID
   And PHA.REVISION_NUM = 0
   And ACTION_CODE = 'APPROVE'
   And OBJECT_SUB_TYPE_CODE = 'STANDARD'
   And PAH.OBJECT_TYPE_CODE = 'PO'