PSXLATITEMTBL.FIELDVALUE = PSXLATITEM.FIELDVALUEĪND PSXLATITEMTBL.FIELDNAME = PSXLATITEM. Define the approval transaction registry. ![]() MAX (EFFSEQ) OVER (PARTITION BY EMPLID, EMPL_RCD, EFFDT) AS MAX_JOB_EFFSEQĪND j.EFFSEQ = J.MAX_JOB_EFFSEQ Get Process Defination With Trace Value SELECT PRCSNAME, PARMLIST FROM PS_PRCSDEFN WHERE UPPER(PARMLIST) LIKE '%TRACE%' AND PRCSTYPE = 'Application Engine' Read Data from Translate Table ( PSXLATITEM ) with Effective Dated SELECT DISTINCT PeopleSoft Enterprise Supply Chain Management 9.0 Common Information PeopleBook Using Workflow and Managing Approvals This chapter provides overviews of the approval workflow engine, approval workflow, and approval workflow tasks and discusses how to: Set up approval workflow process definitions. MAX (EFFDT) OVER (PARTITION BY EMPLID, EMPL_RCD) AS MAX_JOB_EFFDT, Please Use %CurrentDateIn Meta SQL instead of SYSDATE, for avoiding Database platform compatibility issue.įor More Information Please go through PeopleSoft AppEngine Meta SQL
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |