VMMT_UNPOST_VW2

(SQL View)
 Index Back

Vchr Mass Mnt "UnPost" View

"Vouchers that can be Unposted" filter view for Voucher Mass Maintenance Search Results; i.e., selects all eligible vouchers not currently in process with posting status such that vouchers can be unposted. (Note: references existing Search view for single voucher unpost component, VCHR_UNPST_SRCH, in order to keep Where clause selection criteria consistent.)

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID FROM PS_VOUCHER A , PS_VCHR_UNPST_ELIG B WHERE (A.DOC_SEQ_NBR = ' ' OR (EXISTS ( SELECT 'X' FROM PS_VMMT_DT_ACCR_VW I , PS_VMMT_DT_UNPS_VW J WHERE I.BUSINESS_UNIT_GL = A.BUSINESS_UNIT_GL AND J.BUSINESS_UNIT_GL = I.BUSINESS_UNIT_GL) AND NOT EXISTS ( SELECT 'X' FROM PS_VCHR_ACCTG_LINE K WHERE K.BUSINESS_UNIT = A.BUSINESS_UNIT AND K.VOUCHER_ID = A.VOUCHER_ID AND K.BUSINESS_UNIT_GL <> A.BUSINESS_UNIT_GL AND K.DOC_SEQ_NBR <> ' ' AND K.BUSINESS_UNIT_GL NOT IN ( SELECT L.BUSINESS_UNIT_GL FROM PS_VMMT_DT_IU_VW L)))) 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