RSF_WF_LEAD_LVW

(SQL View)
 Index Back

CRM Workflow Action Request VW

CRM Workflow Action Request View

SELECT D.LANGUAGE_CD , D.DESCR50 FROM PSWORKLIST A , PS_RSF_LEAD_WL1 B , PS_RSF_LEAD C ,PS_RSF_LEAD_LANG D WHERE A.BUSPROCNAME = B.BUSPROCNAME AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.EVENTNAME = B.EVENTNAME AND A.WORKLISTNAME = B.WORKLISTNAME AND A.INSTANCEID = B.INSTANCEID AND A.INSTSTATUS <= 2 AND B.LEAD_ID = C.LEAD_ID AND C.LEAD_ID = D.LEAD_ID

  • Related Language Record for RSF_WF_LEAD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50