CLO_STAT_PI_VW

(SQL View)
 Index Back

View for process instance

Filter process instance in CLOSE_STAT_TBL

SELECT DISTINCT PROCESS_INSTANCE FROM PS_CLOSE_STAT_TBL WHERE UNCLOSED = 'N' AND CLOSING_TYPE = 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance