View: SO_RMA_MTL_INT_DETAIL_V

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_RMA_MTL_INT_DETAIL_V

View Text

SELECT MTLSRI.RMA_LINE_ID
, SUM(NVL(MTLSRR.RECEIVED_QUANTITY
, 0))/LD.COMPONENT_RATIO RECEIVED_QUANTITY
, MAX(MTLSRR.RECEIPT_DATE) RECEIPT_DATE
, SUM (NVL(MTLSRR.ACCEPTED_QUANTITY
, 0)) ACCEPTED_QUANTITY
, MTLSRI.QUANTITY INTERFACED_QUANTITY
, LD.LINE_ID DETAIL_LINE_ID
FROM MTL_SO_RMA_RECEIPTS MTLSRR
, MTL_SO_RMA_INTERFACE MTLSRI
, SO_LINE_DETAILS LD
WHERE MTLSRR.RMA_INTERFACE_ID(+) = MTLSRI.RMA_INTERFACE_ID
AND LD.INVENTORY_ITEM_ID(+) = MTLSRI.INVENTORY_ITEM_ID GROUP BY MTLSRI.RMA_LINE_ID
, MTLSRI.QUANTITY
, MTLSRI.INVENTORY_ITEM_ID
, MTLSRI.COMPONENT_SEQUENCE_ID
, LD.LINE_ID
, LD.COMPONENT_RATIO

Columns