RECV_AM_VW

(SQL View)
Index Back

Receipt Line AM View


SELECT DISTINCT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECEIPT_DT , A.VENDOR_ID FROM PS_RECV_HDR A , PS_VENDOR B , PS_RECV_LN_ASSET C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RECEIVER_ID = C.RECEIVER_ID AND A.RECV_STATUS NOT IN ('C','X') AND A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND C.BUSINESS_UNIT_AM <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECEIPT_DT Date(10) DATE Received Date
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_POVW1