" Delete FROM PS_MCFEM_MAIL_MAIN WHERE MCF_EMAIL_ID in ('77583','77589' ) "
Above Table is used to store Email details with XML text send through mail. Data gets stored in this table once RB_EMAIL_READ Process it from RB_IN_EMAIL table.
"Delete FROM PS_RB_IN_EMAIL where MCF_EMAIL_ID in ('77583','77589' ) " --
Table is used to store any new mail send to Peoplesoft.
"Delete FROM PS_RB_CLASSIFY_TBL" --
Table used by RB_STR_EMAIL for Processing Email
Above Table is used to store Email details with XML text send through mail. Data gets stored in this table once RB_EMAIL_READ Process it from RB_IN_EMAIL table.
"Delete FROM PS_RB_IN_EMAIL where MCF_EMAIL_ID in ('77583','77589' ) " --
Table is used to store any new mail send to Peoplesoft.
"Delete FROM PS_RB_CLASSIFY_TBL" --
Table used by RB_STR_EMAIL for Processing Email
No comments:
Post a Comment