APPS.OE_CANCEL dependencies on MTL_SO_RMA_INTERFACE

Line 60: MTL_SO_RMA_INTERFACE MTLSRI

56: ELSE
57: SELECT NVL(SUM(NVL(MTLSRR.RECEIVED_QUANTITY,0)),0)
58: INTO RECEIVED_QUANTITY
59: FROM MTL_SO_RMA_RECEIPTS MTLSRR,
60: MTL_SO_RMA_INTERFACE MTLSRI
61: WHERE MTLSRR.RMA_INTERFACE_ID = MTLSRI.RMA_INTERFACE_ID
62: AND MTLSRI.RMA_LINE_ID IN
63: (SELECT LINE_ID
64: FROM SO_LINES

Line 292: UPDATE MTL_SO_RMA_INTERFACE MSRI

288: WHERE HEADER_ID = V_HEADER_ID
289: AND S29 IN (14,16,17);
290: begin
291: FOR rma1rec IN rma1 LOOP
292: UPDATE MTL_SO_RMA_INTERFACE MSRI
293: SET MSRI.QUANTITY = 0,
294: MSRI.CLOSED_FLAG = 'Y'
295: WHERE MSRI.RMA_LINE_ID = rma1rec.LINE_ID
296: AND MSRI.SOURCE_CODE = V_SOURCE_CODE

Line 533: MTL_SO_RMA_INTERFACE MTLSRI

529: ((V_ORDER_QTY - NVL(V_CANCELLED_QTY,0))
530: / MAX(MTLSRI.QUANTITY))),0))
531: INTO RECEIVED_QTY
532: FROM MTL_SO_RMA_RECEIPTS MTLSRR,
533: MTL_SO_RMA_INTERFACE MTLSRI
534: WHERE MTLSRR.RMA_INTERFACE_ID = MTLSRI.RMA_INTERFACE_ID
535: AND MTLSRI.RMA_LINE_ID = V_LINE_ID
536: GROUP BY MTLSRI.INVENTORY_ITEM_ID,
537: MTLSRI.COMPONENT_SEQUENCE_ID;