[Home] [Help]
View: SO_RMA_MTL_INT_V
View Text
SELECT MTLSRI.RMA_LINE_ID
, SUM (NVL(MTLSRR.RECEIVED_QUANTITY
, 0)) RECEIVED_QUANTITY
, MAX(MTLSRR.RECEIPT_DATE) RECEIPT_DATE
, SUM (NVL(MTLSRR.ACCEPTED_QUANTITY
, 0)) ACCEPTED_QUANTITY
, MTLSRI.QUANTITY INTERFACED_QUANTITY
FROM MTL_SO_RMA_RECEIPTS MTLSRR
, MTL_SO_RMA_INTERFACE MTLSRI
WHERE MTLSRR.RMA_INTERFACE_ID(+) = MTLSRI.RMA_INTERFACE_ID GROUP BY MTLSRI.RMA_LINE_ID
, MTLSRI.QUANTITY
, MTLSRI.INVENTORY_ITEM_ID
, MTLSRI.COMPONENT_SEQUENCE_ID
Columns
Name |
RMA_LINE_ID |
RECEIVED_QUANTITY |
RECEIPT_DATE |
ACCEPTED_QUANTITY |
INTERFACED_QUANTITY |