[Home] [Help]
View: RCV_RECEIPTS_ALL_V
View Text
SELECT DISTINCT RCVSH.RECEIPT_NUM
, RCVSH.SHIPMENT_HEADER_ID
, RCVSH.VENDOR_ID
, POV.VENDOR_NAME
, RCVSH.RECEIPT_SOURCE_CODE
, RT.TRANSACTION_DATE
FROM RCV_SHIPMENT_HEADERS RCVSH
, PO_VENDORS POV
, RCV_TRANSACTIONS RT
WHERE RCVSH.RECEIPT_SOURCE_CODE = 'VENDOR'
AND RCVSH.VENDOR_ID = POV.VENDOR_ID
AND RT.SHIPMENT_HEADER_ID = RCVSH.SHIPMENT_HEADER_ID
Columns
Name |
RECEIPT_NUM |
SHIPMENT_HEADER_ID |
VENDOR_ID |
VENDOR_NAME |
RECEIPT_SOURCE_CODE |
TRANSACTION_DATE |