SAC_RCVR_ID_V3 (SQL View)	Index Back
Receipt ID selection view Receipt ID selection view

SAC_RCVR_ID_V3

(SQL View)

Receipt ID selection view

SELECT DISTINCT RECEIVER_ID FROM PS_RECV_HDR A WHERE NOT EXISTS ( SELECT 'X' FROM PS_SAC_ERP_RCV_STS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RECEIVER_ID = B.RECEIVER_ID AND (B.SAC_INTG_RECV_STS = 'S' OR B.SAC_INTG_RECV_STS = 'E'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number