EM_VOAPR_EML_VW

(SQL View)
 Index Back

Voucher Approval Email view

View that returns the UserIDs of the approvers with voucher approvals pending. Used for workflow processing (email notification).

SELECT DISTINCT A.OPRID , B.EMAILID , B.DESCR FROM PS_SEC_BU_OPR A , PS_ROLEXLATOPR B , PSROLEUSER C , PS_EM_BUY_REG_TBL D , PS_EM_VCHR_APR_DAT F WHERE B.ROLEUSER=C.ROLEUSER AND A.OPRID=B.OPRID AND C.ROLENAME IN ( SELECT G.EM_ROLENAME FROM PS_EM_BUYER_APPR G , PS_EM_VCHR_APR_DAT H , PS_VOUCHER I WHERE G.BUSINESS_UNIT = H.BUSINESS_UNIT AND H.BUSINESS_UNIT = I.BUSINESS_UNIT AND H.VOUCHER_ID = I.VOUCHER_ID AND G.EM_ROLENAME = H.ROLENAME AND H.CURRENT_STATUS = 'Y' AND I.APPR_STATUS <> 'A' AND G.BUSINESS_UNIT = F.BUSINESS_UNIT ) AND A.BUSINESS_UNIT=F.BUSINESS_UNIT AND F.ROLENAME=C.ROLENAME AND A.BUSINESS_UNIT=D.BUSINESS_UNIT AND D.EM_EMAIL_INV_APPR='Y' AND F.CURRENT_STATUS='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description