EM_MTRCBH_1LANG

(SQL View)
 Index Back

Buyer Home - Approve

Returns a summary of the number of vouchers ready to be approved. Used in the Buyer Home metric.

SELECT A.OPRID ,B.LANGUAGE_CD , B.XLATLONGNAME , ' ' FROM PS_EM_VCHR_SRCH A , PSXLATITEMLANG B WHERE B.FIELDNAME = 'EM_INV_PYMNT_STAT' AND B.FIELDVALUE = 'I' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PSXLATITEMLANG B1 WHERE B1.FIELDNAME = B.FIELDNAME AND B1.FIELDVALUE = B.FIELDVALUE AND B1.LANGUAGE_CD = B.LANGUAGE_CD AND B1.EFFDT <= %CurrentDateIn) GROUP BY A.OPRID,B.LANGUAGE_CD , B.XLATLONGNAME

  • Related Language Record for EM_MTRCBH_VW1S

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency