PSAERSOUTDSVW |
index back |
---|
SELECT DISTINCT O.OUTDESTTYPE , %Substring(X.XLATLONGNAME , 1, 10) FROM PS_PRCSOUTPUTLIST O , PS_PRCSOUTDESTTYPE P , PSXLATITEM X WHERE O.OUTDESTTYPE = X.FIELDVALUE AND X.FIELDNAME = 'OUTDESTTYPE' AND O.ACTIVE_FLAG = '1' AND O.GENPRCSTYPE = P.GENPRCSTYPE AND O.OUTDESTTYPE = P.OUTDESTTYPE AND O.GENPRCSTYPE = '5' AND O.OUTDESTTYPE IN ('2','4', '5', '6') AND P.ACTIVE_FLAG = '1' |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
![]() |
Character(3) | VARCHAR2(3) NOT NULL |
Process Request output destination type.
0=Any 1=(None) 2=File 3=Printer 4=Window 5=Email 6=Web 7=Default 8=Feed 9=IB Node |
OUTDESTTYPEDESCR | Character(10) | VARCHAR2(10) NOT NULL | Process Scheduler Destination Type |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |