MTCH_VCHR_WF_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , C.BUSINESS_UNIT_PO , C.PO_ID , C.LINE_NBR , C.BUSINESS_UNIT_RECV , C.RECEIVER_ID , C.RECV_LN_NBR , A.MATCH_CNTRL_ID , A.MATCH_RULE_ID , C.BUYER_ID FROM PS_AP_MTCH_EXCPTN A , PS_AP_MTCH_RULES B , PS_VCHR_MTCH_DETLS C , PS_VOUCHER D WHERE A.MATCH_RULE_ID = B.MATCH_RULE_ID AND A.PROCESS_INSTANCE = C.PROCESS_INSTANCE AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.VOUCHER_ID AND A.VOUCHER_LINE_NUM = C.VOUCHER_LINE_NUM AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND D.VCHR_SRC <> 'SSI' AND NOT EXISTS ( SELECT 'X' FROM PS_MTCH_VCHR_WL VCHR , PSWORKLIST WL WHERE WL.BUSPROCNAME = 'MATCHING_ERRORS' AND WL.ACTIVITYNAME = 'ANALYZE MATCHING ERRORS' AND WL.EVENTNAME = 'Route Matching Errors' AND WL.WORKLISTNAME = 'Matching Errors' AND WL.BUSPROCNAME = VCHR.BUSPROCNAME AND WL.ACTIVITYNAME = VCHR.ACTIVITYNAME AND WL.EVENTNAME =VCHR.EVENTNAME AND WL.WORKLISTNAME = VCHR.WORKLISTNAME AND WL.INSTANCEID = VCHR.INSTANCEID AND WL.TRANSACTIONID = VCHR.TRANSACTIONID AND WL.INSTSTATUS IN (0,1) AND VCHR.BUSINESS_UNIT = A.BUSINESS_UNIT AND VCHR.VOUCHER_ID = A.VOUCHER_ID AND VCHR.VOUCHER_LINE_NUM = A.VOUCHER_LINE_NUM AND VCHR.MATCH_RULE_ID = A.MATCH_RULE_ID) UNION SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , '' , '' , 0 , '' , '' , 0 , A.MATCH_CNTRL_ID , A.MATCH_RULE_ID , '' FROM PS_AP_MTCH_EXCPTN A , PS_AP_MTCH_RULES B , PS_VOUCHER D WHERE A.MATCH_RULE_ID = B.MATCH_RULE_ID AND B.MTCH_RULE_LEVEL = 'HS' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND D.VCHR_SRC <> 'SSI' AND NOT EXISTS ( SELECT 'X' FROM PS_MTCH_VCHR_WL VCHR , PSWORKLIST WL WHERE WL.BUSPROCNAME = 'MATCHING_ERRORS' AND WL.ACTIVITYNAME = 'ANALYZE MATCHING ERRORS' AND WL.EVENTNAME = 'Route Matching Errors' AND WL.WORKLISTNAME = 'Matching Errors' AND WL.BUSPROCNAME = VCHR.BUSPROCNAME AND WL.ACTIVITYNAME = VCHR.ACTIVITYNAME AND WL.EVENTNAME = VCHR.EVENTNAME AND WL.WORKLISTNAME = VCHR.WORKLISTNAME AND WL.INSTANCEID = VCHR.INSTANCEID AND WL.TRANSACTIONID = VCHR.TRANSACTIONID AND WL.INSTSTATUS IN (0, 1) AND VCHR.BUSINESS_UNIT = A.BUSINESS_UNIT AND VCHR.VOUCHER_ID = A.VOUCHER_ID AND VCHR.VOUCHER_LINE_NUM = A.VOUCHER_LINE_NUM AND VCHR.MATCH_RULE_ID = A.MATCH_RULE_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
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
8 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
9 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
10 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
11 MATCH_RULE_ID Character(10) VARCHAR2(10) NOT NULL Match Rule ID
12 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer