PSCBAPPCLS_VW

 index back

Application Package Paths


SELECT DISTINCT OBJECTVALUE1 AS PACKAGEROOT , CASE WHEN OBJECTVALUE5 = 'OnExecute' THEN OBJECTVALUE2 %Concat ':' %Concat OBJECTVALUE3 WHEN OBJECTVALUE4 = 'OnExecute' THEN OBJECTVALUE2 ELSE ':' END AS QUALIFYPATH , CASE WHEN OBJECTVALUE5 = 'OnExecute' THEN OBJECTVALUE4 WHEN OBJECTVALUE4 = 'OnExecute' THEN OBJECTVALUE3 ELSE OBJECTVALUE2 END AS APPCLASSID FROM PSPCMPROG WHERE PROGSEQ = 0 AND OBJECTID1 = 104 AND PROGEXTENDS = 'PTCBAPPLSVCDEFN:ApplicationServiceBase'

PeopleSoft Field Name Field Type Column Type Description
PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20