DBA Data[Home] [Help]

APPS.OE_CANSRV dependencies on MTL_SO_RMA_INTERFACE

Line 450: UPDATE MTL_SO_RMA_INTERFACE MSRI

446:
447: IF V_LINE_TYPE_CODE = 'RETURN' THEN
448: IF ((V_S29 = 14) OR (V_S29 = 16) OR (V_S29 = 17)) THEN
449:
450: UPDATE MTL_SO_RMA_INTERFACE MSRI
451: SET MSRI.QUANTITY = (MSRI.QUANTITY
452: / (V_ORDERED_QUANTITY - (V_CANCELLED_QUANTITY
453: - V_REQUESTED_CANCEL_QTY))
454: * (V_ORDERED_QUANTITY - V_CANCELLED_QUANTITY))

Line 467: UPDATE MTL_SO_RMA_INTERFACE MSRI

463: AND (ORDERED_QUANTITY - V_CANCELLED_QUANTITY - V_RECEIVED_QUANTITY) > 0;
464:
465: IF DUMMY < 1 THEN
466:
467: UPDATE MTL_SO_RMA_INTERFACE MSRI
468: SET CLOSED_FLAG = 'Y'
469: WHERE MSRI.RMA_LINE_ID = V_LINE_ID
470: AND MSRI.SOURCE_CODE = V_SOURCE_CODE;
471: END IF;