FND Design Data [Home] [Help]

View: RCV_RECEIPTS_ALL_V

Product: PO - Purchasing
Description: 10SC ONLY - Retrofitted
Implementation/DBA Data: ViewAPPS.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