VMMT_CLOSE_VW2

(SQL View)
 Index Back

Vchr Mass Mnt "Close" View

"Vouchers that can be Closed" 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 closed. (Note: references existing Search view for single voucher close component, VCHR_SRCH_CLOSE, in order to keep Where clause selection criteria consistent.)

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID FROM PS_VOUCHER A , PS_VCHR_CLOSE_ELIG B WHERE A.MANUAL_CLOSE_DT IS NULL AND (A.DOC_SEQ_NBR = ' ' OR EXISTS ( SELECT 'X' FROM PS_VMMT_DT_CLSE_VW I WHERE I.BUSINESS_UNIT_GL = A.BUSINESS_UNIT_GL)) AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.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 NOT EXISTS ( SELECT 'X' FROM PS_KK_SOURCE_HDR J , PS_VOUCHER_LINE K WHERE J.BUSINESS_UNIT = K.BUSINESS_UNIT AND J.VOUCHER_ID = K.VOUCHER_ID AND K.BUSINESS_UNIT_RECV <> ' ' AND K.RECEIVER_ID <> ' ' AND J.BUSINESS_UNIT = A.BUSINESS_UNIT AND J.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