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 |