[Home] [Help]
View: ICX_SO_RMA_MTL_INT_DETAIL_V
Product: | ICX - Oracle iProcurement |
Description: | Obsolete |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
RMA_LINE_ID |
RECEIVED_QUANTITY |
RECEIPT_DATE |
ACCEPTED_QUANTITY |
INTERFACED_QUANTITY |
DETAIL_LINE_ID |