APPS.WSH_DEL_OI_CORE dependencies on MTL_SERIAL_NUMBERS

Line 560: FROM MTL_SERIAL_NUMBERS S,

556: msg_string varchar2(200);
557: cursor validate_ser_num is
558: SELECT
559: 'valid serial number', S.CURRENT_STATUS
560: FROM MTL_SERIAL_NUMBERS S,
561: MTL_ITEM_LOCATIONS LOC
562: WHERE S.CURRENT_ORGANIZATION_ID = x_warehouse_id
563: AND S.INVENTORY_ITEM_ID = x_item_id
564: AND NVL( S.REVISION, '~' ) = NVL( x_revision, '~' )