PTSF_ES_DT_VW

index back

SELECT DISTINCT Q.PTSF_SBO_NAME , Q.PROCESS_INSTANCE , Q.PTSF_ES_DT_ERR_SEQ , Q.PTSF_SRCH_ENG_INS FROM PS_PTSF_ES_DT_ERR1 Q , PS_PTSF_ES_DT_ERR2 R WHERE Q.PTSF_SBO_NAME=R.PTSF_SBO_NAME AND Q.PROCESS_INSTANCE=R.PROCESS_INSTANCE AND Q.PTSF_ES_SEG_NO=R.PTSF_ES_SEG_NO AND Q.PTSF_ES_DT_ERR_SEQ = R.PTSF_ES_DT_ERR_SEQ

PeopleSoft Field Name Field Type Column Type Description
PTSF_SBO_NAME Character(65) VARCHAR2(65) NOT NULL Search Definition (see PSPTSF_SD).

Prompt Table: PTSF_DEP_SBO_VW

PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
PTSF_ES_DT_ERR_SEQ Number(5,0) INTEGER NOT NULL Sequence Number
PTSF_SRCH_ENG_INS Character(30) VARCHAR2(30) NOT NULL Search Instance Name
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20