UPDATE_TRANSFER_PRODUCT_IN_OUTLET_STWNSPOOR-17

SELECT * FROM p_trx_inventory WHERE doc_no = 'RGTOFO-1710-000093'

SELECT * FROM p_trx_inventory_item WHERE trx_inventory_id = 28 AND f_get_product_code(product_id) = 'OLI 029'

BEGIN

    DELETE FROM  p_trx_inventory_item WHERE trx_inventory_item_id = 153

END