9/1/2023 0 Comments Awe setup in peoplesoft query![]() ![]() While &admin_sql.Fetch(&oprid, &SIGN_AUTH) Local SQL &admin_sql = CreateSQL("select OPRID ,MERCHANDISE_AMT from PS_ZZ_WF_AUTH_VW D START WITH D.OPRID = :1 CONNECT BY PRIOR SUPERVISOR_ID = D.OPRID", &aryPrevOpr_ ) ![]() SQLExec("SELECT sum(A.MERCHANDISE_AMT) FROM PS_REQ_LINE A WHERE A.REQ_ID = :1 AND A.BUSINESS_UNIT = :2 ", &thread_.REQ_ID.Value, &thread_.BUSINESS_UNIT.Value, &req_amt) SQLExec("SELECT B.REQUESTOR_ID, B.ORIGIN FROM PS_REQ_HDR B WHERE B.REQ_ID = :1 AND B.BUSINESS_UNIT = :2", &thread_.REQ_ID.Value, &thread_.BUSINESS_UNIT.Value, &REQUESTOR, &ORIGIN) Local number &req_amt, &SIGN_AUTH, &PREV_SIGN_AUTH Local array of string &oprid_arr = CreateArrayRept("", 0) + Extends/implements EOAW_CORE:DEFN:UserListBase.GetUsers +/ %Super = create EOAW_CORE:DEFN:UserListBase(&rec_) ![]() Method GetUsers(&aryPrevOpr_ As array of string, &thread_ As Record) Returns array of string Class ZZ_ApprUserList extends EOAW_CORE:DEFN:UserListBase ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |