RECV_RC_VW4

(SQL View)
Index Back

Receipt ID RC Search

Date Initials Reference# Description 09/15/2010 Nash: 2016893001 Modified the SQL in the view so that Receipt ID prompt list on Process Receipts page displays correct list of receipts. 05/03/2016 JINGTLI:23075328 Modified the SQL in the view so that canceled Receipt ID can be displayed in the prompting list on Process receipts page

SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.PO_RECEIPT_FLG , A.SHIPTO_ID , A.VENDOR_ID , B.NAME1 , A.RECEIPT_DT , A.RECV_STATUS FROM PS_RECV_HDR A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND (A.RECV_STATUS = 'R' OR A.RECV_STATUS = 'X') AND (A.INTFC_ASSET = 'Y' OR A.INTFC_INVENTORY = 'Y' OR A.INTFC_MG = 'Y' OR A.RUN_CLOSE_SHORT = 'Y' OR EXISTS ( SELECT 'Y' FROM PS_RECV_LN_SHIP L WHERE L.BUSINESS_UNIT = A.BUSINESS_UNIT AND L.RECEIVER_ID = A.RECEIVER_ID AND L.PROCESS_COMPLETE <> 'Y'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 PO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL PO Receipt Flag - identifies if the receipt is related to a purchase order
4 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 RECEIPT_DT Date(10) DATE Received Date
8 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled