EX_SES_DEL_VW

(SQL View)
 Index Back

PTSF Expense line delete view.

PTSF Expense line delete view.

SELECT DISTINCT A.SHEET_ID , A.LINE_NBR , B.PSARCH_EVENTDTTM FROM PS_EX_SHEET_LINE_H A , PSARCHAUDIT B WHERE A.PSARCH_ID = B.PSARCH_ID AND A.PSARCH_BATCHNUM = B.PSARCH_BATCHNUM AND B.RECNAME = 'EX_SHEET_LINE' AND NOT EXISTS ( SELECT 'X' FROM PS_EX_SHEET_LINE LINE WHERE LINE.SHEET_ID = A.SHEET_ID AND LINE.LINE_NBR = A.LINE_NBR) UNION SELECT AA.SHEET_ID , AA.LINE_NBR , AA.DELETE_DTTM FROM PS_EX_SES_LINE_DEL AA WHERE NOT EXISTS ( SELECT 'X' FROM PS_EX_SHEET_LINE LINE1 WHERE LINE1.SHEET_ID = AA.SHEET_ID AND LINE1.LINE_NBR = AA.LINE_NBR)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
2 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
3 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp