|
SELECT A.BUSINESS_UNIT , A.VOUCHER_ID FROM PS_VOUCHER A , PS_INSTALLATION K WHERE ((A.POST_STATUS_AP = 'P' AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF F , PS_PYMNT_VCHR_WTHD G WHERE F.BUSINESS_UNIT = A.BUSINESS_UNIT AND ((F.VOUCHER_ID = A.VOUCHER_ID) OR (F.VOUCHER_ID = A.VOUCHER_ID_RELATED)) AND F.BUSINESS_UNIT = G.BUSINESS_UNIT AND F.VOUCHER_ID = G.VOUCHER_ID AND F.PYMNT_CNT = G.PYMNT_CNT AND ((F.POST_STATUS_WTHD <> 'X' OR F.POST_STATUS_WTHD = 'U') AND F.PYMNT_SELCT_STATUS NOT IN( 'C','P','X','S'))) AND NOT EXISTS ( SELECT 'X' FROM PS_PYMNT_VCHR_XREF F2 WHERE F2.BUSINESS_UNIT = A.BUSINESS_UNIT AND ((F2.VOUCHER_ID = A.VOUCHER_ID) OR (F2.VOUCHER_ID = A.VOUCHER_ID_RELATED)) AND F2.PYMNT_SELCT_STATUS NOT IN ('C','P','X','S'))) OR (A.ENTRY_STATUS = 'X')) AND ((K.PO = 'N') OR (K.PO = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_VOUCHER_LINE I , PS_PO_HDR J WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.VOUCHER_ID = A.VOUCHER_ID AND I.PO_ID <> ' ' AND A.ENTRY_STATUS <> 'X' AND I.BUSINESS_UNIT_PO = J.BUSINESS_UNIT AND I.PO_ID = J.PO_ID AND J.PO_STATUS NOT IN ('C','PX','X'))))
|