VMMT_RPLCDE_VW2

(SQL View)
 Index Back

Vchr Mass Mnt "Delete" View

"Vouchers that can be Deleted" filter view for Voucher Mass Maintenance Search Results; i.e., selects all eligible vouchers not currently in process with posting/payment statuses such that vouchers can be deleted. (Note: references existing Search view for single voucher delete component, VCHR_SRCH_DEL, in order to keep Where clause selection criteria consistent.) Note: Formerly shared selection criteria with Field Replacement maintenance operation, now implemented as separate filter view (as criteria have diverged somewhat).

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID FROM PS_VOUCHER A , PS_VCHR_DEL_ELIG B WHERE (A.MATCH_STATUS_VCHR <> 'M' OR A.ENTRY_STATUS = 'L') AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF I WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.VOUCHER_ID = A.VOUCHER_ID AND (I.PYMNT_ID <> ' ' OR I.PYMNT_SELCT_STATUS = 'R' OR NET_SELCT_STATUS IN ('H','S'))) AND NOT EXISTS ( SELECT 'X' FROM PS_VCHR_ACCTG_LINE J WHERE J.BUSINESS_UNIT = A.BUSINESS_UNIT AND J.VOUCHER_ID = A.VOUCHER_ID) AND NOT EXISTS ( SELECT 'X' FROM PS_VMMT_RELATED_VW D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.VOUCHER_ID = A.VOUCHER_ID ) AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.VOUCHER_ID = A.VOUCHER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID